diff options
Diffstat (limited to 'mysql-test/main/cast.result')
| -rw-r--r-- | mysql-test/main/cast.result | 111 |
1 files changed, 96 insertions, 15 deletions
diff --git a/mysql-test/main/cast.result b/mysql-test/main/cast.result index d500ef4fa1d..496dea7c96f 100644 --- a/mysql-test/main/cast.result +++ b/mysql-test/main/cast.result @@ -9,7 +9,6 @@ CAST(CAST(1-2 AS UNSIGNED) AS SIGNED INTEGER) -1 Warnings: Note 1105 Cast to unsigned converted negative integer to it's positive complement -Note 1105 Cast to signed converted positive out-of-range integer to it's negative complement select CAST('10 ' as unsigned integer); CAST('10 ' as unsigned integer) 10 @@ -30,8 +29,6 @@ Note 1105 Cast to unsigned converted negative integer to it's positive complemen select ~5, cast(~5 as signed); ~5 cast(~5 as signed) 18446744073709551610 -6 -Warnings: -Note 1105 Cast to signed converted positive out-of-range integer to it's negative complement explain extended select ~5, cast(~5 as signed); id select_type table type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL NULL No tables used @@ -40,8 +37,6 @@ Note 1003 select ~5 AS `~5`,cast(~5 as signed) AS `cast(~5 as signed)` select cast(18446744073709551615 as signed); cast(18446744073709551615 as signed) -1 -Warnings: -Note 1105 Cast to signed converted positive out-of-range integer to it's negative complement select cast(5 as unsigned) -6.0; cast(5 as unsigned) -6.0 -1.0 @@ -217,16 +212,12 @@ CAST(0xb3 as signed) select CAST(0x8fffffffffffffff as signed); CAST(0x8fffffffffffffff as signed) -8070450532247928833 -Warnings: -Note 1105 Cast to signed converted positive out-of-range integer to it's negative complement select CAST(0xffffffffffffffff as unsigned); CAST(0xffffffffffffffff as unsigned) 18446744073709551615 select CAST(0xfffffffffffffffe as signed); CAST(0xfffffffffffffffe as signed) -2 -Warnings: -Note 1105 Cast to signed converted positive out-of-range integer to it's negative complement select cast('-10a' as signed integer); cast('-10a' as signed integer) -10 @@ -322,7 +313,7 @@ select cast('' as time); cast('' as time) NULL Warnings: -Warning 1292 Truncated incorrect time value: '' +Warning 1292 Incorrect time value: '' select cast(NULL as DATE); cast(NULL as DATE) NULL @@ -563,8 +554,6 @@ cast(18446744073709551615 as unsigned) select cast(18446744073709551615 as signed); cast(18446744073709551615 as signed) -1 -Warnings: -Note 1105 Cast to signed converted positive out-of-range integer to it's negative complement select cast('18446744073709551615' as unsigned); cast('18446744073709551615' as unsigned) 18446744073709551615 @@ -595,6 +584,8 @@ Note 1105 Cast to signed converted positive out-of-range integer to it's negativ select cast(1.0e+300 as signed int); cast(1.0e+300 as signed int) 9223372036854775807 +Warnings: +Note 1916 Got overflow when converting '1e300' to SIGNED BIGINT. Value truncated create table t1 select cast(1 as unsigned), cast(1 as signed), cast(1 as double(5,2)), cast(1 as decimal(5,3)), cast("A" as binary), cast("A" as char(100)), cast("2001-1-1" as DATE), cast("2001-1-1" as DATETIME), cast("1:2:3" as TIME); show create table t1; Table Create Table @@ -618,8 +609,8 @@ double_val cast_val -1e30 -9223372036854775808 1e30 9223372036854775807 Warnings: -Warning 1916 Got overflow when converting '-1e30' to INT. Value truncated -Warning 1916 Got overflow when converting '1e30' to INT. Value truncated +Note 1916 Got overflow when converting '-1e30' to SIGNED BIGINT. Value truncated +Note 1916 Got overflow when converting '1e30' to SIGNED BIGINT. Value truncated DROP TABLE t1; select isnull(date(NULL)), isnull(cast(NULL as DATE)); isnull(date(NULL)) isnull(cast(NULL as DATE)) @@ -1294,5 +1285,95 @@ SET sql_mode=DEFAULT; SELECT CAST(11068046444225730969 AS SIGNED); CAST(11068046444225730969 AS SIGNED) -7378697629483820647 +# +# MDEV-8919 Wrong result for CAST(9999999999999999999.0) +# +SET sql_mode=''; +SELECT CAST(9999999999999999999e0 AS UNSIGNED); +CAST(9999999999999999999e0 AS UNSIGNED) +10000000000000000000 +CREATE TABLE t1 (a BIGINT UNSIGNED); +INSERT INTO t1 VALUES (9999999999999999999e0); +SELECT * FROM t1; +a +10000000000000000000 +DROP TABLE t1; +SELECT CAST(9999999999999999999.0 AS UNSIGNED); +CAST(9999999999999999999.0 AS UNSIGNED) +9999999999999999999 +CREATE TABLE t1 (a BIGINT UNSIGNED); +INSERT INTO t1 VALUES (9999999999999999999.0); +SELECT * FROM t1; +a +9999999999999999999 +DROP TABLE t1; +SELECT CAST(-1.0 AS UNSIGNED); +CAST(-1.0 AS UNSIGNED) +0 Warnings: -Note 1105 Cast to signed converted positive out-of-range integer to it's negative complement +Warning 1916 Got overflow when converting '-1.0' to UNSIGNED INT. Value truncated +CREATE TABLE t1 (a BIGINT UNSIGNED); +INSERT INTO t1 VALUES (-1.0); +Warnings: +Warning 1264 Out of range value for column 'a' at row 1 +SELECT * FROM t1; +a +0 +DROP TABLE t1; +SELECT CAST(-1e0 AS UNSIGNED); +CAST(-1e0 AS UNSIGNED) +0 +Warnings: +Note 1916 Got overflow when converting '-1' to UNSIGNED BIGINT. Value truncated +CREATE TABLE t1 (a BIGINT UNSIGNED); +INSERT INTO t1 VALUES (-1e0); +Warnings: +Warning 1264 Out of range value for column 'a' at row 1 +SELECT * FROM t1; +a +0 +DROP TABLE t1; +SELECT CAST(-1e308 AS UNSIGNED); +CAST(-1e308 AS UNSIGNED) +0 +Warnings: +Note 1916 Got overflow when converting '-1e308' to UNSIGNED BIGINT. Value truncated +CREATE TABLE t1 (a BIGINT UNSIGNED); +INSERT INTO t1 VALUES (-1e308); +Warnings: +Warning 1264 Out of range value for column 'a' at row 1 +SELECT * FROM t1; +a +0 +DROP TABLE t1; +SELECT CAST(TIME'-00:00:01.123' AS UNSIGNED); +CAST(TIME'-00:00:01.123' AS UNSIGNED) +0 +Warnings: +Note 1916 Got overflow when converting '-00:00:01.123000' to UNSIGNED BIGINT. Value truncated +CREATE TABLE t1 (a BIGINT UNSIGNED); +INSERT INTO t1 VALUES (TIME'-00:00:01.123'); +Warnings: +Warning 1264 Out of range value for column 'a' at row 1 +SELECT * FROM t1; +a +0 +DROP TABLE t1; +CREATE TABLE t1 (a DOUBLE UNSIGNED); +INSERT INTO t1 VALUES (1.9e19); +SELECT CAST(a AS SIGNED), CAST(MIN(a) AS SIGNED) FROM t1; +CAST(a AS SIGNED) CAST(MIN(a) AS SIGNED) +9223372036854775807 9223372036854775807 +Warnings: +Note 1916 Got overflow when converting '1.9e19' to SIGNED BIGINT. Value truncated +Note 1916 Got overflow when converting '1.9e19' to SIGNED BIGINT. Value truncated +DROP TABLE t1; +CREATE TABLE t1 (a DECIMAL(30,1) UNSIGNED); +INSERT INTO t1 VALUES (1e19); +SELECT a, CAST(a AS SIGNED) FROM t1; +a CAST(a AS SIGNED) +10000000000000000000.0 9223372036854775807 +Warnings: +Warning 1916 Got overflow when converting '10000000000000000000.0' to INT. Value truncated +DROP TABLE t1; +SET sql_mode=DEFAULT; |