Bug #57 Bug in UNION

• Submitted: 5 Feb 2003 11:54
• Modified: 3 Mar 2003 5:55
• Reporter: Georg Richter
• Status: Closed
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.0.x + 4.1
• OS: Any (all)
• CPU Architecture: Any

[5 Feb 2003 11:54] Georg Richter

Description:
Query 1 returns 0 rows
Query 2 returns 1 row

QUERY 1 UNION QUERY 2 returns 0 rows

How to repeat:
You can download data and queries from http://www.sc-leinfelden.de/mysql/testcase204.zip

Files: 

dump.sql tables and data
1.sql    Query 1
2.sql    Query 2
3.sql    Query 1 UNION Query 2