Bug #9390 Arithmetic results differ in 'type_newdecimal' (truncation?)
Submitted: 24 Mar 2005 19:07 Modified: 7 May 2005 9:02
Reporter: Joerg Bruehe Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.3 OS:Solaris (Solaris 10 + Mac OS X 10.2)
Assigned to: Alexey Botchkov CPU Architecture:Any

[24 Mar 2005 19:07] Joerg Bruehe
Description:
Final release build based on ChangeSet
  1.1847.1.1 05/03/22 21:52:01 jimw@mysql.com +11 -0
  Hack to ensure that CHAR's created in 5.0 are not converted to VARCHAR even if
  the row type is dynamic (For 4.1 tables old 'VARCHAR' fields are converted to
  true VARCHAR in the next ALTER TABLE)

  This ensures that one can use MySQL 5.0 privilege tables with MySQL 4.1.

  (Fix imported from main 5.0 tree to 5.0.3 build tree.)

Two different failures occurred at the same point in the test stream - I do not know whether they are related, but combine in one report in case they are.

Symptom on 'butch' (Solaris 10), "debug" build, "default" test run (PS-protocol passes!):
-------------------------------------------------------
*** r/type_newdecimal.result    Tue Mar 22 22:46:47 2005
--- r/type_newdecimal.reject    Wed Mar 23 06:23:07 2005
***************
*** 185,191 ****
  update t1 set b=a;
  SELECT * FROM t1;
  a     b
! 1.1   1.100
  2.1   2.100
  DROP TABLE t1;
  set session sql_mode='traditional';
--- 185,191 ----
  update t1 set b=a;
  SELECT * FROM t1;
  a     b
! 1.1   1.140
  2.1   2.100
  DROP TABLE t1;
  set session sql_mode='traditional';
-------------------------------------------------------

Symptom on 'powermacg4' (Mac OS X 10.2), "max" build, with '--ps-protocol' (default passes!):
-------------------------------------------------------
*** r/type_newdecimal.result    Tue Mar 22 22:46:47 2005
--- r/type_newdecimal.reject    Wed Mar 23 19:58:52 2005
***************
*** 185,191 ****
  update t1 set b=a;
  SELECT * FROM t1;
  a     b
! 1.1   1.100
  2.1   2.100
  DROP TABLE t1;
  set session sql_mode='traditional';
--- 185,191 ----
  update t1 set b=a;
  SELECT * FROM t1;
  a     b
! 1.1   1.180
  2.1   2.100
  DROP TABLE t1;
  set session sql_mode='traditional';
-------------------------------------------------------

How to repeat:
Build + run standard tests.
[7 May 2005 9:02] Alexey Botchkov
tried 5.0.5 on powermacg4 - ./mysql-test-run --ps-protocol t/type_newdecimal.test passed.
Maybe that issue was closed with previous patches