| 1 |
DROP TABLE if exists t1; |
| 2 |
|
| 3 |
# |
| 4 |
# Test of extending updated rows. |
| 5 |
# This caused failures in lp:815022 |
| 6 |
# |
| 7 |
CREATE TABLE t1 (col_longtext_ucs2 longtext, col_longtext_utf8 longtext, col_varchar_255_ucs2_key varchar(255), col_set_utf8 set ('a','b'), col_char_255_ucs2 char(255), col_char_255_ucs2_key char(255), col_enum_ucs2 enum ('a','b'), col_varchar_255_ucs2 varchar(255), col_longtext_ucs2_key longtext, col_longtext_utf8_key longtext, col_enum_utf8 enum ('a','b'), col_varchar_255_utf8_key varchar(1024), col_varchar_255_utf8 varchar(255), col_enum_ucs2_key enum ('a','b'), col_enum_utf8_key enum ('a','b'), col_set_utf8_key set ('a','b'), col_char_255_utf8 char(255), pk integer auto_increment, col_set_ucs2_key set ('a','b'), col_char_255_utf8_key char(255), col_set_ucs2 set ('a','b'), primary key (pk)) ENGINE=aria; |
| 8 |
INSERT INTO t1 ( col_char_255_utf8, col_varchar_255_utf8_key, col_longtext_utf8_key ) VALUES ( 'lggnqojgqectqlkvskffihliqcwoakzzzjvhkqlwjybkngdbubskflpmzegdrk', REPEAT( 'a', 627 ), 'mlggnqojgqectqlkvskffihliqcwoakzzzjvhkqlwjybkngdbubskflpmzegdrklnipcmzbtwdqfnyinqfohgtiwmvfpbuslgobjhslxnaybcyebhsrlipnuvalhmvhlwbwujtvjsdrbyapfzprnxfgtrukwhywtkaoupsaogxsjxhqjkidvnpeytjgndtnrrbm' ); |
| 9 |
UPDATE t1 SET col_varchar_255_utf8 = REPEAT('a', 197 ); |
| 10 |
UPDATE t1 SET col_char_255_utf8 = 'bmjihzjtxegprqfvmczyzbavjuozkyxrlxvqyzcfvsjrhcccqnecyohzhzbgsbqkqvzmtlhtlcgzheirkyfwczoolilkrfimfnuoapyylbghdhdgfebjjajfoigagozypqtrflrvdiwfgqalsqbmlllsanvtuuutiaastqtbzeoaawl'; |
| 11 |
check table t1; |
| 12 |
drop table t1; |
| 13 |
|
| 14 |
create table t1 (a int primary key auto_increment, e1 enum('a','b'), e2 enum('a','b'), vl int, bl int, c char(10), v1 varchar(10000), v2 varchar(10000), b1 blob, b2 blob) engine=aria; |
| 15 |
|
| 16 |
insert into t1 (vl,bl) values (10,10),(100,100),(1000,1000),(5000,5000),(8000,12000); |
| 17 |
update t1 set c="test", v1=repeat('a',vl),v2=repeat('b',vl/2),b1=repeat('c',bl),b2=repeat('d',bl); |
| 18 |
insert into t1 (vl,bl) values (10,10),(100,100),(1000,1000),(1000,5000); |
| 19 |
update t1 set c="test", v1=repeat('a',vl/4),v2=repeat('b',vl/5),b1=repeat('c',bl*2),b2=repeat('d',bl/2); |
| 20 |
insert into t1 (vl,bl) values (100,100); |
| 21 |
update t1 set c="test", v1=repeat('a',vl),v2=repeat('b',vl),b1=repeat('c',bl*2),b2=repeat('d',bl/2); |
| 22 |
update t1 set c="test", v1=repeat('a',vl/2),v2=repeat('b',vl/2),b1=repeat('c',bl/2),b2=repeat('d',bl/2); |
| 23 |
update t1 set c="test", v1=repeat('a',vl/4),v2=repeat('b',vl/4),b1=repeat('c',bl/4),b2=repeat('d',bl/4); |
| 24 |
update t1 set c="test", v1=repeat('a',vl/20),v2=repeat('b',vl),b1=repeat('c',bl/20),b2=repeat('d',bl/20); |
| 25 |
insert into t1 (vl,bl) values (100,100); |
| 26 |
update t1 set c="test", v1=repeat('a',vl/100),b1=repeat('c',bl/100); |
| 27 |
insert into t1 (vl,bl) values (100,100); |
| 28 |
update t1 set c="test", v1=repeat('a',vl),b1=repeat('c',bl); |
| 29 |
insert into t1 (vl,bl) values (100,100); |
| 30 |
update t1 set c="test", v1=repeat('a',10),v2=repeat('b',10); |
| 31 |
insert into t1 (vl,bl) values (100,100); |
| 32 |
update t1 set c="test", v1=repeat('a',2000),v2=repeat('b',2000); |
| 33 |
check table t1; |
| 34 |
drop table t1; |