diff options
Diffstat (limited to 'mysql-test/main/cast.result')
| -rw-r--r-- | mysql-test/main/cast.result | 40 |
1 files changed, 20 insertions, 20 deletions
diff --git a/mysql-test/main/cast.result b/mysql-test/main/cast.result index 9758ad64d4a..45665e7d290 100644 --- a/mysql-test/main/cast.result +++ b/mysql-test/main/cast.result @@ -417,8 +417,8 @@ create table t1 select cast(_koi8r'ΤΕΣΤ' as char character set cp1251) as t; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( - `t` varchar(4) CHARACTER SET cp1251 DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 + `t` varchar(4) CHARACTER SET cp1251 COLLATE cp1251_general_ci DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci drop table t1; select cast(_latin1'ab' AS char) as c1, @@ -457,7 +457,7 @@ t1 CREATE TABLE `t1` ( `c3` varbinary(2) NOT NULL, `c4` varbinary(2) NOT NULL, `c5` varbinary(2) NOT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci drop table t1; select cast(_koi8r'ΖΗ' AS nchar) as c1, @@ -486,12 +486,12 @@ c1 c2 c3 c4 c5 show create table t1; Table Create Table t1 CREATE TABLE `t1` ( - `c1` varchar(2) CHARACTER SET utf8 NOT NULL, - `c2` varchar(2) CHARACTER SET utf8 NOT NULL, - `c3` varchar(2) CHARACTER SET utf8 NOT NULL, - `c4` varchar(2) CHARACTER SET utf8 NOT NULL, - `c5` varchar(2) CHARACTER SET utf8 NOT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 + `c1` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, + `c2` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, + `c3` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, + `c4` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, + `c5` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci drop table t1; create table t1 (a binary(4), b char(4) character set koi8r); insert into t1 values (_binary'ΤΕΣΤ',_binary'ΤΕΣΤ'); @@ -608,7 +608,7 @@ t1 CREATE TABLE `t1` ( `cast("2001-1-1" as DATE)` date DEFAULT NULL, `cast("2001-1-1" as DATETIME)` datetime DEFAULT NULL, `cast("1:2:3" as TIME)` time DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci drop table t1; CREATE TABLE t1 (f1 double); INSERT INTO t1 SET f1 = -1.0e+30 ; @@ -775,7 +775,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `CONCAT(CAST(REPEAT('9', 1000) AS SIGNED))` varchar(21) NOT NULL, `CONCAT(CAST(REPEAT('9', 1000) AS UNSIGNED))` varchar(20) NOT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; # End of test for Bug#13581962, Bug#14096619 End of 5.1 tests @@ -824,7 +824,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL, `b` char(5) GENERATED ALWAYS AS (cast('a' as char(10) charset latin1) + `a`) VIRTUAL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci drop table t1; select collation(cast("a" as char(10) binary)); collation(cast("a" as char(10) binary)) @@ -852,28 +852,28 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `IFNULL(CONVERT(NULL, UNSIGNED), NULL)` decimal(1,0) DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; CREATE TABLE t1 AS SELECT COALESCE(CONVERT(NULL, UNSIGNED), NULL); SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `COALESCE(CONVERT(NULL, UNSIGNED), NULL)` decimal(1,0) DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; CREATE TABLE t1 AS SELECT CASE WHEN TRUE THEN CONVERT(NULL, UNSIGNED) ELSE NULL END; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `CASE WHEN TRUE THEN CONVERT(NULL, UNSIGNED) ELSE NULL END` decimal(1,0) DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; CREATE TABLE t1 AS SELECT IFNULL(CONVERT(NULL,SIGNED),CONVERT(NULL,UNSIGNED)) AS a; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` decimal(1,0) DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; CREATE TABLE t1 AS SELECT -1, @@ -891,7 +891,7 @@ t1 CREATE TABLE `t1` ( `1` int(1) NOT NULL, `CONVERT(NULL,UNSIGNED)` int(1) unsigned DEFAULT NULL, `CONCAT(CONVERT(NULL,UNSIGNED))` varchar(1) DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; CREATE TABLE t1 AS SELECT CONVERT('',SIGNED), @@ -910,7 +910,7 @@ t1 CREATE TABLE `t1` ( `CONCAT(CONVERT('',SIGNED))` varchar(2) NOT NULL, `CONVERT('',UNSIGNED)` int(1) unsigned NOT NULL, `CONCAT(CONVERT('',UNSIGNED))` varchar(1) NOT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; # # MDEV-12849 Out-of-range errors when casting hex-hybrid to SIGNED and UNSIGNED @@ -1157,7 +1157,7 @@ Table Create Table t1 CREATE TABLE `t1` ( `CAST(-1 AS UNSIGNED)` bigint(20) unsigned NOT NULL, `CAST(1-2 AS UNSIGNED)` bigint(20) unsigned NOT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci SELECT * FROM t1; CAST(-1 AS UNSIGNED) CAST(1-2 AS UNSIGNED) 18446744073709551615 18446744073709551615 @@ -1174,7 +1174,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `CAST('-1' AS UNSIGNED)` bigint(20) unsigned NOT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci SELECT * FROM t1; CAST('-1' AS UNSIGNED) 18446744073709551615 |