oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
# owner: dachuan.sdc
5
# owner group: SQL3
6
# description: foobar
7

8
#--source include/have_utf8.inc
9
#--source include/have_innodb.inc
10
#--disable_warnings
11
--disable_warnings
12
drop table if exists `Ｔ１`;
13
drop table if exists `Ｔ２`;
14
drop table if exists `Ｔ３`;
15
drop table if exists `Ｔ４`;
16
drop table if exists `Ｔ５`;
17
drop table if exists `Ｔ６`;
18
drop table if exists `Ｔ７`;
19
drop table if exists `Ｔ８`;
20
drop table if exists `Ｔ９`;
21
--enable_warnings
22

23
#
24
# Test LENGTH() function with Japanese character in utf8 encoding
25
#
26

27
SET NAMES utf8;
28
#SET character_set_database = utf8;
29

30
CREATE TABLE `Ｔ１` (`Ｃ１` char(5) PRIMARY KEY, INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8;
31
CREATE TABLE `Ｔ２` (`Ｃ１` char(5) PRIMARY KEY, INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8;
32
CREATE TABLE `Ｔ３` (`Ｃ１` char(5) PRIMARY KEY, INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8;
33
CREATE TABLE `Ｔ４` (`Ｃ１` char(5) PRIMARY KEY, INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8;
34
CREATE TABLE `Ｔ５` (`Ｃ１` char(5) PRIMARY KEY, INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8;
35
CREATE TABLE `Ｔ６` (`Ｃ１` char(5) PRIMARY KEY, INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8;
36
CREATE TABLE `Ｔ７` (`Ｃ１` char(5) PRIMARY KEY, INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8;
37
CREATE TABLE `Ｔ８` (`Ｃ１` char(5) PRIMARY KEY, INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8;
38
CREATE TABLE `Ｔ９` (`Ｃ１` char(5) PRIMARY KEY, INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8;
39

40
INSERT INTO `Ｔ１` VALUES ('ｱｲｳｴｵ'),('ｱｲｳｴ'),('ｱｲｳ'),('ｱｲ'),('ｱ'),('');
41
INSERT INTO `Ｔ２` VALUES ('あいうえお'),('あいうえ'),('あいう'),('あい'),('あ'),('');
42
INSERT INTO `Ｔ３` VALUES ('龔龖龗龞龡'),('龔龖龗龞'),('龔龖龗'),('龔龖'),('龔'),('');
43
INSERT INTO `Ｔ４` VALUES ('ｱｲｳｴｵ'),('ｱｲｳｴ'),('ｱｲｳ'),('ｱｲ'),('ｱ'),('');
44
INSERT INTO `Ｔ５` VALUES ('あいうえお'),('あいうえ'),('あいう'),('あい'),('あ'),('');
45
INSERT INTO `Ｔ６` VALUES ('龔龖龗龞龡'),('龔龖龗龞'),('龔龖龗'),('龔龖'),('龔'),('');
46
INSERT INTO `Ｔ７` VALUES ('ｱｲｳｴｵ'),('ｱｲｳｴ'),('ｱｲｳ'),('ｱｲ'),('ｱ'),('');
47
INSERT INTO `Ｔ８` VALUES ('あいうえお'),('あいうえ'),('あいう'),('あい'),('あ'),('');
48
INSERT INTO `Ｔ９` VALUES ('龔龖龗龞龡'),('龔龖龗龞'),('龔龖龗'),('龔龖'),('龔'),('');
49

50
SELECT * FROM `Ｔ１`;
51
SELECT * FROM `Ｔ２`;
52
SELECT * FROM `Ｔ３`;
53
SELECT * FROM `Ｔ４`;
54
SELECT * FROM `Ｔ５`;
55
SELECT * FROM `Ｔ６`;
56
SELECT * FROM `Ｔ７`;
57
SELECT * FROM `Ｔ８`;
58
SELECT * FROM `Ｔ９`;
59

60
#InnoDB
61
SELECT `Ｃ１`, LENGTH(`Ｃ１`) FROM `Ｔ１`;
62
SELECT `Ｃ１`, LENGTH(`Ｃ１`) FROM `Ｔ２`;
63
SELECT `Ｃ１`, LENGTH(`Ｃ１`) FROM `Ｔ３`;
64

65
#MyISAM
66
SELECT `Ｃ１`, LENGTH(`Ｃ１`) FROM `Ｔ４`;
67
SELECT `Ｃ１`, LENGTH(`Ｃ１`) FROM `Ｔ５`;
68
SELECT `Ｃ１`, LENGTH(`Ｃ１`) FROM `Ｔ６`;
69

70
#MEMORY
71
SELECT `Ｃ１`, LENGTH(`Ｃ１`) FROM `Ｔ７`;
72
SELECT `Ｃ１`, LENGTH(`Ｃ１`) FROM `Ｔ８`;
73
SELECT `Ｃ１`, LENGTH(`Ｃ１`) FROM `Ｔ９`;
74

75
DROP TABLE `Ｔ１`;
76
DROP TABLE `Ｔ２`;
77
DROP TABLE `Ｔ３`;
78
DROP TABLE `Ｔ４`;
79
DROP TABLE `Ｔ５`;
80
DROP TABLE `Ｔ６`;
81
DROP TABLE `Ｔ７`;
82
DROP TABLE `Ｔ８`;
83
DROP TABLE `Ｔ９`;
84