diff options
Diffstat (limited to 'mysql-test/t/dyncol.test')
| -rw-r--r-- | mysql-test/t/dyncol.test | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/mysql-test/t/dyncol.test b/mysql-test/t/dyncol.test index b7c3697beaf..eb6403feba3 100644 --- a/mysql-test/t/dyncol.test +++ b/mysql-test/t/dyncol.test @@ -86,6 +86,7 @@ select column_get(column_create(1, -1212 AS int), 1 as unsigned int); select column_get(column_create(1, 99999999999999999999999999999 AS decimal), 1 as unsigned int); select column_get(column_create(1, 999.9999999999999999 AS decimal), 1 as unsigned int); select column_get(column_create(1, -1 AS decimal), 1 as unsigned int); +--replace_result 1e+029 1e+29 select column_get(column_create(1, 99999999999999999999999999999 AS double), 1 as unsigned int); select column_get(column_create(1, 999.9 AS double), 1 as unsigned int); select column_get(column_create(1, -1 AS double), 1 as unsigned int); @@ -115,6 +116,7 @@ select column_get(column_create(1, 99999999999999999999999999999 AS decimal), 1 select column_get(column_create(1, -99999999999999999999999999999 AS decimal), 1 as int); select column_get(column_create(1, 999.9999999999999999 AS decimal), 1 as int); select column_get(column_create(1, 999.9 AS double), 1 as int); +--replace_result 1e+029 1e+29 select column_get(column_create(1, -99999999999999999999999999999 AS double), 1 as int); select column_get(column_create(1, "-1212III" AS char), 1 as int); select column_get(column_create(1, "1212III" AS char), 1 as int); @@ -161,7 +163,8 @@ select column_get(column_create(1, -99999999999999999999999999999 AS decimal), 1 select column_get(column_create(1, "2011-04-05" AS date), 1 as double); select column_get(column_create(1, "8:46:06.23434" AS time), 1 as double); select column_get(column_create(1, "2011-04-05 8:46:06.23434" AS datetime), 1 as double); -select column_get(column_create(1, "2011-04-05 8:46:06.23434" AS datetime), 1 as double(20,6)); +# The replace result is needed for windows. +select round(column_get(column_create(1, "2011-04-05 8:46:06.23434" AS datetime), 1 as double(20,6)),3); select column_get(column_create(1, NULL AS double), 1 as double); -- echo # column get real truncation & warnings @@ -241,6 +244,7 @@ select column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as d select column_get(column_create(1, 9223372036854775807 AS int), 1 as datetime); select column_get(column_create(1, -9223372036854775808 AS int), 1 as datetime); select column_get(column_create(1, 99999999999999999999999999999 AS decimal(32,10)), 1 as datetime); +--replace_result 1e+028 1e+28 select column_get(column_create(1, 99999999999999999999999999999 AS double), 1 as datetime); select column_get(column_create(1, "2011-02-32 8:46:06.23434" AS CHAR), 1 as datetime); select column_get(column_create(1, "2011-13-01 8:46:06.23434" AS CHAR), 1 as datetime); @@ -286,6 +290,7 @@ select column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as d select column_get(column_create(1, 9223372036854775807 AS int), 1 as date); select column_get(column_create(1, -9223372036854775808 AS int), 1 as date); select column_get(column_create(1, 99999999999999999999999999999 AS decimal(32,10)), 1 as date); +--replace_result 1e+028 1e+28 select column_get(column_create(1, 99999999999999999999999999999 AS double), 1 as date); select column_get(column_create(1, "2011-02-32 8:46:06.23434" AS CHAR), 1 as date); select column_get(column_create(1, "2011-13-01 8:46:06.23434" AS CHAR), 1 as date); @@ -330,6 +335,7 @@ select column_get(column_create(1, 18446744073709551615 AS unsigned int), 1 as t select column_get(column_create(1, 9223372036854775807 AS int), 1 as time); select column_get(column_create(1, -9223372036854775808 AS int), 1 as time); select column_get(column_create(1, 99999999999999999999999999999 AS decimal(32,10)), 1 as time); +--replace_result 1e+028 1e+28 select column_get(column_create(1, 99999999999999999999999999999 AS double), 1 as time); select column_get(column_create(1, "2011-02-32 8:46:06.23434" AS CHAR), 1 as time); select column_get(column_create(1, "2011-13-01 8:46:06.23434" AS CHAR), 1 as time); |