mysql-test/suite/ndb_ddl/hidden_ndb_schema_table.test
raw| 1 | --source connect.inc |
| 2 | |
| 3 | # |
| 4 | # The mysql.ndb_schema table should be not be visible in SHOW TABLES |
| 5 | # or I_S.TABLES |
| 6 | # |
| 7 | |
| 8 | # Iterate all mysqlds and check table is hidden everywhere |
| 9 | let $i = $NUM_MYSQLDS; |
| 10 | while($i) |
| 11 | { |
| 12 | --connection mysqld$i |
| 13 | |
| 14 | SHOW TABLES FROM mysql LIKE 'ndb_schema'; |
| 15 | SELECT count(1) FROM INFORMATION_SCHEMA.TABLES |
| 16 | WHERE TABLE_SCHEMA = 'mysql' AND TABLE_NAME = 'ndb_schema'; |
| 17 | |
| 18 | dec $i; |
| 19 | } |
| 20 |