Bug #46791 Assertion failed:(table->key_read==0),function unknown function,file sql_base.cc
Submitted: 18 Aug 2009 17:40 Modified: 18 Dec 2009 13:18
Reporter: Patrick Crews Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version:5.0.82, 5.1, 5.4/6.0 OS:Any
Assigned to: Georgi Kodinov CPU Architecture:Any
Tags: crashing bug, subqueries

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[18 Aug 2009 17:41] Patrick Crews
Full crash output

Attachment: bug46791_crash_output.txt (text/plain), 15.68 KiB.

[18 Aug 2009 17:41] Patrick Crews
MTR test case to repeat the crash

Attachment: bug46791_test.txt (text/plain), 19.78 KiB.

[18 Aug 2009 20:39] Patrick Crews
Full MTR test case with simplified and original queries

Attachment: bug46791_full_test.txt (text/plain), 39.58 KiB.