diff options
author | Sergei Golubchik <sergii@pisem.net> | 2011-12-12 23:58:40 +0100 |
---|---|---|
committer | Sergei Golubchik <sergii@pisem.net> | 2011-12-12 23:58:40 +0100 |
commit | 2ccf247e939b39d1f84908a56b8717150e5fd1b4 (patch) | |
tree | c0a9a318a055f87e13206656d7765f96d3293d9f /mysql-test/r/cast.result | |
parent | 6cc9d0ffa0b6d9d0f19cf9445fad0e0ba11e38f8 (diff) | |
download | mariadb-git-2ccf247e939b39d1f84908a56b8717150e5fd1b4.tar.gz |
after merge changes:
* rename all debugging related command-line options
and variables to start from "debug-", and made them all
OFF by default.
* replace "MySQL" with "MariaDB" in error messages
* "Cast ... converted ... integer to it's ... complement"
is now a note, not a warning
* @@query_cache_strip_comments now has a session scope,
not global.
Diffstat (limited to 'mysql-test/r/cast.result')
-rw-r--r-- | mysql-test/r/cast.result | 22 |
1 files changed, 11 insertions, 11 deletions
diff --git a/mysql-test/r/cast.result b/mysql-test/r/cast.result index 918122385e9..f5f287fea88 100644 --- a/mysql-test/r/cast.result +++ b/mysql-test/r/cast.result @@ -2,12 +2,12 @@ select CAST(1-2 AS UNSIGNED); CAST(1-2 AS UNSIGNED) 18446744073709551615 Warnings: -Warning 1105 Cast to unsigned converted negative integer to it's positive complement +Note 1105 Cast to unsigned converted negative integer to it's positive complement select CAST(CAST(1-2 AS UNSIGNED) AS SIGNED INTEGER); CAST(CAST(1-2 AS UNSIGNED) AS SIGNED INTEGER) -1 Warnings: -Warning 1105 Cast to unsigned converted negative integer to it's positive complement +Note 1105 Cast to unsigned converted negative integer to it's positive complement select CAST('10 ' as unsigned integer); CAST('10 ' as unsigned integer) 10 @@ -17,14 +17,14 @@ select cast(-5 as unsigned) | 1, cast(-5 as unsigned) & -1; cast(-5 as unsigned) | 1 cast(-5 as unsigned) & -1 18446744073709551611 18446744073709551611 Warnings: -Warning 1105 Cast to unsigned converted negative integer to it's positive complement -Warning 1105 Cast to unsigned converted negative integer to it's positive complement +Note 1105 Cast to unsigned converted negative integer to it's positive complement +Note 1105 Cast to unsigned converted negative integer to it's positive complement select cast(-5 as unsigned) -1, cast(-5 as unsigned) + 1; cast(-5 as unsigned) -1 cast(-5 as unsigned) + 1 18446744073709551610 18446744073709551612 Warnings: -Warning 1105 Cast to unsigned converted negative integer to it's positive complement -Warning 1105 Cast to unsigned converted negative integer to it's positive complement +Note 1105 Cast to unsigned converted negative integer to it's positive complement +Note 1105 Cast to unsigned converted negative integer to it's positive complement select ~5, cast(~5 as signed); ~5 cast(~5 as signed) 18446744073709551610 -6 @@ -359,12 +359,12 @@ select cast('9223372036854775809' as signed); cast('9223372036854775809' as signed) -9223372036854775807 Warnings: -Warning 1105 Cast to signed converted positive out-of-range integer to it's negative complement +Note 1105 Cast to signed converted positive out-of-range integer to it's negative complement select cast('-1' as unsigned); cast('-1' as unsigned) 18446744073709551615 Warnings: -Warning 1105 Cast to unsigned converted negative integer to it's positive complement +Note 1105 Cast to unsigned converted negative integer to it's positive complement select cast('abc' as signed); cast('abc' as signed) 0 @@ -554,7 +554,7 @@ select cast('18446744073709551615' as signed); cast('18446744073709551615' as signed) -1 Warnings: -Warning 1105 Cast to signed converted positive out-of-range integer to it's negative complement +Note 1105 Cast to signed converted positive out-of-range integer to it's negative complement select cast('9223372036854775807' as signed); cast('9223372036854775807' as signed) 9223372036854775807 @@ -565,7 +565,7 @@ select cast(concat('184467440','73709551615') as signed); cast(concat('184467440','73709551615') as signed) -1 Warnings: -Warning 1105 Cast to signed converted positive out-of-range integer to it's negative complement +Note 1105 Cast to signed converted positive out-of-range integer to it's negative complement select cast(repeat('1',20) as unsigned); cast(repeat('1',20) as unsigned) 11111111111111111111 @@ -573,7 +573,7 @@ select cast(repeat('1',20) as signed); cast(repeat('1',20) as signed) -7335632962598440505 Warnings: -Warning 1105 Cast to signed converted positive out-of-range integer to it's negative complement +Note 1105 Cast to signed converted positive out-of-range integer to it's negative complement select cast(1.0e+300 as signed int); cast(1.0e+300 as signed int) 9223372036854775807 |