mysql-test/suite/ndb_ddl/count_temp_tables.inc
raw| 1 | # |
| 2 | # Print number of tables with temp name present in NDB. |
| 3 | # |
| 4 | # This needs to be run after a COPY ALTER to verify that the |
| 5 | # tables with temp names don't exist in NDB. |
| 6 | # |
| 7 | |
| 8 | |
| 9 | --disable_query_log ONCE |
| 10 | # Print the number of tables with temp name |
| 11 | SELECT COUNT(*) AS 'Number of tables with temp name in NDB' |
| 12 | FROM ndbinfo.dict_obj_info |
| 13 | WHERE type = 2 /* User table */ AND |
| 14 | SUBSTRING_INDEX(fq_name, '/', -1) LIKE "#sql%"; |