Bug #11348 Debug infos when using "Export as" with EXPLAIN results
Submitted: 15 Jun 2005 10:29 Modified: 28 Jun 2005 12:12
Reporter: Ivan Moretti Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.1.10 OS:Windows (Windows XP (SP2))
Assigned to: CPU Architecture:Any

[15 Jun 2005 10:29] Ivan Moretti
Description:
When I try to export the results of the EXPLAIN command (Export resultset/Export as CSV File...) and the resultset contains a NULL value, a debug window shows up saying:
** (process:3208): CRITICAL **: file .\source\myx_aux_functions.c: line: 405 assertion `str != NULL && *str` failed

Other Export Resultset options (HTML, XML and Excel) are not affected.

How to repeat:
Create a table without key
CREATE TABLE t1 (c1);

then run EXPLAIN command against "SELECT * FROM t1" and export resultset as CSV file
[16 Jun 2005 12:19] Aleksey Kishkin
Hi! I tested it on win xp sp2 against mysql 5.0.6 and gt file with:

"id","select_type","table","type","possible_keys","key","key_len","ref","rows","Extra"
1,"SIMPLE","t","system","","","","",0,"const row not found"

No error messages appears.

If you have ideas how to reproduce that error, pls let us know, we'll test it.
[16 Jun 2005 12:23] Aleksey Kishkin
Yes, I reproduced it. This debug windows appeared when I test it second time. The file with result was crreated though.
[27 Jun 2005 13:59] Vladimir Kolesnikov
I cannot repro it in current state of 1.1.10 - several csv-files are created with no problem