Debian Codegraph @

mysql-test/suite/s3/innodb.test

raw
1 --source include/have_s3.inc
2 --source include/have_sequence.inc
3 --source include/have_innodb.inc
4
5 #
6 # Testing converting InnoDB tables to S3
7 #
8
9 #
10 # Create unique database for running the tests
11 #
12 --source create_database.inc
13 --disable_warnings
14 drop table if exists t1,t2,t3;
15 --enable_warnings
16
17 --echo #
18 --echo # Test ALTER TABLE to and from s3
19 --echo #
20
21 create table t1 (a int, b int) engine=innodb;
22 insert into t1 select seq,seq+10 from seq_1_to_1000;
23 alter table t1 engine=s3;
24 show create table t1;
25 alter table t1 comment="hello";
26 show create table t1;
27 alter table t1 engine=innodb;
28 show create table t1;
29 select count(*), sum(a), sum(b) from t1;
30 drop table t1;
31
32 #
33 # clean up
34 #
35 --source drop_database.inc