mirror of
https://github.com/MariaDB/server.git
synced 2025-01-15 19:42:28 +01:00
45bc7574fb
Remove usage of deprecated variable storage_engine. It was deprecated in 5.5 but it never issued a deprecation warning. Make it issue a warning in 10.5.1. Replaced with default_storage_engine.
224 lines
6.6 KiB
Text
224 lines
6.6 KiB
Text
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
|