diff options
Diffstat (limited to 'mysql-test/suite/maria/maria-big.result')
| -rw-r--r-- | mysql-test/suite/maria/maria-big.result | 224 |
1 files changed, 224 insertions, 0 deletions
diff --git a/mysql-test/suite/maria/maria-big.result b/mysql-test/suite/maria/maria-big.result new file mode 100644 index 00000000..f4fd4b65 --- /dev/null +++ b/mysql-test/suite/maria/maria-big.result @@ -0,0 +1,224 @@ +set global max_allowed_packet=400000000; +connect root,localhost,root,,test,$MASTER_MYPORT,$MASTER_MYSOCK; +connection root; +set default_storage_engine=aria; +affected rows: 0 +drop table if exists t1, t2; +affected rows: 0 +create table t1(a char(3)); +affected rows: 0 +insert into t1 values("abc"); +affected rows: 1 +insert into t1 select "def" from t1; +affected rows: 1 +info: Records: 1 Duplicates: 0 Warnings: 0 +insert into t1 select "ghi" from t1; +affected rows: 2 +info: Records: 2 Duplicates: 0 Warnings: 0 +insert into t1 select "jkl" from t1; +affected rows: 4 +info: Records: 4 Duplicates: 0 Warnings: 0 +insert into t1 select "mno" from t1; +affected rows: 8 +info: Records: 8 Duplicates: 0 Warnings: 0 +insert into t1 select "pqr" from t1; +affected rows: 16 +info: Records: 16 Duplicates: 0 Warnings: 0 +insert into t1 select "stu" from t1; +affected rows: 32 +info: Records: 32 Duplicates: 0 Warnings: 0 +insert into t1 select "vwx" from t1; +affected rows: 64 +info: Records: 64 Duplicates: 0 Warnings: 0 +insert into t1 select "yza" from t1; +affected rows: 128 +info: Records: 128 Duplicates: 0 Warnings: 0 +insert into t1 select "ceg" from t1; +affected rows: 256 +info: Records: 256 Duplicates: 0 Warnings: 0 +insert into t1 select "ikm" from t1; +affected rows: 512 +info: Records: 512 Duplicates: 0 Warnings: 0 +insert into t1 select "oqs" from t1; +affected rows: 1024 +info: Records: 1024 Duplicates: 0 Warnings: 0 +select count(*) from t1; +count(*) +2048 +affected rows: 1 +insert into t1 select "uwy" from t1; +affected rows: 2048 +info: Records: 2048 Duplicates: 0 Warnings: 0 +create table t2 select * from t1; +affected rows: 4096 +info: Records: 4096 Duplicates: 0 Warnings: 0 +select count(*) from t1; +count(*) +4096 +affected rows: 1 +select count(*) from t2; +count(*) +4096 +affected rows: 1 +drop table t1, t2; +affected rows: 0 +create table t1 (a int, b longtext); +affected rows: 0 +insert into t1 values (1,"123456789012345678901234567890"),(2,"09876543210987654321"); +affected rows: 2 +info: Records: 2 Duplicates: 0 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=CONCAT(b,b); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +select a,length(b) from t1; +a length(b) +1 251658240 +2 167772160 +affected rows: 2 +check table t1; +Table Op Msg_type Msg_text +test.t1 check status OK +affected rows: 1 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +update t1 set b=mid(b,1,length(b)/2); +affected rows: 2 +info: Rows matched: 2 Changed: 2 Warnings: 0 +select a,length(b) from t1; +a length(b) +1 60 +2 40 +affected rows: 2 +check table t1; +Table Op Msg_type Msg_text +test.t1 check status OK +affected rows: 1 +drop table t1; +affected rows: 0 |