Bug #19037 test "cast" failing on Windows
Submitted: 12 Apr 2006 8:43 Modified: 12 Apr 2006 10:05
Reporter: Alexander Barkov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0, 5.1 OS:
Assigned to: Alexander Barkov CPU Architecture:Any

[12 Apr 2006 8:43] Alexander Barkov
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.
[12 Apr 2006 10:05] Alexander Barkov
Opps, this problem has already been fixed by knielsen.
Thanks!

Closing the report.