Bug #7991 type_bit test fails on powerpc and sparc
Submitted: 18 Jan 2005 17:23 Modified: 19 Jan 2005 10:09
Reporter: Martin Skold Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.3 OS:IBM AIX (AIX and Solaris)
Assigned to: Ramil Kalimullin CPU Architecture:Any

[18 Jan 2005 17:23] Martin Skold
Description:
./mysql-test-run --do-test=type_bit
TEST                            RESULT
-------------------------------------------------------
type_bit                       [ fail ]
 
Errors are (from /export/home/mysqldev/tomas/mysqlcom-5.0.3-alpha/mysql-test/var/log/mysqltest-time) :
/export/home/mysqldev/tomas/mysqlcom-5.0.3-alpha/client/mysqltest: At line 109: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/type_bit.result   Thu Jan 13 21:08:43 2005
--- r/type_bit.reject   Tue Jan 18 20:19:33 2005
***************
*** 357,365 ****
  update t1 set b= concat(a);
  select a+0, b+0 from t1;
  a+0   b+0
! 1     1
! 3     3
! 2     2
  drop table t1;
  create table t1 (a bit(7), key(a));
  insert into t1 values (44), (57);
--- 357,365 ----
  update t1 set b= concat(a);
  select a+0, b+0 from t1;
  a+0   b+0
! 1     0
! 3     0
! 2     0
  drop table t1;
  create table t1 (a bit(7), key(a));
  insert into t1 values (44), (57);
-------------------------------------------------------
Please follow the instructions outlined at
http://www.mysql.com/doc/en/Reporting_mysqltest_bugs.html
to find the reason to this problem and how to report this.
 
 
Aborting: type_bit failed in default mode. To continue, re-run with '--force'.
 
Ending Tests
Shutting-down MySQL daemon

How to repeat:
./mysql-test-run --do-test=type_bit

Suggested fix:
Seems to be byte order related
[19 Jan 2005 10:09] Ramil Kalimullin
fixed in 5.0.3