oceanbase

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

7
--disable_abort_on_error
8
--disable_warnings
9

10
select length('ab');
11
select length('ab ');
12
select length('ab\t');
13
select length('ab\0');
14
#特殊处理
15
select length('\_');
16
select length('\%');
17
#转义字符
18
select length('\\');
19
select length('\z');
20
select length('\n\t\r\b\0\_\%\\');
21
#直接忽略'\'
22
select length('\a');
23
select length('\m');
24
#数字转换
25
select length(12.466);
26
select length(4334);
27
select length(0.00);
28
#根据collation判断
29
select length('好');
30

31
#作为列名
32
select length(13bd);
33
select length(db24);
34

35
###带小数点且以0结尾
36
select length(00.000);
37
select length(00.000);
38
select length(1.00000);
39
select length(10000.10);
40

41

42
create database if not exists db1;
43
use db1;
44
--disable_warnings
45
drop table if exists utf,tx,gbk;
46
--enable_warnings
47

48
create table utf(c1 int primary key, c2 char(10)) collate 'utf8mb4_bin';
49
insert into utf values(1, '好');
50
select length(c2) from utf;
51

52
create table tx(s int(255) zerofill);
53
insert into tx values (2);
54
select * from tx;
55
select * from tx;
56
select * from tx;
57
select length(s) from tx;
58

59
drop table tx;
60
create table tx(s int(121) zerofill);
61
insert into tx values (1234);
62
select * from tx;
63
select * from tx;
64
select * from tx;
65
select length(s) from tx;
66

67
drop table tx;
68

69
#create table gbk(c1 int primary key, c2 char(10)) collate 'gbk_bin';
70
#insert into gbk values (1, '好');
71
#select length(c2) from gbk;
72
drop database db1;
73