oceanbase

1
drop table if exists ob_new_sql_test;
2
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);
3
insert into ob_new_sql_test (c0, c1) values ('hello', 0);
4
select * from ob_new_sql_test where c1 < 1;
5
c0	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15
6
hello	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
7
select * from ob_new_sql_test where c1 = 0;
8
c0	c1	c2	c3	c4	c5	c6	c7	c8	c9	c10	c11	c12	c13	c14	c15
9
hello	0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL
10
drop table ob_new_sql_test;
11