tablespace script behavior with views

Bug #666515 reported by Darren Cassar
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
crib
Fix Released
High
Darren Cassar

Bug Description

alter tablespace.sh to include "and engine is not null" :

mysql -u$SRC_USER -p$SRC_PASSWORD -h$SRC_HOSTNAME -P$SRC_PORT crib_client -e "CREATE TABLE $rand as SELECT $INSTANCE_ID, current_timestamp(), table_schema, table_name, engine, ROUND(data_length/1024/1024,0), ROUND(index_length/1024/1024,0), ROUND(data_length/1024/1024,0)+ROUND(index_length/1024/1024,0), ROUND(data_free/1024/1024,0), table_rows FROM information_schema.tables WHERE table_schema != 'information_schema' and table_schema != 'mysql' and table_schema != 'securich' and table_schema != 'crib_client' and table_schema not like '%test%' and engine is not null"

Changed in crib:
status: Confirmed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.