Bug #6988 "ps_1general" fails on QNX
Submitted: 3 Dec 2004 13:48 Modified: 3 Dec 2004 16:34
Reporter: Lenz Grimmer Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.1.8-pre OS:Other (QNX 6.2.1 x86)
Assigned to: Sergei Golubchik CPU Architecture:Any

[3 Dec 2004 13:48] Lenz Grimmer
Description:
Running the test suite on QNX currently reveals the following diff:

-------------------------------------------------------
*** r/ps_1general.result        Fri Dec  3 00:16:09 2004
--- r/ps_1general.reject        Fri Dec  3 07:10:23 2004
***************
*** 273,283 ****
  prepare stmt4 from ' show table status from test like ''t2%'' ';
  execute stmt4;
  Name  Engine  Version Row_format      Rows    Avg_row_length  Data_length     Max_data_length Index_length        Data_free       Auto_increment  Create_time     Update_time     Check_time      Collation   Checksum        Create_options  Comment
! t2    MyISAM  9       Fixed   0       0       0       64424509439     1024    0       NULL    #
        #       #       latin1_swedish_ci       NULL
  prepare stmt4 from ' show table status from test like ''t9%'' ';
  execute stmt4;
  Name  Engine  Version Row_format      Rows    Avg_row_length  Data_length     Max_data_length Index_length        Data_free       Auto_increment  Create_time     Update_time     Check_time      Collation   Checksum        Create_options  Comment
! t9    MyISAM  9       Dynamic 2       220     440     4294967295      2048    0       NULL    #
        #       #       latin1_swedish_ci       NULL
  prepare stmt4 from ' show status like ''Threads_running'' ';
  execute stmt4;
  Variable_name Value
--- 273,283 ----
  prepare stmt4 from ' show table status from test like ''t2%'' ';
  execute stmt4;
  Name  Engine  Version Row_format      Rows    Avg_row_length  Data_length     Max_data_length Index_length        Data_free       Auto_increment  Create_time     Update_time     Check_time      Collation   Checksum        Create_options  Comment
! t2    MyISAM  9       Fixed   0       0       0       2147483647      1024    0       NULL    #
        #       #       latin1_swedish_ci       NULL
  prepare stmt4 from ' show table status from test like ''t9%'' ';
  execute stmt4;
  Name  Engine  Version Row_format      Rows    Avg_row_length  Data_length     Max_data_length Index_length        Data_free       Auto_increment  Create_time     Update_time     Check_time      Collation   Checksum        Create_options  Comment
! t9    MyISAM  9       Dynamic 2       220     440     2147483647      2048    0       NULL    #
        #       #       latin1_swedish_ci       NULL
  prepare stmt4 from ' show status like ''Threads_running'' ';
  execute stmt4;
  Variable_name Value
-------------------------------------------------------

How to repeat:
Run the ps_1general test on QNX and observe the diff.