Description:
cast [ fail ]
Errors are (from C:/cygwin/home/mysqldev/pb/mysql-5.1-new/push-bar@mysql.com-20060331182705.info/mysql-5.1.9-beta-standard/mysql-test/var-n_stm-5/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/cast.result 2006-03-31 18:30:50 +03:00
--- r/cast.reject 2006-03-31 19:12:07 +03:00
***************
*** 345,352 ****
-1e+30 -9223372036854775808
1e+30 9223372036854775807
Warnings:
! Warning 1292 Truncated incorrect INTEGER value: '-1e+30'
! Warning 1292 Truncated incorrect INTEGER value: '1e+30'
DROP TABLE t1;
select cast('1.2' as decimal(3,2));
cast('1.2' as decimal(3,2))
--- 345,352 ----
-1e+30 -9223372036854775808
1e+30 9223372036854775807
Warnings:
! Warning 1292 Truncated incorrect INTEGER value: '-1e+030'
! Warning 1292 Truncated incorrect INTEGER value: '1e+030'
DROP TABLE t1;
select cast('1.2' as decimal(3,2));
cast('1.2' as decimal(3,2))
-------------------------------------------------------
How to repeat:
Run the above test.