Debian Codegraph @

mysql-test/suite/s3/innodb.result

raw
1 drop table if exists t1,t2,t3;
2 #
3 # Test ALTER TABLE to and from s3
4 #
5 create table t1 (a int, b int) engine=innodb;
6 insert into t1 select seq,seq+10 from seq_1_to_1000;
7 alter table t1 engine=s3;
8 show create table t1;
9 Table Create Table
10 t1 CREATE TABLE `t1` (
11 `a` int(11) DEFAULT NULL,
12 `b` int(11) DEFAULT NULL
13 ) ENGINE=S3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1
14 alter table t1 comment="hello";
15 show create table t1;
16 Table Create Table
17 t1 CREATE TABLE `t1` (
18 `a` int(11) DEFAULT NULL,
19 `b` int(11) DEFAULT NULL
20 ) ENGINE=S3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='hello'
21 alter table t1 engine=innodb;
22 show create table t1;
23 Table Create Table
24 t1 CREATE TABLE `t1` (
25 `a` int(11) DEFAULT NULL,
26 `b` int(11) DEFAULT NULL
27 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci PAGE_CHECKSUM=1 COMMENT='hello'
28 select count(*), sum(a), sum(b) from t1;
29 count(*) sum(a) sum(b)
30 1000 500500 510500
31 drop table t1;