--disable_warnings
drop table if exists `t1`;
--enable_warnings

#
# Test SUBSTRING() function in ucs2 encoding
#

SET character_set_database = ucs2;
SET collation_connection = ucs2_general_ci;

CREATE TABLE `t1` (`c1` char(5)) DEFAULT CHARSET = ucs2;

INSERT INTO `t1` VALUES ('abcde'),('abcd'),('abc'),('ab'),('a'),('');

SELECT `c1`, SUBSTRING(`c1`,0) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1`,1) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1`,2) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1`,3) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1`,4) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1`,5) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1`,6) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1` FROM 0) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1` FROM 1) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1` FROM 2) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1` FROM 3) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1` FROM 4) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1` FROM 5) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1` FROM 6) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1`,1,0) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1`,1,1) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1`,1,2) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1`,1,3) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1`,1,4) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1`,1,5) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1`,1,6) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1` FROM 1 FOR 0) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1` FROM 1 FOR 1) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1` FROM 1 FOR 2) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1` FROM 1 FOR 3) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1` FROM 1 FOR 4) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1` FROM 1 FOR 5) FROM `t1`;
SELECT `c1`, SUBSTRING(`c1` FROM 1 FOR 6) FROM `t1`;

DROP TABLE `t1`;