diff options
Diffstat (limited to 'mysql-test/suite/innodb_zip/t/index_large_prefix_4k.test')
-rw-r--r-- | mysql-test/suite/innodb_zip/t/index_large_prefix_4k.test | 11 |
1 files changed, 0 insertions, 11 deletions
diff --git a/mysql-test/suite/innodb_zip/t/index_large_prefix_4k.test b/mysql-test/suite/innodb_zip/t/index_large_prefix_4k.test index cc4f9f5387d..1bfff79e94c 100644 --- a/mysql-test/suite/innodb_zip/t/index_large_prefix_4k.test +++ b/mysql-test/suite/innodb_zip/t/index_large_prefix_4k.test @@ -136,7 +136,6 @@ create table worklog5743_4(a1 int, a2 TEXT not null) KEY_BLOCK_SIZE=4; # See page_zip_empty_size() and Bug #47495 for more detail. # Test edge cases for indexes using key_block_size=1 -set global innodb_large_prefix=0; -- error ER_TOO_BIG_ROWSIZE create index idx1 on worklog5743_1(a2(4000)); show warnings; @@ -154,7 +153,6 @@ create index idx6 on worklog5743_1(a1, a2(428)); show warnings; # Test edge cases for indexes using key_block_size=2 -set global innodb_large_prefix=1; SET sql_mode= ''; create index idx1 on worklog5743_2(a2(4000)); show warnings; @@ -169,7 +167,6 @@ show warnings; create index idx6 on worklog5743_2(a1, a2(764)); show warnings; # Test edge cases for indexes using key_block_size=4 -set global innodb_large_prefix=0; create index idx1 on worklog5743_4(a2(4000)); show warnings; show create table worklog5743_4; @@ -188,14 +185,6 @@ insert into worklog5743_1 values(9, repeat("a", 10000)); insert into worklog5743_2 values(9, repeat("a", 10000)); insert into worklog5743_4 values(9, repeat("a", 10000)); -# Now if we change the global innodb_large_prefix back to 767, -# updates to these indexes should still be allowed. -set global innodb_large_prefix=0; -insert into worklog5743_1 values(2, repeat("b", 10000)); -insert into worklog5743_2 values(2, repeat("b", 10000)); -insert into worklog5743_4 values(2, repeat("b", 10000)); -set global innodb_large_prefix=1; - select a1, left(a2, 20) from worklog5743_1; select a1, left(a2, 20) from worklog5743_2; select a1, left(a2, 20) from worklog5743_4; |