Bug #8047 'mysql_client_test' fails in 'test_view_insert' (line 110xx)
Submitted: 20 Jan 2005 15:28 Modified: 17 Mar 2005 23:13
Reporter: Joerg Bruehe Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.3-pre OS:Various Unix (64 bit)
Assigned to: Jim Winstead CPU Architecture:Any

[20 Jan 2005 15:28] Joerg Bruehe
Description:
The recent test build of 5.0.3 (based on this changeset:
  1.1822 05/01/19 23:11:50 sergefp@mysql.com +3 -0
  Merge mysql.com:/dbdata/psergey/mysql-4.1-bug7885
  into mysql.com:/dbdata/psergey/mysql-5.0-bug7885
) failed in test 'client_test' (run in default mode) with this message:

client_test.c:11020: check failed: 'rc == 0'

This is in function 'test_view_insert', here a code excerpt:
  11015   for (i= 0; i < 3; i++)
  11016   {
  11017     my_val= i;
  11018
  11019     rc= mysql_stmt_execute(insert_stmt);
  11020     check_execute(insert_stmt, rc);
  11021
  11022     rc= mysql_stmt_execute(select_stmt);
  11023     check_execute(select_stmt, rc);
  11024     assert(i + 1 == (int) my_process_stmt_result(select_stmt));
  11025   }

The failure occurs on aix52-64bit, butch-64bit, hpita2-64bit, octane2-64bit, sunfire100b-64bit, and sunfire100c-64bit.
On the sunfires and on butch, it passes in the 32 bit version; hpita2 and octane2 have no 32 bit version, and on aix52 that failed to compile.

How to repeat:
Happened during release build + test.
[24 Jan 2005 0:26] Konstantin Osipov
Joerg,
is it a duplicate of Bug#7514?
At least when I tried to verify Bug#7514 tonight  I got a failure at the same line as above.
[21 Feb 2005 17:35] Joerg Bruehe
Changed title due to the changed test name:  'client_test' -> 'mysql_client_test'.

Error still occurs, line numbers slightly varying:  11021 or 11018.

Current changeset:
  1.1862 05/02/18 17:46:30 pem@mysql.com +1 -0
  Merge mysql.com:/usr/local/bk/mysql-5.0
  into mysql.com:/home/pem/work/mysql-5.0
[22 Feb 2005 16:09] Joerg Bruehe
It seems that due to the aborting test, some cleanup action is not performed. As a consequence, later tests encounter a database 'client_test_db' which they should not, and so the test protocol differs, causing the test to 'fail'.

This affects the tests 'ps_1general', 'rpl000009', 'rpl_create_database', 'schema', 'show_check'.
[17 Mar 2005 0:29] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/23121
[17 Mar 2005 23:13] Jim Winstead
Fix pushed into the 5.0.3 build tree.