Bug #77720 "IS bool" condition in where provides worse execution plan than "= integer"
Submitted: 14 Jul 2015 15:41 Modified: 24 Jul 2015 15:14
Reporter: Pep Pla Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version:5.6 OS:MacOS (Mavericks)
Assigned to: CPU Architecture:Any

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:

[14 Jul 2015 15:51] Pep Pla
Test case for partitioned tables

Attachment: test_case_p.sql (application/sql, text), 743 bytes.

[14 Jul 2015 15:52] Pep Pla
Test case for indexed tables

Attachment: test_case_i.sql (application/sql, text), 669 bytes.