oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
# owner: bin.lb
5
# owner group: SQL2
6
# tags: dml
7
# description:
8
#
9
--disable_warnings
10
drop table if exists tt1;
11
--enable_warnings
12

13
create table tt1(c1 int primary key, c2 int);
14
insert into tt1 values(1,4);
15
insert into tt1 values(2,3);
16

17
select c1, c2 as c1 from tt1;
18

19
--error 1052
20
select c1, c2 as c1 from tt1 order by c1;
21

22
select c2 as c1 from tt1 order by c1;
23

24
select c2 as c1 from tt1 where c1<4;
25

26
select c1 as cc, c2 as c1 from tt1 where c1<4;
27

28
select c1 as cc, c2 as c1 from tt1 order by c1;
29

30
select c1, c2 as c1 from tt1 where c1<4;
31

32
select c2 as cc from tt1  order by c1;
33

34
select c2 as c1 from tt1 order by c1;
35

36
select c1 as c1, c2 as c1 from tt1 where c1<4;
37
#show columns from t1 like 'c1';
38
show columns from tt1;
39
#show columns from t1 like '%c%';
40

41

42