summaryrefslogtreecommitdiff
path: root/mysql-test/r/cast.result
diff options
context:
space:
mode:
authorunknown <serg@sergbook.mylan>2003-11-08 16:00:00 +0100
committerunknown <serg@sergbook.mylan>2003-11-08 16:00:00 +0100
commit9dbaca650210a6eaac3e89cc0e219a2398fb58f5 (patch)
tree8635191bab0519aa253e02dc737794b81efbc186 /mysql-test/r/cast.result
parent21b624f046c4efbb0fd1f25135cc6663ab3ded4e (diff)
parentb036800ee04fb4c15f47305ba83a55d0246921f6 (diff)
downloadmariadb-git-9dbaca650210a6eaac3e89cc0e219a2398fb58f5.tar.gz
Merge bk-internal.mysql.com:/home/bk/mysql-4.1
into sergbook.mylan:/usr/home/serg/Abk/mysql-4.1 mysql-test/r/fulltext.result: Auto merged mysql-test/t/fulltext.test: Auto merged
Diffstat (limited to 'mysql-test/r/cast.result')
-rw-r--r--mysql-test/r/cast.result5
1 files changed, 5 insertions, 0 deletions
diff --git a/mysql-test/r/cast.result b/mysql-test/r/cast.result
index d604a17d270..974a79580ae 100644
--- a/mysql-test/r/cast.result
+++ b/mysql-test/r/cast.result
@@ -16,6 +16,11 @@ cast(-5 as unsigned) -1 cast(-5 as unsigned) + 1
select ~5, cast(~5 as signed);
~5 cast(~5 as signed)
18446744073709551610 -6
+explain extended select ~5, cast(~5 as signed);
+id select_type table type possible_keys key key_len ref rows Extra
+1 SIMPLE NULL NULL NULL NULL NULL NULL NULL No tables used
+Warnings:
+Note 1003 select high_priority ~(5) AS `~5`,cast(~(5) as signed) AS `cast(~5 as signed)`
select cast(5 as unsigned) -6.0;
cast(5 as unsigned) -6.0
-1.0