diff options
Diffstat (limited to 'mysql-test/r/dyncol.result')
| -rw-r--r-- | mysql-test/r/dyncol.result | 20 |
1 files changed, 10 insertions, 10 deletions
diff --git a/mysql-test/r/dyncol.result b/mysql-test/r/dyncol.result index ad46cddb785..105123e2f1e 100644 --- a/mysql-test/r/dyncol.result +++ b/mysql-test/r/dyncol.result @@ -47,7 +47,7 @@ select hex(COLUMN_CREATE(1, 99999999999999999999999999999 AS unsigned int)); hex(COLUMN_CREATE(1, 99999999999999999999999999999 AS unsigned int)) 000100010001FFFFFFFFFFFFFF7F Warnings: -Warning 1916 Got overflow when converting '99999999999999999999999999999' to INT. Value truncated. +Warning 1916 Got overflow when converting '99999999999999999999999999999' to INT. Value truncated select hex(COLUMN_CREATE(1, NULL AS int)); hex(COLUMN_CREATE(1, NULL AS int)) 000000 @@ -73,7 +73,7 @@ select hex(COLUMN_CREATE(1, 99999999999999999999999999999 AS int)); hex(COLUMN_CREATE(1, 99999999999999999999999999999 AS int)) 000100010000FEFFFFFFFFFFFFFF Warnings: -Warning 1916 Got overflow when converting '99999999999999999999999999999' to INT. Value truncated. +Warning 1916 Got overflow when converting '99999999999999999999999999999' to INT. Value truncated select hex(COLUMN_CREATE(1, NULL AS double)); hex(COLUMN_CREATE(1, NULL AS double)) 000000 @@ -223,7 +223,7 @@ select column_get(column_create(1, 99999999999999999999999999999 AS decimal), 1 column_get(column_create(1, 99999999999999999999999999999 AS decimal), 1 as unsigned int) 18446744073709551615 Warnings: -Warning 1916 Got overflow when converting '99999999999999999999999999999' to UNSIGNED INT. Value truncated. +Warning 1916 Got overflow when converting '99999999999999999999999999999' to UNSIGNED INT. Value truncated select column_get(column_create(1, 999.9999999999999999 AS decimal), 1 as unsigned int); column_get(column_create(1, 999.9999999999999999 AS decimal), 1 as unsigned int) 1000 @@ -231,12 +231,12 @@ select column_get(column_create(1, -1 AS decimal), 1 as unsigned int); column_get(column_create(1, -1 AS decimal), 1 as unsigned int) 0 Warnings: -Warning 1916 Got overflow when converting '-1' to UNSIGNED INT. Value truncated. +Warning 1916 Got overflow when converting '-1' to UNSIGNED INT. Value truncated select column_get(column_create(1, 99999999999999999999999999999 AS double), 1 as unsigned int); column_get(column_create(1, 99999999999999999999999999999 AS double), 1 as unsigned int) 18446744073709551615 Warnings: -Warning 1916 Got overflow when converting '1e29' to UNSIGNED INT. Value truncated. +Warning 1916 Got overflow when converting '1e29' to UNSIGNED INT. Value truncated select column_get(column_create(1, 999.9 AS double), 1 as unsigned int); column_get(column_create(1, 999.9 AS double), 1 as unsigned int) 1000 @@ -244,7 +244,7 @@ select column_get(column_create(1, -1 AS double), 1 as unsigned int); column_get(column_create(1, -1 AS double), 1 as unsigned int) 0 Warnings: -Warning 1916 Got overflow when converting '-1' to UNSIGNED INT. Value truncated. +Warning 1916 Got overflow when converting '-1' to UNSIGNED INT. Value truncated select column_get(column_create(1, "1212III" AS char), 1 as unsigned int); column_get(column_create(1, "1212III" AS char), 1 as unsigned int) 1212 @@ -314,12 +314,12 @@ select column_get(column_create(1, 99999999999999999999999999999 AS decimal), 1 column_get(column_create(1, 99999999999999999999999999999 AS decimal), 1 as int) 9223372036854775807 Warnings: -Warning 1916 Got overflow when converting '99999999999999999999999999999' to INT. Value truncated. +Warning 1916 Got overflow when converting '99999999999999999999999999999' to INT. Value truncated select column_get(column_create(1, -99999999999999999999999999999 AS decimal), 1 as int); column_get(column_create(1, -99999999999999999999999999999 AS decimal), 1 as int) -9223372036854775808 Warnings: -Warning 1916 Got overflow when converting '-99999999999999999999999999999' to INT. Value truncated. +Warning 1916 Got overflow when converting '-99999999999999999999999999999' to INT. Value truncated select column_get(column_create(1, 999.9999999999999999 AS decimal), 1 as int); column_get(column_create(1, 999.9999999999999999 AS decimal), 1 as int) 1000 @@ -330,7 +330,7 @@ select column_get(column_create(1, -99999999999999999999999999999 AS double), 1 column_get(column_create(1, -99999999999999999999999999999 AS double), 1 as int) -9223372036854775808 Warnings: -Warning 1916 Got overflow when converting '-1e29' to INT. Value truncated. +Warning 1916 Got overflow when converting '-1e29' to INT. Value truncated select column_get(column_create(1, "-1212III" AS char), 1 as int); column_get(column_create(1, "-1212III" AS char), 1 as int) -1212 @@ -1459,7 +1459,7 @@ Note 1105 Cast to signed converted positive out-of-range integer to it's negativ # mysqld # SELECT COLUMN_GET(`x`, 'y' AS DECIMAL(5,50)); -ERROR 42000: Too big scale 50 specified for ''y''. Maximum is 38. +ERROR 42000: Too big scale 50 specified for ''y''. Maximum is 38 # # test of symbolic names # |