diff options
Diffstat (limited to 'plugin/type_inet/mysql-test/type_inet/type_inet6.result')
-rw-r--r-- | plugin/type_inet/mysql-test/type_inet/type_inet6.result | 54 |
1 files changed, 27 insertions, 27 deletions
diff --git a/plugin/type_inet/mysql-test/type_inet/type_inet6.result b/plugin/type_inet/mysql-test/type_inet/type_inet6.result index ecd1e2f797c..79958ee77f4 100644 --- a/plugin/type_inet/mysql-test/type_inet/type_inet6.result +++ b/plugin/type_inet/mysql-test/type_inet/type_inet6.result @@ -8,7 +8,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` inet6 DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DESCRIBE t1; Field Type Null Key Default Extra a inet6 YES NULL @@ -64,7 +64,7 @@ t1 CREATE TABLE `t1` ( `c3` inet6 DEFAULT '::', `c4` inet6 DEFAULT 'ffff::ffff', `c5` inet6 DEFAULT cast(X'ffffffffffffffffffffffffffffffff' as inet6) -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DESCRIBE t1; Field Type Null Key Default Extra c1 inet6 YES :: @@ -222,7 +222,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `CAST('::' AS INET6)` inet6 NOT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; # # Text and binary formats, comparison operators @@ -428,7 +428,7 @@ t2 CREATE TABLE `t2` ( `COALESCE(c, c_text)` inet6 DEFAULT NULL, `COALESCE(c, c_mediumtext)` inet6 DEFAULT NULL, `COALESCE(c, c_longtext)` inet6 DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; CREATE TABLE t2 AS SELECT LEAST(c, c_char), @@ -447,7 +447,7 @@ t2 CREATE TABLE `t2` ( `LEAST(c, c_text)` inet6 DEFAULT NULL, `LEAST(c, c_mediumtext)` inet6 DEFAULT NULL, `LEAST(c, c_longtext)` inet6 DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; DROP TABLE t1; CREATE TABLE t1 (a INET6); @@ -478,7 +478,7 @@ t2 CREATE TABLE `t2` ( `COALESCE(a, '::')` inet6 DEFAULT NULL, `LEAST(a,'::')` inet6 DEFAULT NULL, `GREATEST(a,'::')` inet6 DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SELECT COALESCE(a, 0x00000000000000000000000000000000) FROM t1 ORDER BY a; COALESCE(a, 0x00000000000000000000000000000000) @@ -512,7 +512,7 @@ t2 CREATE TABLE `t2` ( `COALESCE(a, 0x00000000000000000000000000000000)` inet6 DEFAULT NULL, `LEAST(a,0x00000000000000000000000000000000)` inet6 DEFAULT NULL, `GREATEST(a,0x00000000000000000000000000000000)` inet6 DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SELECT COALESCE(a, 10) FROM t1; ERROR HY000: Illegal parameter data types inet6 and int for operation 'coalesce' @@ -720,7 +720,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` varchar(39) DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; CREATE TABLE t1 (a INET6); INSERT INTO t1 VALUES ('ffff::ffff'); @@ -743,7 +743,7 @@ t2 CREATE TABLE `t2` ( `CAST(a AS CHAR(66000))` mediumtext DEFAULT NULL, `CAST(a AS CHAR(16777215))` mediumtext DEFAULT NULL, `CAST(a AS CHAR(16777216))` longtext DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci SELECT * FROM t2; CAST(a AS CHAR) ffff::ffff CAST(a AS CHAR(39)) ffff::ffff @@ -779,7 +779,7 @@ t2 CREATE TABLE `t2` ( `cb66000` mediumblob DEFAULT NULL, `cb16777215` mediumblob DEFAULT NULL, `cb16777216` longblob DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; CREATE TABLE t2 AS SELECT CAST(a AS BINARY(4)) AS cb4, @@ -798,7 +798,7 @@ t2 CREATE TABLE `t2` ( `cb32` binary(32) DEFAULT NULL, `cb530` varbinary(530) DEFAULT NULL, `cb65535` blob DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci SELECT HEX(cb4), HEX(cb), @@ -887,7 +887,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `MIN(a)` inet6 DEFAULT NULL, `MAX(a)` inet6 DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; SELECT AVG(a) FROM t1; ERROR HY000: Illegal parameter data type inet6 for operation 'avg(' @@ -953,7 +953,7 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `a` inet6 NOT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci EXECUTE IMMEDIATE 'INSERT INTO t1 VALUES (?)' USING '::1'; EXECUTE IMMEDIATE 'INSERT INTO t1 VALUES (?)' USING CAST('::2' AS INET6); EXECUTE IMMEDIATE 'INSERT INTO t1 VALUES (?)' USING 0x00000000000000000000000000000003; @@ -986,7 +986,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `c1` varchar(39) DEFAULT NULL, `c2` varchar(39) DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; CREATE TABLE t2 AS SELECT CONCAT(_utf8'1', a) AS c1, @@ -996,10 +996,10 @@ FROM t1; SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( - `c1` varchar(40) CHARACTER SET utf8mb3 DEFAULT NULL, - `c2` varchar(40) CHARACTER SET utf8mb3 DEFAULT NULL, - `c3` varchar(40) CHARACTER SET utf8mb3 DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 + `c1` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, + `c2` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL, + `c3` varchar(40) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; CREATE TABLE t2 AS SELECT CONCAT(_latin1'1', a) AS c1, @@ -1012,7 +1012,7 @@ t2 CREATE TABLE `t2` ( `c1` varchar(40) DEFAULT NULL, `c2` varchar(40) DEFAULT NULL, `c3` varchar(40) DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; DROP TABLE t1; # @@ -1023,21 +1023,21 @@ SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c` inet6 NOT NULL DEFAULT '::' -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; CREATE TABLE t1 AS SELECT CAST('::' AS INET6) AS c UNION SELECT '::1'; SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c` inet6 NOT NULL DEFAULT '::' -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; CREATE TABLE t1 AS SELECT '::' AS c UNION SELECT CAST('::1' AS INET6); SHOW CREATE TABLE t1; Table Create Table t1 CREATE TABLE `t1` ( `c` inet6 NOT NULL DEFAULT '::' -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t1; CREATE TABLE t1 AS SELECT CAST('::' AS INET6) AS c UNION SELECT 0x00000000000000000000000000000001; SELECT * FROM t1; @@ -2101,7 +2101,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `ca` inet6 NOT NULL, `cb` inet6 DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; CREATE TABLE t2 AS SELECT COALESCE(a,a), COALESCE(a,b) FROM t1; SHOW CREATE TABLE t2; @@ -2109,7 +2109,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `COALESCE(a,a)` inet6 NOT NULL, `COALESCE(a,b)` inet6 DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; CREATE TABLE t2 AS SELECT a AS ca,a AS cb FROM t1 UNION SELECT a,b FROM t1; SHOW CREATE TABLE t2; @@ -2117,7 +2117,7 @@ Table Create Table t2 CREATE TABLE `t2` ( `ca` inet6 NOT NULL DEFAULT '::', `cb` inet6 DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci DROP TABLE t2; DROP TABLE t1; # @@ -2141,7 +2141,7 @@ SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `IFNULL(c, 'foo')` inet6 DEFAULT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci SELECT * FROM t2; IFNULL(c, 'foo') :: @@ -2152,7 +2152,7 @@ SHOW CREATE TABLE t2; Table Create Table t2 CREATE TABLE `t2` ( `IFNULL(c, '::1')` inet6 NOT NULL -) ENGINE=MyISAM DEFAULT CHARSET=latin1 +) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci SELECT * FROM t2; IFNULL(c, '::1') :: |