oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
#owner: link.zt
5
#owner group: sql1
6

7
--disable_warnings
8
drop table if exists t1,t2,left_table;
9
--enable_warnings
10

11
create table t1(c0 int primary key, c1 int , c2 int);
12

13
insert into t1 values(1,10,100);
14

15

16
select c1+10 c3, c2 from t1 where c0=1;
17

18
drop table t1;
19