MySQL Bugs: #12698: abnormal program termination running mysql_client

Bug #12698	abnormal program termination running mysql_client_test
Submitted:	21 Aug 2005 3:26	Modified:	20 Oct 2005 10:10
Reporter:	[ name withheld ]	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.1.13a, 5.0.15	OS:	Windows (XP Home, fedora)
Assigned to:	Magnus Blåudd	CPU Architecture:	Any

Description:
while running mysql_client_test i encounter dialogue box stating:
"Microsoft Visual C++ Debug Library"
"Debug Error ! "
"Program: C:\MySql\bin\mysql_client_test.exe"
"abnormal program termination"
"(Press Retry to debug the application)"
"[Abort] [Retry] [Ignore]"

the dialogue box appears at "77 of (1/1): test_frm_bug"

the final info appearing on my cmd at the time of the program termination is:
"[MySQL-4.1.13a-nt][1051] Unknown table 'test_frm_bug' 
e:mysqldev\build\mysql-4.1.13a-build\mysql-4.1.13a\testsmysql_client_test.c:6923: check failed: 'r == 0' "

How to repeat:
run mysql_client_test

Also appears on Fedora Core 4. when compiled with BUILD/compile-pentium-max
See below:
#####################################
10 of (1/1): test_fetch_str
#####################################

 total parameters in stmt: `7` (expected: `7`)

 SELECT * FROM test_bind_fetch

        +--------+---------+---------+---------+---------+---------+---------+
        | c1     | c2      | c3      | c4      | c5      | c6      | c7      |
        +--------+---------+---------+---------+---------+---------+---------+
        | 196864 | 196611  | 196611  | 196611  | 12      | 25      | 38      |
        | 720896 | 1572864 | 2424832 | 3276800 | 4128768 | 4980736 | 5832704 |
        | 655360 | 1507328 | 2359296 | 3211264 | 4063232 | 4915200 | 5767168 |
        +--------+---------+---------+---------+---------+---------+---------+

        3 rows returned
mysql_client_test.c:3851: check failed: 'rc == 0'
Avbruten (SIGABRT)

Hmm, maybe not exactly the same bug after all, original problem appears on a different line. :)

mysql_client_test terminated because mysql_stmt_fetch unexpectedly returns  MYSQL_DATA_TRUNCATED.

Expected output from test_fetch_str testcase in mysql_client_test
#####################################
1 of (1/1): test_fetch_str
#####################################

 total parameters in stmt: `7` (expected: `7`)

 SELECT * FROM test_bind_fetch

        +------+------+------+------+------+------+------+
        | c1   | c2   | c3   | c4   | c5   | c6   | c7   |
        +------+------+------+------+------+------+------+
        | 12   | 25   | 38   | 51   | 64   | 77   | 90   |
        | 11   | 24   | 37   | 50   | 63   | 76   | 89   |
        | 10   | 23   | 36   | 49   | 62   | 75   | 88   |
        +------+------+------+------+------+------+------+

        3 rows returned

 tiny     : 12(1)
 short    : 25(2)
 int      : 38(4)
 longlong : 51(8)
 float    : 64.000000(4)
 double   : 77(8)
 char     : 90(2)

 tiny     : 11(1)
 short    : 24(2)
 int      : 37(4)
 longlong : 50(8)
 float    : 63.000000(4)
 double   : 76(8)
 char     : 89(2)

 tiny     : 10(1)
 short    : 23(2)
 int      : 36(4)
 longlong : 49(8)
 float    : 62.000000(4)
 double   : 75(8)
 char     : 88(2)

And here is correct output from test_frm_bug testcase
#####################################
1 of (1/1): test_frm_bug
#####################################

 data directory: /home/msvensson/mysql/bug12698/my41-bug12698/mysql-test/var/master-data/
 test_frm: /home/msvensson/mysql/bug12698/my41-bug12698/mysql-test/var/master-data//client_test_db/test_frm_bug.frm

        +--------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------+----------+----------------+--------------------------------------------------------------------+
        | 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                                                            |
        +--------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------+----------+----------------+--------------------------------------------------------------------+
        | test_frm_bug | NULL   | NULL    | NULL       | NULL | NULL           | NULL        | NULL            | NULL         | NULL      | NULL           | NULL        | NULL        | NULL       | NULL      | NULL     | NULL           | Incorrect information in file: './client_test_db/test_frm_bug.frm' |
        +--------------+--------+---------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+-------------+-------------+------------+-----------+----------+----------------+--------------------------------------------------------------------+

        1 row returned

 Comment: Incorrect information in file: './client_test_db/test_frm_bug.frm'

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/31017

The testcase create a .frm file consisting of "junk". Unfortunately the "junk" wasn't written to the .frm file if mysql_client_test was run with -s option to make it run silent.
This most likely caused the file never to be created on windows, and thus the test case failed.

Aaah, the patch was attached to bug#93 jsut becuase I mentioned it in the comment. We should fix the trigger to send mail to all bugs mentioned or only the first.

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/31028

Pushed to 4.1.16