oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
# owner: dachuan.sdc
5
# owner group: SQL2
6
# description:
7
#
8
--disable_warnings
9
drop database if exists hualong;
10
--enable_warnings
11
create database hualong;
12
use hualong;
13
--disable_warnings
14
drop table if exists r1;
15
--enable_warnings
16
--disable_warnings
17
drop table if exists r2;
18
--enable_warnings
19
create table hualong.r1(c1 int not null primary key, c2 int);
20
create table hualong.r2(a int not null primary key , b int);
21
--error 1050
22
rename table r1 to r2;
23
--error 1050
24
alter table r1 rename to r2;
25
--error 1050
26
rename table r1 to r3, r2 to r3;
27
--error 1050
28
rename table r1 to r3, r1 to r3;
29
--error 1017
30
rename table r1 to r3, r1 to r4;
31
#表xx不存在， ti存在， 先报ti存在
32
--error 1050
33
rename table xx to r1;
34
--error 1049
35
rename table xx to a.xxx;
36
rename table r1 to table1, table1 to r1;
37
rename table r1 to r3, r2 to r1;
38
--error 1050
39
rename table r3 to r3;
40
--disable_warnings
41
drop database if exists hualong2;
42
--enable_warnings
43
create database hualong2;
44
rename table hualong.r1 to hualong2.r1;
45
show tables from hualong;
46
show tables from hualong2;
47

48
create index idx1 on hualong.r3(c1);
49
rename table hualong.r3 to hualong2.r2;
50
show tables from hualong;
51
show tables from hualong2;
52
--source mysql_test/include/check_all_idx_ok.inc
53
show index from hualong2.r2;
54
rename table hualong2.r2 to hualong.r2;
55
--source mysql_test/include/check_all_idx_ok.inc
56
show index from hualong.r2;
57
show tables from hualong;
58

59
rename table hualong2.r1 to hualong.r1;
60
rename table r1 to tmp, tmp to r1, r2 to tmp;
61
show tables from hualong;
62

63
drop table hualong.r1, hualong.tmp;
64
drop database hualong;
65
drop database hualong2;
66