diff options
Diffstat (limited to 'mysql-test/r/func_misc.result')
| -rw-r--r-- | mysql-test/r/func_misc.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/func_misc.result b/mysql-test/r/func_misc.result index 25e9c869793..4e38754788c 100644 --- a/mysql-test/r/func_misc.result +++ b/mysql-test/r/func_misc.result @@ -1446,6 +1446,15 @@ a1 VARCHAR(30) DEFAULT INET_NTOA(b), c INT DEFAULT IS_IPV4(a), d INT DEFAULT IS_IPV6(a) ); +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(30) DEFAULT NULL, + `b` bigint(20) DEFAULT INET_ATON(a), + `a1` varchar(30) DEFAULT INET_NTOA(b), + `c` int(11) DEFAULT IS_IPV4(a), + `d` int(11) DEFAULT IS_IPV6(a) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 INSERT INTO t1 (a) VALUES ('192.168.001.001'),('::1'),('xxx'); SELECT * FROM t1; a b a1 c d @@ -1460,6 +1469,15 @@ str1 VARCHAR(128) DEFAULT INET6_NTOA(addr), b INT DEFAULT IS_IPV4_COMPAT(addr), c INT DEFAULT IS_IPV4_MAPPED(addr) ); +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `str` varchar(128) DEFAULT NULL, + `addr` varbinary(16) DEFAULT INET6_ATON(str), + `str1` varchar(128) DEFAULT INET6_NTOA(addr), + `b` int(11) DEFAULT IS_IPV4_COMPAT(addr), + `c` int(11) DEFAULT IS_IPV4_MAPPED(addr) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 INSERT INTO t1 (str) VALUES ('::FFFF:192.168.0.1'),('::10.0.5.9'); SELECT str, str1, b,c FROM t1; str str1 b c |