jp_substring_utf8.test

来自「这个文件是windows mysql源码」· TEST 代码 · 共 413 行 · 第 1/2 页

SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 5) FROM `Ｔ６`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 6) FROM `Ｔ６`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,0) FROM `Ｔ６`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,1) FROM `Ｔ６`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,2) FROM `Ｔ６`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,3) FROM `Ｔ６`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,4) FROM `Ｔ６`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,5) FROM `Ｔ６`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,6) FROM `Ｔ６`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 0) FROM `Ｔ６`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 1) FROM `Ｔ６`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 2) FROM `Ｔ６`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 3) FROM `Ｔ６`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 4) FROM `Ｔ６`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 5) FROM `Ｔ６`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 6) FROM `Ｔ６`;

#HEAP
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,0) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,2) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,3) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,4) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,5) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,6) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 0) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 2) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 3) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 4) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 5) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 6) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,0) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,1) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,2) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,3) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,4) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,5) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,6) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 0) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 1) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 2) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 3) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 4) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 5) FROM `Ｔ７`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 6) FROM `Ｔ７`;

SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,0) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,2) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,3) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,4) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,5) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,6) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 0) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 2) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 3) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 4) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 5) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 6) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,0) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,1) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,2) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,3) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,4) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,5) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,6) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 0) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 1) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 2) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 3) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 4) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 5) FROM `Ｔ８`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 6) FROM `Ｔ８`;

SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,0) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,2) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,3) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,4) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,5) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,6) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 0) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 2) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 3) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 4) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 5) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 6) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,0) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,1) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,2) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,3) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,4) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,5) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,6) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 0) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 1) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 2) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 3) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 4) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 5) FROM `Ｔ９`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 6) FROM `Ｔ９`;

#BDB
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,0) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,2) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,3) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,4) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,5) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,6) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 0) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 2) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 3) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 4) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 5) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 6) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,0) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,1) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,2) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,3) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,4) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,5) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,6) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 0) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 1) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 2) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 3) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 4) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 5) FROM `Ｔ１０`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 6) FROM `Ｔ１０`;

SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,0) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,2) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,3) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,4) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,5) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,6) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 0) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 2) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 3) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 4) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 5) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 6) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,0) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,1) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,2) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,3) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,4) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,5) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,6) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 0) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 1) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 2) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 3) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 4) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 5) FROM `Ｔ１１`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 6) FROM `Ｔ１１`;

SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,0) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,2) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,3) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,4) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,5) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,6) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 0) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 2) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 3) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 4) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 5) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 6) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,0) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,1) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,2) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,3) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,4) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,5) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１`,1,6) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 0) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 1) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 2) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 3) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 4) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 5) FROM `Ｔ１２`;
SELECT `Ｃ１`, SUBSTRING(`Ｃ１` FROM 1 FOR 6) FROM `Ｔ１２`;

DROP TABLE `Ｔ１`;
DROP TABLE `Ｔ２`;
DROP TABLE `Ｔ３`;
DROP TABLE `Ｔ４`;
DROP TABLE `Ｔ５`;
DROP TABLE `Ｔ６`;
DROP TABLE `Ｔ７`;
DROP TABLE `Ｔ８`;
DROP TABLE `Ｔ９`;
DROP TABLE `Ｔ１０`;
DROP TABLE `Ｔ１１`;
DROP TABLE `Ｔ１２`;