diff options
author | Alexander Barkov <bar@mariadb.com> | 2018-06-22 11:28:02 +0400 |
---|---|---|
committer | Alexander Barkov <bar@mariadb.com> | 2018-06-22 11:28:02 +0400 |
commit | 1abd877e2df9e83bc1c2f5195796f427a35bd3f1 (patch) | |
tree | 7a1027a95445825ad1ace6a0a04ec2f5c4dee87d /mysql-test/main/func_misc.result | |
parent | bcc2100f9d0bd1a2c21acd0de831e9dd1b8a703e (diff) | |
download | mariadb-git-1abd877e2df9e83bc1c2f5195796f427a35bd3f1.tar.gz |
MDEV-8049 name_const() is not consistent about its signess
Diffstat (limited to 'mysql-test/main/func_misc.result')
-rw-r--r-- | mysql-test/main/func_misc.result | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/main/func_misc.result b/mysql-test/main/func_misc.result index e7a416f8ea6..0ab07664e6c 100644 --- a/mysql-test/main/func_misc.result +++ b/mysql-test/main/func_misc.result @@ -1562,3 +1562,23 @@ Catalog Database Table Table_alias Column Column_alias Type Length Max length Is def INET_ATON("255.255.255.255.255.255.255.255") 8 21 20 Y 32928 0 63 INET_ATON("255.255.255.255.255.255.255.255") 18446744073709551615 +# +# MDEV-8049 name_const() is not consistent about its signess +# +SELECT 18446744073709551615 AS c1, name_const('a',18446744073709551615) AS c2; +Catalog Database Table Table_alias Column Column_alias Type Length Max length Is_null Flags Decimals Charsetnr +def c1 8 20 20 N 32929 0 63 +def c2 8 20 20 Y 32928 0 63 +c1 c2 +18446744073709551615 18446744073709551615 +CREATE TABLE t1 AS SELECT 18446744073709551615 AS c1, name_const('a',18446744073709551615) AS c2; +SHOW CREATE TABLE t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `c1` bigint(20) unsigned NOT NULL, + `c2` bigint(20) unsigned DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1 +SELECT * FROM t1; +c1 c2 +18446744073709551615 18446744073709551615 +DROP TABLE t1; |