MySQL Bugs: #12698: abnormal program termination running mysql_client

Bug #12698	abnormal program termination running mysql_client_test
Submitted:	21 Aug 2005 5:26	Modified:	20 Oct 2005 12:10
Reporter:	[ name withheld ]
Status:	Closed
Category:	Server	Severity:	S3 (Non-critical)
Version:	4.1.13a, 5.0.15	OS:	Microsoft Windows (XP Home, fedora)
Assigned to:	Magnus Blaudd	Target Version:

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