diff options
Diffstat (limited to 'mysql-test/r/dyncol.result')
| -rw-r--r-- | mysql-test/r/dyncol.result | 64 |
1 files changed, 32 insertions, 32 deletions
diff --git a/mysql-test/r/dyncol.result b/mysql-test/r/dyncol.result index d38660adcc6..f4a858c3029 100644 --- a/mysql-test/r/dyncol.result +++ b/mysql-test/r/dyncol.result @@ -9,13 +9,13 @@ hex(COLUMN_CREATE(1, "afaf" AS char character set utf8)) 0001000100030861666166 select hex(COLUMN_CREATE(1, 1212 AS char character set utf8)); hex(COLUMN_CREATE(1, 1212 AS char character set utf8)) -0001000100033F31323132 +0001000100030831323132 select hex(COLUMN_CREATE(1, 12.12 AS char character set utf8)); hex(COLUMN_CREATE(1, 12.12 AS char character set utf8)) -0001000100033F31322E3132 +0001000100030831322E3132 select hex(COLUMN_CREATE(1, 99999999999999999999999999999 AS char character set utf8)); hex(COLUMN_CREATE(1, 99999999999999999999999999999 AS char character set utf8)) -0001000100033F3939393939393939393939393939393939393939393939393939393939 +000100010003083939393939393939393939393939393939393939393939393939393939 select hex(COLUMN_CREATE(1, NULL AS unsigned int)); hex(COLUMN_CREATE(1, NULL AS unsigned int)) 000000 @@ -47,7 +47,7 @@ select hex(COLUMN_CREATE(1, 99999999999999999999999999999 AS unsigned int)); hex(COLUMN_CREATE(1, 99999999999999999999999999999 AS unsigned int)) 000100010001FFFFFFFFFFFFFF7F Warnings: -Error 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: -Error 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: -Error 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,7 +231,7 @@ 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 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 @@ -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: -Error 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: -Error 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 @@ -449,19 +449,19 @@ Warnings: Note 1003 select cast(column_get(column_create(1,1212.12 AS double),1) as double(6,2)) AS `column_get(column_create(1, 1212.12 AS double), 1 as double(6,2))` select column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as double); column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as double) -1.84467440737096e+19 +1.8446744073709552e19 select column_get(column_create(1, 9223372036854775807 AS int), 1 as double); column_get(column_create(1, 9223372036854775807 AS int), 1 as double) -9.22337203685478e+18 +9.223372036854776e18 select column_get(column_create(1, -9223372036854775808 AS int), 1 as double); column_get(column_create(1, -9223372036854775808 AS int), 1 as double) --9.22337203685478e+18 +-9.223372036854776e18 select column_get(column_create(1, 99999999999999999999999999999 AS decimal), 1 as double); column_get(column_create(1, 99999999999999999999999999999 AS decimal), 1 as double) -1e+29 +1e29 select column_get(column_create(1, -99999999999999999999999999999 AS decimal), 1 as double); column_get(column_create(1, -99999999999999999999999999999 AS decimal), 1 as double) --1e+29 +-1e29 select column_get(column_create(1, "2011-04-05" AS date), 1 as double); column_get(column_create(1, "2011-04-05" AS date), 1 as double) 20110405 @@ -476,10 +476,10 @@ column_get(column_create(1, "-808:46:06.23434" AS time(6)), 1 as double) -8084606.23434 select column_get(column_create(1, "2011-04-05 8:46:06.23434" AS datetime), 1 as double); column_get(column_create(1, "2011-04-05 8:46:06.23434" AS datetime), 1 as double) -20110405084606.2 +20110405084606.234 select column_get(column_create(1, "2011-04-05 8:46:06.23434" AS datetime(6)), 1 as double); column_get(column_create(1, "2011-04-05 8:46:06.23434" AS datetime(6)), 1 as double) -20110405084606.2 +20110405084606.234 select round(column_get(column_create(1, "2011-04-05 8:46:06.23434" AS datetime), 1 as double(20,6)),3); round(column_get(column_create(1, "2011-04-05 8:46:06.23434" AS datetime), 1 as double(20,6)),3) 20110405084606.234 @@ -584,47 +584,47 @@ select column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as d column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as decimal) 9999999999 Warnings: -Error 1264 Out of range value for column 'column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as decimal)' at row 1 +Warning 1264 Out of range value for column 'column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as decimal)' at row 1 select column_get(column_create(1, 9223372036854775807 AS int), 1 as decimal); column_get(column_create(1, 9223372036854775807 AS int), 1 as decimal) 9999999999 Warnings: -Error 1264 Out of range value for column 'column_get(column_create(1, 9223372036854775807 AS int), 1 as decimal)' at row 1 +Warning 1264 Out of range value for column 'column_get(column_create(1, 9223372036854775807 AS int), 1 as decimal)' at row 1 select column_get(column_create(1, -9223372036854775808 AS int), 1 as decimal); column_get(column_create(1, -9223372036854775808 AS int), 1 as decimal) -9999999999 Warnings: -Error 1264 Out of range value for column 'column_get(column_create(1, -9223372036854775808 AS int), 1 as decimal)' at row 1 +Warning 1264 Out of range value for column 'column_get(column_create(1, -9223372036854775808 AS int), 1 as decimal)' at row 1 select column_get(column_create(1, 99999999999999999999999999999 AS decimal(32,10)), 1 as decimal); column_get(column_create(1, 99999999999999999999999999999 AS decimal(32,10)), 1 as decimal) 9999999999 Warnings: -Error 1264 Out of range value for column 'column_get(column_create(1, 99999999999999999999999999999 AS decimal(32,10)), 1 as decimal)' at row 1 +Warning 1264 Out of range value for column 'column_get(column_create(1, 99999999999999999999999999999 AS decimal(32,10)), 1 as decimal)' at row 1 select column_get(column_create(1, "2011-04-05 8:46:06.23434" AS datetime), 1 as decimal); column_get(column_create(1, "2011-04-05 8:46:06.23434" AS datetime), 1 as decimal) 9999999999 Warnings: -Error 1264 Out of range value for column 'column_get(column_create(1, "2011-04-05 8:46:06.23434" AS datetime), 1 as decimal)' at row 1 +Warning 1264 Out of range value for column 'column_get(column_create(1, "2011-04-05 8:46:06.23434" AS datetime), 1 as decimal)' at row 1 select column_get(column_create(1, "1223.5555" as double), 1 as decimal(5,2)); column_get(column_create(1, "1223.5555" as double), 1 as decimal(5,2)) 999.99 Warnings: -Error 1264 Out of range value for column 'column_get(column_create(1, "1223.5555" as double), 1 as decimal(5,2))' at row 1 +Warning 1264 Out of range value for column 'column_get(column_create(1, "1223.5555" as double), 1 as decimal(5,2))' at row 1 select column_get(column_create(1, "-1223.5555" as double), 1 as decimal(5,2)); column_get(column_create(1, "-1223.5555" as double), 1 as decimal(5,2)) -999.99 Warnings: -Error 1264 Out of range value for column 'column_get(column_create(1, "-1223.5555" as double), 1 as decimal(5,2))' at row 1 +Warning 1264 Out of range value for column 'column_get(column_create(1, "-1223.5555" as double), 1 as decimal(5,2))' at row 1 select column_get(column_create(1, "1223.5555" AS double), 1 as decimal(3,2)); column_get(column_create(1, "1223.5555" AS double), 1 as decimal(3,2)) 9.99 Warnings: -Error 1264 Out of range value for column 'column_get(column_create(1, "1223.5555" AS double), 1 as decimal(3,2))' at row 1 +Warning 1264 Out of range value for column 'column_get(column_create(1, "1223.5555" AS double), 1 as decimal(3,2))' at row 1 select column_get(column_create(1, "1223.5555" AS decimal(10,5)), 1 as decimal(3,2)); column_get(column_create(1, "1223.5555" AS decimal(10,5)), 1 as decimal(3,2)) 9.99 Warnings: -Error 1264 Out of range value for column 'column_get(column_create(1, "1223.5555" AS decimal(10,5)), 1 as decimal(3,2))' at row 1 +Warning 1264 Out of range value for column 'column_get(column_create(1, "1223.5555" AS decimal(10,5)), 1 as decimal(3,2))' at row 1 select column_get(column_create(1, 0.0 AS decimal,2, 0.0 as decimal), 1 as decimal); column_get(column_create(1, 0.0 AS decimal,2, 0.0 as decimal), 1 as decimal) 0 @@ -726,7 +726,7 @@ 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 1292 Incorrect datetime value: '1.84467440737096e+19' +Warning 1292 Incorrect datetime value: '1.8446744073709552e19' select column_get(column_create(1, 9223372036854775807 AS int), 1 as datetime); column_get(column_create(1, 9223372036854775807 AS int), 1 as datetime) NULL @@ -746,7 +746,7 @@ select column_get(column_create(1, 99999999999999999999999999999 AS double), 1 a column_get(column_create(1, 99999999999999999999999999999 AS double), 1 as datetime) NULL Warnings: -Warning 1292 Incorrect datetime value: '1e+29' +Warning 1292 Incorrect datetime value: '1e29' select column_get(column_create(1, "2011-02-32 8:46:06.23434" AS CHAR), 1 as datetime); column_get(column_create(1, "2011-02-32 8:46:06.23434" AS CHAR), 1 as datetime) NULL @@ -856,7 +856,7 @@ 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 1292 Incorrect datetime value: '1.84467440737096e+19' +Warning 1292 Incorrect datetime value: '1.8446744073709552e19' select column_get(column_create(1, 9223372036854775807 AS int), 1 as date); column_get(column_create(1, 9223372036854775807 AS int), 1 as date) NULL @@ -876,7 +876,7 @@ select column_get(column_create(1, 99999999999999999999999999999 AS double), 1 a column_get(column_create(1, 99999999999999999999999999999 AS double), 1 as date) NULL Warnings: -Warning 1292 Incorrect datetime value: '1e+29' +Warning 1292 Incorrect datetime value: '1e29' select column_get(column_create(1, "2011-02-32 8:46:06.23434" AS CHAR), 1 as date); column_get(column_create(1, "2011-02-32 8:46:06.23434" AS CHAR), 1 as date) NULL @@ -1003,7 +1003,7 @@ select column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as t column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as time) NULL Warnings: -Warning 1292 Incorrect datetime value: '1.84467440737096e+19' +Warning 1292 Incorrect datetime value: '1.8446744073709552e19' select column_get(column_create(1, 9223372036854775807 AS int), 1 as time); column_get(column_create(1, 9223372036854775807 AS int), 1 as time) NULL @@ -1023,7 +1023,7 @@ select column_get(column_create(1, 99999999999999999999999999999 AS double), 1 a column_get(column_create(1, 99999999999999999999999999999 AS double), 1 as time) NULL Warnings: -Warning 1292 Incorrect datetime value: '1e+29' +Warning 1292 Incorrect datetime value: '1e29' select column_get(column_create(1, "2011-02-32 8:46:06.23434" AS CHAR), 1 as time); column_get(column_create(1, "2011-02-32 8:46:06.23434" AS CHAR), 1 as time) NULL @@ -1253,7 +1253,7 @@ id hex(str) 2 00020001000002000B040861 3 0002000200030300100863C8 4 00030001000002000B0300180A0863C8 -5 00040001000002000B04001B0A00330C08633F34350874657374 +5 00040001000002000B04001B0A00330C08630834350874657374 6 0003000200030300100A001B0863C8087465737432 update t1 set str=column_add(str, 4, repeat("a", 100000)) where id=5; select id from t1 where column_get(str,4 as char(100000)) = repeat("a", 100000); |