MySQL Bugs: #39447: Error with NOT NULL condition and LIMIT 1

Bug #39447	Error with NOT NULL condition and LIMIT 1
Submitted:	15 Sep 2008 8:57	Modified:	22 Nov 2010 1:16
Reporter:	Victor Pyankov	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Optimizer	Severity:	S3 (Non-critical)
Version:	6.0.5, 6.0 BZR	OS:	Any (Linux, MS Windows XP SP2)
Assigned to:	Sergey Petrunya	CPU Architecture:	Any
Tags:	DS-MRR, index condition pushdown

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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:

On *nix platforms use the split command e.g. split -b 50MB <my_large_archive> <my_split_archive_prefix>
On windows use WinZip or a similar utility to split the large file

Script for create tables, fill data and execute test statements

Attachment: errtab.sql (application/octet-stream, text), 616 bytes.

Screenshot

Attachment: screen_short.png (image/png, text), 17.54 KiB.