Bug #11163 Formatting error of "result" file

• Submitted: 8 Jun 2005 10:15
• Modified: 10 Jun 2005 13:22
• Reporter: Joerg Bruehe
• Status: Closed
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.0.7-pre
• OS: Unix (all)
• Assigned to: Konstantin Osipov
• CPU Architecture: Any

[8 Jun 2005 10:15] Joerg Bruehe

Description:
Build of 5.0.7, based on ChangeSet
  1.1940.1.1 05/06/07 08:23:46 [e-mail] +3 -0
  Merge rurik.mysql.com:/home/igor/dev/mysql-4.1-0
  into rurik.mysql.com:/home/igor/dev/mysql-5.0-0

Test "ps_7ndb" fails on all platforms where it is taken with these differences:
-------------------------------------------------------
*** r/ps_7ndb.result    Tue Jun  7 20:31:20 2005
--- r/ps_7ndb.reject    Wed Jun  8 03:02:53 2005
***************
*** 1,4 ****
! use test; drop table if exists t1, t9 ; create table t1
  (
  a int, b varchar(30),
  primary key(a)
--- 1,6 ----
! use test;
! drop table if exists t1, t9 ;
! create table t1
  (
  a int, b varchar(30),
  primary key(a)
***************
*** 442,450 ****
  execute stmt1 ;
  a     b
  1     one
! prepare stmt1 from ' select a,b from t1
! limit ? ';
! ERROR 42000: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the
right syntax to use near '?' at line 2
  set @arg00='b' ;
  set @arg01=0 ;
  set @arg02=2 ;
--- 444,453 ----
  execute stmt1 ;
  a     b
  1     one
! prepare stmt1 from ' select a,b from t1 limit ? ';
! execute stmt1 using @arg00;
! a     b
! 3     three
  set @arg00='b' ;
  set @arg01=0 ;
  set @arg02=2 ;
***************

and then continues with ones like bug#11162.

How to repeat:
Run the test suite.

[10 Jun 2005 13:22] Konstantin Osipov

Fixed in the main and build trees by fixing the teset suite.
Subject: bk commit - 5.0 tree (kent:1.1945)

ChangeSet
  1.1945 05/06/08 17:45:18 [e-mail] +2 -0
  ps_7ndb.result, ps_6bdb.result:
    Updated result files     
Subject: bk commit - 5.0 tree (konstantin:1.1947) BUG#9899

ChangeSet
  1.1947 05/06/08 10:59:40 [e-mail] +2 -0
  Fix failing ps_6bdb and ps_7ndb tests.
  The changes are similar to those pushed with a fix for Bug#9899,
  so my guess is that ps_6dbd and ps_7ndb tests were simply not run then.

Subject: bk commit - 4.1 tree (konstantin:1.2284)

ChangeSet
  1.2284 05/06/09 18:00:50 [e-mail] +1 -0
  Fix broken test suite.