diff options
author | Michael Widenius <monty@askmonty.org> | 2011-05-08 14:46:32 +0300 |
---|---|---|
committer | Michael Widenius <monty@askmonty.org> | 2011-05-08 14:46:32 +0300 |
commit | 03483e7bfd21a61fca796a163376b77cd965870e (patch) | |
tree | c51c1f3dd04f3a21815820feb08f6cd6778b7271 /mysql-test/r/dyncol.result | |
parent | 5ab92b1f850c62718907d166b47553440502043c (diff) | |
parent | e843297d128b165125d17aab8958f7ca91808923 (diff) | |
download | mariadb-git-03483e7bfd21a61fca796a163376b77cd965870e.tar.gz |
Merge with main 5.3
Diffstat (limited to 'mysql-test/r/dyncol.result')
-rw-r--r-- | mysql-test/r/dyncol.result | 44 |
1 files changed, 22 insertions, 22 deletions
diff --git a/mysql-test/r/dyncol.result b/mysql-test/r/dyncol.result index f58340841c2..b6584a6fe55 100644 --- a/mysql-test/r/dyncol.result +++ b/mysql-test/r/dyncol.result @@ -41,7 +41,7 @@ select hex(COLUMN_CREATE(1, 99999999999999999999999999999 AS unsigned int)); hex(COLUMN_CREATE(1, 99999999999999999999999999999 AS unsigned int)) 000100010001FFFFFFFFFFFFFF7F Warnings: -Error 1655 Got overflow when converting '99999999999999999999999999999' to INT. Value truncated. +Error 1657 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 @@ -67,7 +67,7 @@ select hex(COLUMN_CREATE(1, 99999999999999999999999999999 AS int)); hex(COLUMN_CREATE(1, 99999999999999999999999999999 AS int)) 000100010000FEFFFFFFFFFFFFFF Warnings: -Error 1655 Got overflow when converting '99999999999999999999999999999' to INT. Value truncated. +Error 1657 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 @@ -211,7 +211,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: -Error 1655 Got overflow when converting '99999999999999999999999999999' to UNSIGNED INT. Value truncated. +Error 1657 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 @@ -219,12 +219,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: -Error 1655 Got overflow when converting '-1' to UNSIGNED INT. Value truncated. +Error 1657 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 1655 Got overflow when converting '1e+29' to UNSIGNED INT. Value truncated. +Warning 1657 Got overflow when converting '1e+29' 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 @@ -232,12 +232,12 @@ 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 1655 Got overflow when converting '-1' to UNSIGNED INT. Value truncated. +Warning 1657 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 Warnings: -Warning 1657 Encountered illegal value '1212III' when converting to UNSIGNED INT +Warning 1659 Encountered illegal value '1212III' when converting to UNSIGNED INT # # column get int # @@ -296,12 +296,12 @@ select column_get(column_create(1, 99999999999999999999999999999 AS decimal), 1 column_get(column_create(1, 99999999999999999999999999999 AS decimal), 1 as int) 9223372036854775807 Warnings: -Error 1655 Got overflow when converting '99999999999999999999999999999' to INT. Value truncated. +Error 1657 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: -Error 1655 Got overflow when converting '-99999999999999999999999999999' to INT. Value truncated. +Error 1657 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 @@ -312,17 +312,17 @@ select column_get(column_create(1, -99999999999999999999999999999 AS double), 1 column_get(column_create(1, -99999999999999999999999999999 AS double), 1 as int) -9223372036854775808 Warnings: -Warning 1655 Got overflow when converting '-1e+29' to INT. Value truncated. +Warning 1657 Got overflow when converting '-1e+29' 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 Warnings: -Warning 1657 Encountered illegal value '-1212III' when converting to INT +Warning 1659 Encountered illegal value '-1212III' when converting to INT select column_get(column_create(1, "1212III" AS char), 1 as int); column_get(column_create(1, "1212III" AS char), 1 as int) 1212 Warnings: -Warning 1657 Encountered illegal value '1212III' when converting to INT +Warning 1659 Encountered illegal value '1212III' when converting to INT # #column get char # @@ -433,12 +433,12 @@ select column_get(column_create(1, "1223.5aa" AS char), 1 as double); column_get(column_create(1, "1223.5aa" AS char), 1 as double) 1223.5 Warnings: -Warning 1657 Encountered illegal value '1223.5aa' when converting to DOUBLE +Warning 1659 Encountered illegal value '1223.5aa' when converting to DOUBLE select column_get(column_create(1, "aa" AS char), 1 as double); column_get(column_create(1, "aa" AS char), 1 as double) 0 Warnings: -Warning 1657 Encountered illegal value 'aa' when converting to DOUBLE +Warning 1659 Encountered illegal value 'aa' when converting to DOUBLE select column_get(column_create(1, "1223.5555" AS double), 1 as double(5,2)); column_get(column_create(1, "1223.5555" AS double), 1 as double(5,2)) 999.99 @@ -502,12 +502,12 @@ select column_get(column_create(1, "1223.5aa" AS char), 1 as decimal(32,10)); column_get(column_create(1, "1223.5aa" AS char), 1 as decimal(32,10)) 1223.5000000000 Warnings: -Warning 1657 Encountered illegal value '1223.5aa' when converting to DECIMAL +Warning 1659 Encountered illegal value '1223.5aa' when converting to DECIMAL select column_get(column_create(1, "aa" AS char), 1 as decimal(32,10)); column_get(column_create(1, "aa" AS char), 1 as decimal(32,10)) 0.0000000000 Warnings: -Warning 1657 Encountered illegal value 'aa' when converting to DECIMAL +Warning 1659 Encountered illegal value 'aa' when converting to DECIMAL select column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as decimal); column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as decimal) 9999999999 @@ -640,17 +640,17 @@ select column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as d column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as datetime) NULL Warnings: -Warning 1657 Encountered illegal value '18446744073709551615' when converting to DATE or DATETIME +Warning 1659 Encountered illegal value '18446744073709551615' when converting to DATE or DATETIME select column_get(column_create(1, 9223372036854775807 AS int), 1 as datetime); column_get(column_create(1, 9223372036854775807 AS int), 1 as datetime) NULL Warnings: -Warning 1657 Encountered illegal value '9223372036854775807' when converting to DATE or DATETIME +Warning 1659 Encountered illegal value '9223372036854775807' when converting to DATE or DATETIME select column_get(column_create(1, -9223372036854775808 AS int), 1 as datetime); column_get(column_create(1, -9223372036854775808 AS int), 1 as datetime) NULL Warnings: -Warning 1657 Encountered illegal value '-9223372036854775808' when converting to DATE or DATETIME +Warning 1659 Encountered illegal value '-9223372036854775808' when converting to DATE or DATETIME select column_get(column_create(1, 99999999999999999999999999999 AS decimal(32,10)), 1 as datetime); column_get(column_create(1, 99999999999999999999999999999 AS decimal(32,10)), 1 as datetime) NULL @@ -770,17 +770,17 @@ select column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as d column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as date) NULL Warnings: -Warning 1657 Encountered illegal value '18446744073709551615' when converting to DATE or DATETIME +Warning 1659 Encountered illegal value '18446744073709551615' when converting to DATE or DATETIME select column_get(column_create(1, 9223372036854775807 AS int), 1 as date); column_get(column_create(1, 9223372036854775807 AS int), 1 as date) NULL Warnings: -Warning 1657 Encountered illegal value '9223372036854775807' when converting to DATE or DATETIME +Warning 1659 Encountered illegal value '9223372036854775807' when converting to DATE or DATETIME select column_get(column_create(1, -9223372036854775808 AS int), 1 as date); column_get(column_create(1, -9223372036854775808 AS int), 1 as date) NULL Warnings: -Warning 1657 Encountered illegal value '-9223372036854775808' when converting to DATE or DATETIME +Warning 1659 Encountered illegal value '-9223372036854775808' when converting to DATE or DATETIME select column_get(column_create(1, 99999999999999999999999999999 AS decimal(32,10)), 1 as date); column_get(column_create(1, 99999999999999999999999999999 AS decimal(32,10)), 1 as date) NULL |