polardbxengine/mysql-test/suite/ndb_ddl/table_event.test

50 lines
1.3 KiB
Plaintext

#
# Check that events have been created in NDB for the tables
# that can be binlogged or otherwise need an event created
#
--source setup.inc
# Retrieve the list of events created in NDB
--source retrieve_event_list.inc
# Check that event have been created for mysql.ndb_apply_status
let $check_event_dbname = mysql;
let $check_event_tabname = ndb_apply_status;
--source check_event_for_table.inc
# Check that event have been created for mysql.ndb_schema
let $check_event_dbname = mysql;
let $check_event_tabname = ndb_schema;
--source check_event_for_table.inc
# Check that event have been created for mysql.ndb_schema_result
let $check_event_dbname = mysql;
let $check_event_tabname = ndb_schema_result;
--source check_event_for_table.inc
# Check events for the standard test tables
let $counter = 1;
while ($counter <= $num_tables)
{
# Default table name is t$counter, ie. t1, t2, etc
let $tx=t$counter;
if ($counter == 9)
{
# Table t9 have hidden pk and blobs, binlogging of such
# table is not supported -> no event exist
echo NOTE! t9 have hidden pk and blobs -> no event;
}
#
# Check that table have event
#
let $check_event_dbname = ndb_ddl_test;
let $check_event_tabname = $tx;
--source check_event_for_table.inc
inc $counter;
}
--source cleanup.inc