MySQL Bugs: #9914: Insert / fetch does change "double" value 6578.001

Bug #9914	Insert / fetch does change "double" value 6578.001
Submitted:	14 Apr 2005 19:00	Modified:	14 Jul 2005 13:38
Reporter:	Joerg Bruehe
Status:	Duplicate
Category:	Server	Severity:	S2 (Serious)
Version:	5.0.4 + 4.1.12	OS:	Sun Solaris (Solaris 8 / x86)
Assigned to:	Alexey Botchkov	Target Version:

Description:
Release build of 5.0.4, based on ChangeSet
  1.1893 05/04/13 13:17:39 mskold@mysql.com +1 -0
  Fixed failed merge

This is the first working build on this platform, AFAIK. We previously used
"gcc" and had a failing lib dependency, now we use Sun Studio compilers.

=== quote start ===
mysql_client_test              [ fail ]

Errors are (from
/export/home/mysqldev/intelxeon3/test/mysql-standard-5.0.4-beta-pc-solaris2.8-i386/mysql-test/var/log/mysqltest-time)
:
mysql_client_test.c:1632: check failed: 'double_data == o_double_data'
Abort - core dumped
/export/home/mysqldev/intelxeon3/test/mysql-standard-5.0.4-beta-pc-solaris2.8-i386/bin/mysqltest:
command "$MYSQL_CLIENT_TEST" failed
(the last lines may be the most important ones)

Ending Tests
=== quote end ===

This happens in
   static void test_prepare()

"serious", as it does change a data value.  "low", as this is a new platform.

How to repeat:
Build + test.

Same error in build of 4.1.12, based on ChangeSet
  1.2261 05/05/10 14:44:03 lenz@mysql.com +2 -0
  Applied two patches already commited to the main tree to resolve bugs found during the
build:
   - removed an "#error PRAGMA" from sql/item_strfunc.h (msvensson)
   - Fixed BUG#10070 (range test failed if InnoDB is not available) (sergefp)

This bug is very likely a duplicate of BUG#10443, which Ramil is investigating now.

Correction: This is not a duplicate of BUG#10443, but rather BUG#11808