# Inc file to check if parent's metadata is flushed out when child's # table definition is updated. # It does the following : # 1. Cache parent table definition in server1 # 2. Run the given DDL in server2 # 3. Run 'alter .. change column a ..' on parent at server1 # to check if the cached table has been flushed out # # Input : # $ddl_query : The DDL query to run in server2. # $expect_alter_failure : Updating parent's column 'a' in server1 after # running $ddl_query in server2 is expected to # fail if this value is set to 1 and expected to # pass if the value is set to 0. --echo #cache parent table in server1 --connection server1 select * from parent order by a; --echo #now run the DDL query in server2 --connection server2 --eval $ddl_query --echo #check if the parent metadata has been reset in server1 --connection server1 if (!$expect_alter_failure) { --echo #altering column should pass } if ($expect_alter_failure) { --echo #altering column should fail with error --error ER_FK_INCOMPATIBLE_COLUMNS } alter table parent change column a a varchar(64) not null; if (!$expect_alter_failure) { --echo #check parent's new definition show create table parent; --echo #restore parent to old definition alter table parent change column a a int; } #reset input let $ddl_query=;