oceanbase

1
drop table if exists ob_new_sql_test;
2
drop table if exists a1;
3
create table ob_new_sql_test(c0 varchar(10) primary key, c1 int, c2 int);
4
insert into ob_new_sql_test(c0, c1) values ('0001',1);
5
select * from ob_new_sql_test where c0='0001';
6
c0	c1	c2
7
0001	1	NULL
8
select * from ob_new_sql_test;
9
c0	c1	c2
10
0001	1	NULL
11
select length(c0) from ob_new_sql_test;
12
length(c0)
13
4
14
select hex(c0) from ob_new_sql_test;
15
hex(c0)
16
30303031
17
drop table ob_new_sql_test;
18
SELECT 'a' = 'a ';
19
'a' = 'a '
20
1
21
SELECT 'a\0' < 'a';
22
'a\0' < 'a'
23
1
24
SELECT 'a\0' < 'a ';
25
'a\0' < 'a '
26
1
27
SELECT 'a\t' < 'a';
28
'a\t' < 'a'
29
1
30
SELECT 'a\t' < 'a ';
31
'a\t' < 'a '
32
1
33
create table a1 (rowkey_suffix int primary key,price int);
34
insert into a1 (rowkey_suffix, price) values(10,10);
35
insert into a1 (rowkey_suffix, price) values(20,20);
36
select * from a1 where rowkey_suffix=price;
37
rowkey_suffix	price
38
10	10
39
20	20
40
select * from a1 where rowkey_suffix=price and price=10;
41
rowkey_suffix	price
42
10	10
43
drop table a1;
44