Bug #9017 Rows are omitted from result set when using JOIN, XOR and ISNULL
Submitted: 7 Mar 2005 12:02 Modified: 28 Apr 2005 17:48
Reporter: Petr Tomenendal
Status: Closed
Category:Server: Optimizer Severity:S2 (Serious)
Version:4.1.10 OS:Microsoft Windows (WinXP SP2, Linux 2.4.22)
Assigned to: Bugs System Target Version:

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-9017.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.

[7 Mar 2005 12:04] Petr Tomenendal 
SQL Test case - just copy into test db - creates table, add records, executes test queries

Attachment: queries.sql (text/plain), 1.35 KiB.
[7 Mar 2005 12:05] Petr Tomenendal 
Detailed description in txt - queries, result, status from test machines

Attachment: description.txt (text/plain), 5.48 KiB.