diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/t/ai_init_insert.test')
-rw-r--r-- | mysql-test/suite/engines/funcs/t/ai_init_insert.test | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/mysql-test/suite/engines/funcs/t/ai_init_insert.test b/mysql-test/suite/engines/funcs/t/ai_init_insert.test index d70ab2dc8f8..65be9264591 100644 --- a/mysql-test/suite/engines/funcs/t/ai_init_insert.test +++ b/mysql-test/suite/engines/funcs/t/ai_init_insert.test @@ -16,7 +16,7 @@ SELECT column_comment,char_length(column_comment) FROM information_schema.column --sorted_result SELECT comment FROM information_schema.statistics WHERE table_name='t1'; let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; ---replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" +--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; @@ -31,7 +31,7 @@ SELECT column_comment,char_length(column_comment) FROM information_schema.column --sorted_result SELECT comment FROM information_schema.statistics WHERE table_name='t1'; let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; ---replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" +--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; @@ -46,7 +46,7 @@ SELECT column_comment,char_length(column_comment) FROM information_schema.column --sorted_result SELECT comment FROM information_schema.statistics WHERE table_name='t1'; let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; ---replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" +--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP INDEX i1 ON t1; @@ -64,7 +64,7 @@ SELECT column_comment,char_length(column_comment) FROM information_schema.column --sorted_result SELECT comment FROM information_schema.statistics WHERE table_name='t1'; let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; ---replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" +--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; --sorted_result @@ -78,7 +78,7 @@ SELECT column_comment,char_length(column_comment) FROM information_schema.column --sorted_result SELECT comment FROM information_schema.statistics WHERE table_name='t1'; let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; ---replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" +--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; @@ -93,7 +93,7 @@ SELECT column_comment,char_length(column_comment) FROM information_schema.column --sorted_result SELECT comment FROM information_schema.statistics WHERE table_name='t1'; let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; ---replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" +--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; @@ -108,7 +108,7 @@ SELECT column_comment,char_length(column_comment) FROM information_schema.column --sorted_result SELECT comment FROM information_schema.statistics WHERE table_name='t1'; let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; ---replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" +--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; --sorted_result @@ -122,7 +122,7 @@ SELECT column_comment,char_length(column_comment) FROM information_schema.column --sorted_result SELECT comment FROM information_schema.statistics WHERE table_name='t1'; let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; ---replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" +--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; @@ -142,7 +142,7 @@ SELECT column_comment,char_length(column_comment) FROM information_schema.column --sorted_result SELECT comment FROM information_schema.statistics WHERE table_name='t1'; let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; ---replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" +--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; @@ -159,7 +159,7 @@ SELECT column_comment,char_length(column_comment) FROM information_schema.column --sorted_result SELECT comment FROM information_schema.statistics WHERE table_name='t1'; let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`; ---replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" +--replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" "" " PAGE_CHECKSUM=1" "" SHOW CREATE TABLE t1; DROP TABLE t1; |