From a175314c3e5827eb193872241446f2f8f5c9d33c Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:07:14 +0200 Subject: Adding upstream version 1:10.5.12. Signed-off-by: Daniel Baumann --- mysql-test/suite/jp/r/jp_ltrim_ucs2.result | 174 +++++++++++++++++++++++++++++ 1 file changed, 174 insertions(+) create mode 100644 mysql-test/suite/jp/r/jp_ltrim_ucs2.result (limited to 'mysql-test/suite/jp/r/jp_ltrim_ucs2.result') diff --git a/mysql-test/suite/jp/r/jp_ltrim_ucs2.result b/mysql-test/suite/jp/r/jp_ltrim_ucs2.result new file mode 100644 index 00000000..c46e917c --- /dev/null +++ b/mysql-test/suite/jp/r/jp_ltrim_ucs2.result @@ -0,0 +1,174 @@ +drop table if exists `T1`; +drop table if exists `T2`; +drop table if exists `T3`; +drop table if exists `T4`; +drop table if exists `T5`; +drop table if exists `T6`; +drop table if exists `T7`; +drop table if exists `T8`; +drop table if exists `T9`; +SET NAMES ujis; +SET character_set_database = ucs2; +SET collation_connection = ucs2_general_ci; +CREATE TABLE `T1` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `T2` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `T3` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engine = innodb; +CREATE TABLE `T4` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engine = myisam; +CREATE TABLE `T5` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engine = myisam; +CREATE TABLE `T6` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engine = myisam; +CREATE TABLE `T7` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engine = MEMORY; +CREATE TABLE `T8` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engine = MEMORY; +CREATE TABLE `T9` (`C1` char(8), INDEX(`C1`)) DEFAULT CHARSET = ucs2 engine = MEMORY; +INSERT INTO `T1` VALUES ('アイウエオ'); +INSERT INTO `T1` VALUES (' アイウエオ'); +INSERT INTO `T1` VALUES (' アイウエオ'); +INSERT INTO `T1` VALUES (' アイウエオ'); +INSERT INTO `T1` VALUES (' アイウエオ'); +INSERT INTO `T1` VALUES ('  アイウエオ'); +INSERT INTO `T1` VALUES ('   アイウエオ'); +INSERT INTO `T2` VALUES ('あいうえお'); +INSERT INTO `T2` VALUES (' あいうえお'); +INSERT INTO `T2` VALUES (' あいうえお'); +INSERT INTO `T2` VALUES (' あいうえお'); +INSERT INTO `T2` VALUES (' あいうえお'); +INSERT INTO `T2` VALUES ('  あいうえお'); +INSERT INTO `T2` VALUES ('   あいうえお'); +INSERT INTO `T3` VALUES ('龔龖龗龞龡'); +INSERT INTO `T3` VALUES (' 龔龖龗龞龡'); +INSERT INTO `T3` VALUES (' 龔龖龗龞龡'); +INSERT INTO `T3` VALUES (' 龔龖龗龞龡'); +INSERT INTO `T3` VALUES (' 龔龖龗龞龡'); +INSERT INTO `T3` VALUES ('  龔龖龗龞龡'); +INSERT INTO `T3` VALUES ('   龔龖龗龞龡'); +INSERT INTO `T4` VALUES ('アイウエオ'); +INSERT INTO `T4` VALUES (' アイウエオ'); +INSERT INTO `T4` VALUES (' アイウエオ'); +INSERT INTO `T4` VALUES (' アイウエオ'); +INSERT INTO `T4` VALUES (' アイウエオ'); +INSERT INTO `T4` VALUES ('  アイウエオ'); +INSERT INTO `T4` VALUES ('   アイウエオ'); +INSERT INTO `T5` VALUES ('あいうえお'); +INSERT INTO `T5` VALUES (' あいうえお'); +INSERT INTO `T5` VALUES (' あいうえお'); +INSERT INTO `T5` VALUES (' あいうえお'); +INSERT INTO `T5` VALUES (' あいうえお'); +INSERT INTO `T5` VALUES ('  あいうえお'); +INSERT INTO `T5` VALUES ('   あいうえお'); +INSERT INTO `T6` VALUES ('龔龖龗龞龡'); +INSERT INTO `T6` VALUES (' 龔龖龗龞龡'); +INSERT INTO `T6` VALUES (' 龔龖龗龞龡'); +INSERT INTO `T6` VALUES (' 龔龖龗龞龡'); +INSERT INTO `T6` VALUES (' 龔龖龗龞龡'); +INSERT INTO `T6` VALUES ('  龔龖龗龞龡'); +INSERT INTO `T6` VALUES ('   龔龖龗龞龡'); +INSERT INTO `T7` VALUES ('アイウエオ'); +INSERT INTO `T7` VALUES (' アイウエオ'); +INSERT INTO `T7` VALUES (' アイウエオ'); +INSERT INTO `T7` VALUES (' アイウエオ'); +INSERT INTO `T7` VALUES (' アイウエオ'); +INSERT INTO `T7` VALUES ('  アイウエオ'); +INSERT INTO `T7` VALUES ('   アイウエオ'); +INSERT INTO `T8` VALUES ('あいうえお'); +INSERT INTO `T8` VALUES (' あいうえお'); +INSERT INTO `T8` VALUES (' あいうえお'); +INSERT INTO `T8` VALUES (' あいうえお'); +INSERT INTO `T8` VALUES (' あいうえお'); +INSERT INTO `T8` VALUES ('  あいうえお'); +INSERT INTO `T8` VALUES ('   あいうえお'); +INSERT INTO `T9` VALUES ('龔龖龗龞龡'); +INSERT INTO `T9` VALUES (' 龔龖龗龞龡'); +INSERT INTO `T9` VALUES (' 龔龖龗龞龡'); +INSERT INTO `T9` VALUES (' 龔龖龗龞龡'); +INSERT INTO `T9` VALUES (' 龔龖龗龞龡'); +INSERT INTO `T9` VALUES ('  龔龖龗龞龡'); +INSERT INTO `T9` VALUES ('   龔龖龗龞龡'); +SELECT LTRIM(`C1`) from `T1`; +LTRIM(`C1`) +アイウエオ +アイウエオ +アイウエオ +   アイウエオ +  アイウエオ + アイウエオ +アイウエオ +SELECT LTRIM(`C1`) from `T2`; +LTRIM(`C1`) +あいうえお +あいうえお +あいうえお +   あいうえお +  あいうえお + あいうえお +あいうえお +SELECT LTRIM(`C1`) from `T3`; +LTRIM(`C1`) +龔龖龗龞龡 +龔龖龗龞龡 +龔龖龗龞龡 +   龔龖龗龞龡 +  龔龖龗龞龡 + 龔龖龗龞龡 +龔龖龗龞龡 +SELECT LTRIM(`C1`) from `T4`; +LTRIM(`C1`) +アイウエオ +アイウエオ +アイウエオ +   アイウエオ +  アイウエオ + アイウエオ +アイウエオ +SELECT LTRIM(`C1`) from `T5`; +LTRIM(`C1`) +あいうえお +あいうえお +あいうえお +   あいうえお +  あいうえお + あいうえお +あいうえお +SELECT LTRIM(`C1`) from `T6`; +LTRIM(`C1`) +龔龖龗龞龡 +龔龖龗龞龡 +龔龖龗龞龡 +   龔龖龗龞龡 +  龔龖龗龞龡 + 龔龖龗龞龡 +龔龖龗龞龡 +SELECT LTRIM(`C1`) from `T7`; +LTRIM(`C1`) +アイウエオ +アイウエオ +アイウエオ +アイウエオ + アイウエオ +  アイウエオ +   アイウエオ +SELECT LTRIM(`C1`) from `T8`; +LTRIM(`C1`) +あいうえお +あいうえお +あいうえお +あいうえお + あいうえお +  あいうえお +   あいうえお +SELECT LTRIM(`C1`) from `T9`; +LTRIM(`C1`) +龔龖龗龞龡 +龔龖龗龞龡 +龔龖龗龞龡 +龔龖龗龞龡 + 龔龖龗龞龡 +  龔龖龗龞龡 +   龔龖龗龞龡 +DROP TABLE `T1`; +DROP TABLE `T2`; +DROP TABLE `T3`; +DROP TABLE `T4`; +DROP TABLE `T5`; +DROP TABLE `T6`; +DROP TABLE `T7`; +DROP TABLE `T8`; +DROP TABLE `T9`; -- cgit v1.2.3