Bug #24186 nested query across partitions returns fewer records
Submitted: 10 Nov 2006 14:08 Modified: 1 Feb 2007 1:04
Reporter: Giuseppe Maxia
Status: Closed
Category:Server: Partition Severity:S1 (Critical)
Version:5.1.11,5.1.13 OS:Linux (Linux)
Assigned to: Alexey Botchkov Target Version:
Tags: subquery, nested query, partitions, Q1

File: Maximum allowed size is 500KB.
Description:
Privacy:

If the data you need to attach is more than 500KB, you should create a compressed archive of the data and a README file that describes the data with a filename that includes the bug number (example: bug-data-24186.zip), and use FTP to upload the archive to ftp://ftp.mysql.com/pub/mysql/upload/. Once you have uploaded the file, add a comment to this bug to notify us about it. Note: This directory is unlistable, which means that once you have uploaded your file, you will not be able to see it.

All entries become the exclusive editorial property of Sun Microsystems, Inc.

[10 Nov 2006 15:47] Giuseppe Maxia 
Test script and expected result for bug 24186

Attachment: bug_24186_test.zip (application/zip, text), 1.58 KiB.
[11 Nov 2006 16:58] Giuseppe Maxia 
Wider test case (checks partitions by key, list, range, hash) for three engines (MyISAM,
InnoDB, Archive)

Attachment: bug_24186.pl (text/x-perl), 5.57 KiB.
[20 Dec 2006 18:15] Giuseppe Maxia 
updated test for bug #24186

Attachment: bug_24186test.tar.gz (application/gzip, text), 887 bytes.