blob: abc97867e898e03f24f6ff6141244976acb0dc64 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
|
drop table if exists t1,t2;
#
# Test discovery of s3
#
create table t1 (a int, b int) engine=aria select seq as a, seq+10 as b from seq_1_to_10;
alter table t1 engine=s3;
#
# Check discovery by select
#
flush tables;
select * from t1 limit 1;
a b
1 11
#
# Check if changes to .frm is copied to S3
#
alter table t1 change column b c int not null;
flush tables;
select * from t1 limit 1;
a c
1 11
#
# Check if SHOW TABLES finds the S3 tables
#
create table t2 (a int, b int) engine=aria select seq as a, seq+10 as b from seq_1_to_10;
alter table t2 engine=s3;
flush tables;
SHOW TABLES;
Tables_in_database
t1
t2
drop table t2;
#
# Check if DROP TABLE works with discovery
#
select count(*) from t1;
count(*)
10
flush tables;
drop table t1;
select count(*), sum(a) from t1;
ERROR 42S02: Table 'database.t1' doesn't exist
#
# Check if S3 detects that the .frm is too old
#
create table t1 (a int, b int) engine=aria select seq as a, seq+10 as b from seq_1_to_10;
alter table t1 engine=s3;
alter table t1 add column c int, engine=s3;
flush tables;
select * from t1 limit 1;
a b c
1 11 NULL
flush tables;
select * from t1 limit 1;
a b c
1 11 NULL
drop table t1;
|
