24 lines
606 B
Plaintext
24 lines
606 B
Plaintext
--echo #
|
|
--echo # WL#13153: Don't dump SECONDARY TABLE if requested by the end user
|
|
--echo #
|
|
|
|
CREATE TABLE t1 (a INT) SECONDARY_ENGINE=gizmo;
|
|
|
|
--echo # test: should have SECONDARY_ENGINE
|
|
SHOW CREATE TABLE t1;
|
|
|
|
SET SESSION show_create_table_skip_secondary_engine=on;
|
|
SHOW CREATE TABLE t1;
|
|
SET SESSION show_create_table_skip_secondary_engine=default;
|
|
|
|
--echo # test: t1 should have SECONDARY_ENGINE on
|
|
--exec $MYSQL_DUMP --compact test
|
|
|
|
--echo # test: t1 should not have SECONDARY_ENGINE
|
|
--exec $MYSQL_DUMP --show-create-table-skip-secondary-engine --compact test
|
|
|
|
DROP TABLE t1;
|
|
|
|
|
|
--echo # End of 8.0 tests
|