Bug #17384 mysqldump test has order dependency in result file

• Submitted: 14 Feb 2006 15:35
• Modified: 15 Feb 2006 20:33
• Reporter: Tomas Ulin
• Status: Closed
• Category: MySQL Server: Replication
• Severity: S1 (Critical)
• Version: 5.1.7 src
• Assigned to: Brian Aker
• CPU Architecture: Any

[14 Feb 2006 15:35] Tomas Ulin

Description:
mysqldump                      [ fail ]

Errors are (from /export/home/mysqldev/pb/mysql-5.1-new/[e-mail]/mysql-5.1.7-beta-standard/mysql-test/var/log/mysqltest-time) :
mysqltest: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/mysqldump.result	Tue Feb 14 12:21:54 2006
--- r/mysqldump.reject	Tue Feb 14 14:00:58 2006
***************
*** 2666,2673 ****
  a more perfect	union
  test.t1: Records: 2  Deleted: 0  Skipped: 0  Warnings: 0
  test.t2: Records: 2  Deleted: 0  Skipped: 0  Warnings: 0
- test.t1: Records: 2  Deleted: 0  Skipped: 0  Warnings: 0
  test.t2: Records: 2  Deleted: 0  Skipped: 0  Warnings: 0
  select * from t1;
  a	b
  Duck, Duck	goose
--- 2666,2673 ----
  a more perfect	union
  test.t1: Records: 2  Deleted: 0  Skipped: 0  Warnings: 0
  test.t2: Records: 2  Deleted: 0  Skipped: 0  Warnings: 0
  test.t2: Records: 2  Deleted: 0  Skipped: 0  Warnings: 0
+ test.t1: Records: 2  Deleted: 0  Skipped: 0  Warnings: 0
  select * from t1;
  a	b
  Duck, Duck	goose
-------------------------------------------------------
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.

How to repeat:
see above

[14 Feb 2006 18:35] Brian Aker

Fixed by adding --silent flag and just testing results via SELECT.

[15 Feb 2006 20:33] Paul DuBois

No changelog entry needed.