4493d40a-92aa-4162-9dfc-bfc4ec0996e6
/
polardbxengine
2
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
polardbxengine/mysql-test/suite/jp/r/jp_left_utf8.result

494 lines
13 KiB
Plaintext
Raw Permalink Blame History

This file contains ambiguous Unicode characters!

This file contains ambiguous Unicode characters that may be confused with others in your current locale. If your use case is intentional and legitimate, you can safely ignore this warning. Use the Escape button to highlight these characters.

drop table if exists `Ｔ１`;
drop table if exists `Ｔ２`;
drop table if exists `Ｔ３`;
drop table if exists `Ｔ４`;
drop table if exists `Ｔ５`;
drop table if exists `Ｔ６`;
drop table if exists `Ｔ７`;
drop table if exists `Ｔ８`;
drop table if exists `Ｔ９`;
SET NAMES utf8;
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
SET character_set_database = utf8;
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
Warning 1681 Updating 'character_set_database' is deprecated. It will be made read-only in a future release.
CREATE TABLE `Ｔ１` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = innodb;
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
CREATE TABLE `Ｔ２` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = innodb;
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
CREATE TABLE `Ｔ３` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = innodb;
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
CREATE TABLE `Ｔ４` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = myisam;
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
CREATE TABLE `Ｔ５` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = myisam;
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
CREATE TABLE `Ｔ６` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = myisam;
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
CREATE TABLE `Ｔ７` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = MEMORY;
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
CREATE TABLE `Ｔ８` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = MEMORY;
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
CREATE TABLE `Ｔ９` (`Ｃ１` char(5), INDEX(`Ｃ１`)) DEFAULT CHARSET = utf8 engine = MEMORY;
Warnings:
Warning 3719 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a future release. Please consider using UTF8MB4 in order to be unambiguous.
INSERT INTO `Ｔ１` VALUES ('ｱｲｳｴｵ'),('ｱｲｳｴ'),('ｱｲｳ'),('ｱｲ'),('ｱ'),('');
INSERT INTO `Ｔ２` VALUES ('あいうえお'),('あいうえ'),('あいう'),('あい'),('あ'),('');
INSERT INTO `Ｔ３` VALUES ('龔龖龗龞龡'),('龔龖龗龞'),('龔龖龗'),('龔龖'),('龔'),('');
INSERT INTO `Ｔ４` VALUES ('ｱｲｳｴｵ'),('ｱｲｳｴ'),('ｱｲｳ'),('ｱｲ'),('ｱ'),('');
INSERT INTO `Ｔ５` VALUES ('あいうえお'),('あいうえ'),('あいう'),('あい'),('あ'),('');
INSERT INTO `Ｔ６` VALUES ('龔龖龗龞龡'),('龔龖龗龞'),('龔龖龗'),('龔龖'),('龔'),('');
INSERT INTO `Ｔ７` VALUES ('ｱｲｳｴｵ'),('ｱｲｳｴ'),('ｱｲｳ'),('ｱｲ'),('ｱ'),('');
INSERT INTO `Ｔ８` VALUES ('あいうえお'),('あいうえ'),('あいう'),('あい'),('あ'),('');
INSERT INTO `Ｔ９` VALUES ('龔龖龗龞龡'),('龔龖龗龞'),('龔龖龗'),('龔龖'),('龔'),('');
SELECT `Ｃ１`, LEFT(`Ｃ１`,0) FROM `Ｔ１`;
Ｃ１ LEFT(`Ｃ１`,0)
ｱ
ｱｲ
ｱｲｳ
ｱｲｳｴ
ｱｲｳｴｵ
SELECT `Ｃ１`, LEFT(`Ｃ１`,1) FROM `Ｔ１`;
Ｃ１ LEFT(`Ｃ１`,1)
ｱ ｱ
ｱｲ ｱ
ｱｲｳ ｱ
ｱｲｳｴ ｱ
ｱｲｳｴｵ ｱ
SELECT `Ｃ１`, LEFT(`Ｃ１`,2) FROM `Ｔ１`;
Ｃ１ LEFT(`Ｃ１`,2)
ｱ ｱ
ｱｲ ｱｲ
ｱｲｳ ｱｲ
ｱｲｳｴ ｱｲ
ｱｲｳｴｵ ｱｲ
SELECT `Ｃ１`, LEFT(`Ｃ１`,3) FROM `Ｔ１`;
Ｃ１ LEFT(`Ｃ１`,3)
ｱ ｱ
ｱｲ ｱｲ
ｱｲｳ ｱｲｳ
ｱｲｳｴ ｱｲｳ
ｱｲｳｴｵ ｱｲｳ
SELECT `Ｃ１`, LEFT(`Ｃ１`,4) FROM `Ｔ１`;
Ｃ１ LEFT(`Ｃ１`,4)
ｱ ｱ
ｱｲ ｱｲ
ｱｲｳ ｱｲｳ
ｱｲｳｴ ｱｲｳｴ
ｱｲｳｴｵ ｱｲｳｴ
SELECT `Ｃ１`, LEFT(`Ｃ１`,5) FROM `Ｔ１`;
Ｃ１ LEFT(`Ｃ１`,5)
ｱ ｱ
ｱｲ ｱｲ
ｱｲｳ ｱｲｳ
ｱｲｳｴ ｱｲｳｴ
ｱｲｳｴｵ ｱｲｳｴｵ
SELECT `Ｃ１`, LEFT(`Ｃ１`,0) FROM `Ｔ２`;
Ｃ１ LEFT(`Ｃ１`,0)
あ
あい
あいう
あいうえ
あいうえお
SELECT `Ｃ１`, LEFT(`Ｃ１`,1) FROM `Ｔ２`;
Ｃ１ LEFT(`Ｃ１`,1)
あ あ
あい あ
あいう あ
あいうえ あ
あいうえお あ
SELECT `Ｃ１`, LEFT(`Ｃ１`,2) FROM `Ｔ２`;
Ｃ１ LEFT(`Ｃ１`,2)
あ あ
あい あい
あいう あい
あいうえ あい
あいうえお あい
SELECT `Ｃ１`, LEFT(`Ｃ１`,3) FROM `Ｔ２`;
Ｃ１ LEFT(`Ｃ１`,3)
あ あ
あい あい
あいう あいう
あいうえ あいう
あいうえお あいう
SELECT `Ｃ１`, LEFT(`Ｃ１`,4) FROM `Ｔ２`;
Ｃ１ LEFT(`Ｃ１`,4)
あ あ
あい あい
あいう あいう
あいうえ あいうえ
あいうえお あいうえ
SELECT `Ｃ１`, LEFT(`Ｃ１`,5) FROM `Ｔ２`;
Ｃ１ LEFT(`Ｃ１`,5)
あ あ
あい あい
あいう あいう
あいうえ あいうえ
あいうえお あいうえお
SELECT `Ｃ１`, LEFT(`Ｃ１`,0) FROM `Ｔ３`;
Ｃ１ LEFT(`Ｃ１`,0)
龔
龔龖
龔龖龗
龔龖龗龞
龔龖龗龞龡
SELECT `Ｃ１`, LEFT(`Ｃ１`,1) FROM `Ｔ３`;
Ｃ１ LEFT(`Ｃ１`,1)
龔 龔
龔龖 龔
龔龖龗 龔
龔龖龗龞 龔
龔龖龗龞龡 龔
SELECT `Ｃ１`, LEFT(`Ｃ１`,2) FROM `Ｔ３`;
Ｃ１ LEFT(`Ｃ１`,2)
龔 龔
龔龖 龔龖
龔龖龗 龔龖
龔龖龗龞 龔龖
龔龖龗龞龡 龔龖
SELECT `Ｃ１`, LEFT(`Ｃ１`,3) FROM `Ｔ３`;
Ｃ１ LEFT(`Ｃ１`,3)
龔 龔
龔龖 龔龖
龔龖龗 龔龖龗
龔龖龗龞 龔龖龗
龔龖龗龞龡 龔龖龗
SELECT `Ｃ１`, LEFT(`Ｃ１`,4) FROM `Ｔ３`;
Ｃ１ LEFT(`Ｃ１`,4)
龔 龔
龔龖 龔龖
龔龖龗 龔龖龗
龔龖龗龞 龔龖龗龞
龔龖龗龞龡 龔龖龗龞
SELECT `Ｃ１`, LEFT(`Ｃ１`,5) FROM `Ｔ３`;
Ｃ１ LEFT(`Ｃ１`,5)
龔 龔
龔龖 龔龖
龔龖龗 龔龖龗
龔龖龗龞 龔龖龗龞
龔龖龗龞龡 龔龖龗龞龡
SELECT `Ｃ１`, LEFT(`Ｃ１`,0) FROM `Ｔ４`;
Ｃ１ LEFT(`Ｃ１`,0)
ｱ
ｱｲ
ｱｲｳ
ｱｲｳｴ
ｱｲｳｴｵ
SELECT `Ｃ１`, LEFT(`Ｃ１`,1) FROM `Ｔ４`;
Ｃ１ LEFT(`Ｃ１`,1)
ｱ ｱ
ｱｲ ｱ
ｱｲｳ ｱ
ｱｲｳｴ ｱ
ｱｲｳｴｵ ｱ
SELECT `Ｃ１`, LEFT(`Ｃ１`,2) FROM `Ｔ４`;
Ｃ１ LEFT(`Ｃ１`,2)
ｱ ｱ
ｱｲ ｱｲ
ｱｲｳ ｱｲ
ｱｲｳｴ ｱｲ
ｱｲｳｴｵ ｱｲ
SELECT `Ｃ１`, LEFT(`Ｃ１`,3) FROM `Ｔ４`;
Ｃ１ LEFT(`Ｃ１`,3)
ｱ ｱ
ｱｲ ｱｲ
ｱｲｳ ｱｲｳ
ｱｲｳｴ ｱｲｳ
ｱｲｳｴｵ ｱｲｳ
SELECT `Ｃ１`, LEFT(`Ｃ１`,4) FROM `Ｔ４`;
Ｃ１ LEFT(`Ｃ１`,4)
ｱ ｱ
ｱｲ ｱｲ
ｱｲｳ ｱｲｳ
ｱｲｳｴ ｱｲｳｴ
ｱｲｳｴｵ ｱｲｳｴ
SELECT `Ｃ１`, LEFT(`Ｃ１`,5) FROM `Ｔ４`;
Ｃ１ LEFT(`Ｃ１`,5)
ｱ ｱ
ｱｲ ｱｲ
ｱｲｳ ｱｲｳ
ｱｲｳｴ ｱｲｳｴ
ｱｲｳｴｵ ｱｲｳｴｵ
SELECT `Ｃ１`, LEFT(`Ｃ１`,0) FROM `Ｔ５`;
Ｃ１ LEFT(`Ｃ１`,0)
あ
あい
あいう
あいうえ
あいうえお
SELECT `Ｃ１`, LEFT(`Ｃ１`,1) FROM `Ｔ５`;
Ｃ１ LEFT(`Ｃ１`,1)
あ あ
あい あ
あいう あ
あいうえ あ
あいうえお あ
SELECT `Ｃ１`, LEFT(`Ｃ１`,2) FROM `Ｔ５`;
Ｃ１ LEFT(`Ｃ１`,2)
あ あ
あい あい
あいう あい
あいうえ あい
あいうえお あい
SELECT `Ｃ１`, LEFT(`Ｃ１`,3) FROM `Ｔ５`;
Ｃ１ LEFT(`Ｃ１`,3)
あ あ
あい あい
あいう あいう
あいうえ あいう
あいうえお あいう
SELECT `Ｃ１`, LEFT(`Ｃ１`,4) FROM `Ｔ５`;
Ｃ１ LEFT(`Ｃ１`,4)
あ あ
あい あい
あいう あいう
あいうえ あいうえ
あいうえお あいうえ
SELECT `Ｃ１`, LEFT(`Ｃ１`,5) FROM `Ｔ５`;
Ｃ１ LEFT(`Ｃ１`,5)
あ あ
あい あい
あいう あいう
あいうえ あいうえ
あいうえお あいうえお
SELECT `Ｃ１`, LEFT(`Ｃ１`,0) FROM `Ｔ６`;
Ｃ１ LEFT(`Ｃ１`,0)
龔
龔龖
龔龖龗
龔龖龗龞
龔龖龗龞龡
SELECT `Ｃ１`, LEFT(`Ｃ１`,1) FROM `Ｔ６`;
Ｃ１ LEFT(`Ｃ１`,1)
龔 龔
龔龖 龔
龔龖龗 龔
龔龖龗龞 龔
龔龖龗龞龡 龔
SELECT `Ｃ１`, LEFT(`Ｃ１`,2) FROM `Ｔ６`;
Ｃ１ LEFT(`Ｃ１`,2)
龔 龔
龔龖 龔龖
龔龖龗 龔龖
龔龖龗龞 龔龖
龔龖龗龞龡 龔龖
SELECT `Ｃ１`, LEFT(`Ｃ１`,3) FROM `Ｔ６`;
Ｃ１ LEFT(`Ｃ１`,3)
龔 龔
龔龖 龔龖
龔龖龗 龔龖龗
龔龖龗龞 龔龖龗
龔龖龗龞龡 龔龖龗
SELECT `Ｃ１`, LEFT(`Ｃ１`,4) FROM `Ｔ６`;
Ｃ１ LEFT(`Ｃ１`,4)
龔 龔
龔龖 龔龖
龔龖龗 龔龖龗
龔龖龗龞 龔龖龗龞
龔龖龗龞龡 龔龖龗龞
SELECT `Ｃ１`, LEFT(`Ｃ１`,5) FROM `Ｔ６`;
Ｃ１ LEFT(`Ｃ１`,5)
龔 龔
龔龖 龔龖
龔龖龗 龔龖龗
龔龖龗龞 龔龖龗龞
龔龖龗龞龡 龔龖龗龞龡
SELECT `Ｃ１`, LEFT(`Ｃ１`,0) FROM `Ｔ７`;
Ｃ１ LEFT(`Ｃ１`,0)
ｱｲｳｴｵ
ｱｲｳｴ
ｱｲｳ
ｱｲ
ｱ
SELECT `Ｃ１`, LEFT(`Ｃ１`,1) FROM `Ｔ７`;
Ｃ１ LEFT(`Ｃ１`,1)
ｱｲｳｴｵ ｱ
ｱｲｳｴ ｱ
ｱｲｳ ｱ
ｱｲ ｱ
ｱ ｱ
SELECT `Ｃ１`, LEFT(`Ｃ１`,2) FROM `Ｔ７`;
Ｃ１ LEFT(`Ｃ１`,2)
ｱｲｳｴｵ ｱｲ
ｱｲｳｴ ｱｲ
ｱｲｳ ｱｲ
ｱｲ ｱｲ
ｱ ｱ
SELECT `Ｃ１`, LEFT(`Ｃ１`,3) FROM `Ｔ７`;
Ｃ１ LEFT(`Ｃ１`,3)
ｱｲｳｴｵ ｱｲｳ
ｱｲｳｴ ｱｲｳ
ｱｲｳ ｱｲｳ
ｱｲ ｱｲ
ｱ ｱ
SELECT `Ｃ１`, LEFT(`Ｃ１`,4) FROM `Ｔ７`;
Ｃ１ LEFT(`Ｃ１`,4)
ｱｲｳｴｵ ｱｲｳｴ
ｱｲｳｴ ｱｲｳｴ
ｱｲｳ ｱｲｳ
ｱｲ ｱｲ
ｱ ｱ
SELECT `Ｃ１`, LEFT(`Ｃ１`,5) FROM `Ｔ７`;
Ｃ１ LEFT(`Ｃ１`,5)
ｱｲｳｴｵ ｱｲｳｴｵ
ｱｲｳｴ ｱｲｳｴ
ｱｲｳ ｱｲｳ
ｱｲ ｱｲ
ｱ ｱ
SELECT `Ｃ１`, LEFT(`Ｃ１`,0) FROM `Ｔ８`;
Ｃ１ LEFT(`Ｃ１`,0)
あいうえお
あいうえ
あいう
あい
あ
SELECT `Ｃ１`, LEFT(`Ｃ１`,1) FROM `Ｔ８`;
Ｃ１ LEFT(`Ｃ１`,1)
あいうえお あ
あいうえ あ
あいう あ
あい あ
あ あ
SELECT `Ｃ１`, LEFT(`Ｃ１`,2) FROM `Ｔ８`;
Ｃ１ LEFT(`Ｃ１`,2)
あいうえお あい
あいうえ あい
あいう あい
あい あい
あ あ
SELECT `Ｃ１`, LEFT(`Ｃ１`,3) FROM `Ｔ８`;
Ｃ１ LEFT(`Ｃ１`,3)
あいうえお あいう
あいうえ あいう
あいう あいう
あい あい
あ あ
SELECT `Ｃ１`, LEFT(`Ｃ１`,4) FROM `Ｔ８`;
Ｃ１ LEFT(`Ｃ１`,4)
あいうえお あいうえ
あいうえ あいうえ
あいう あいう
あい あい
あ あ
SELECT `Ｃ１`, LEFT(`Ｃ１`,5) FROM `Ｔ８`;
Ｃ１ LEFT(`Ｃ１`,5)
あいうえお あいうえお
あいうえ あいうえ
あいう あいう
あい あい
あ あ
SELECT `Ｃ１`, LEFT(`Ｃ１`,0) FROM `Ｔ９`;
Ｃ１ LEFT(`Ｃ１`,0)
龔龖龗龞龡
龔龖龗龞
龔龖龗
龔龖
龔
SELECT `Ｃ１`, LEFT(`Ｃ１`,1) FROM `Ｔ９`;
Ｃ１ LEFT(`Ｃ１`,1)
龔龖龗龞龡 龔
龔龖龗龞 龔
龔龖龗 龔
龔龖 龔
龔 龔
SELECT `Ｃ１`, LEFT(`Ｃ１`,2) FROM `Ｔ９`;
Ｃ１ LEFT(`Ｃ１`,2)
龔龖龗龞龡 龔龖
龔龖龗龞 龔龖
龔龖龗 龔龖
龔龖 龔龖
龔 龔
SELECT `Ｃ１`, LEFT(`Ｃ１`,3) FROM `Ｔ９`;
Ｃ１ LEFT(`Ｃ１`,3)
龔龖龗龞龡 龔龖龗
龔龖龗龞 龔龖龗
龔龖龗 龔龖龗
龔龖 龔龖
龔 龔
SELECT `Ｃ１`, LEFT(`Ｃ１`,4) FROM `Ｔ９`;
Ｃ１ LEFT(`Ｃ１`,4)
龔龖龗龞龡 龔龖龗龞
龔龖龗龞 龔龖龗龞
龔龖龗 龔龖龗
龔龖 龔龖
龔 龔
SELECT `Ｃ１`, LEFT(`Ｃ１`,5) FROM `Ｔ９`;
Ｃ１ LEFT(`Ｃ１`,5)
龔龖龗龞龡 龔龖龗龞龡
龔龖龗龞 龔龖龗龞
龔龖龗 龔龖龗
龔龖 龔龖
龔 龔
DROP TABLE `Ｔ１`;
DROP TABLE `Ｔ２`;
DROP TABLE `Ｔ３`;
DROP TABLE `Ｔ４`;
DROP TABLE `Ｔ５`;
DROP TABLE `Ｔ６`;
DROP TABLE `Ｔ７`;
DROP TABLE `Ｔ８`;
DROP TABLE `Ｔ９`;
Reference in New Issue View Git Blame Copy Permalink