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 ob_new_sql_test;
9
--enable_warnings
10

11
create table ob_new_sql_test(c0 varchar(20), c1 int primary key, c2 int , c3 int,c4 int,c5 int,c6 int,c7 int,c8 int,c9 int,c10 int,c11 int,c12 int,c13 int,c14 int,c15 int);
12
insert into ob_new_sql_test (c0, c1) values ('hello', 0);
13

14
select * from ob_new_sql_test where c1 < 1;
15
select * from ob_new_sql_test where c1 = 0;
16

17
drop table ob_new_sql_test;
18