[MDEV-2263] LP:1010729 - Unexpected syntax error for a query with UNION of left joins Created: 2012-06-09  Updated: 2014-06-20  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major
Reporter: Igor Babaev Assignee: Igor Babaev
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug1010729.xml    

 Description   

The following sequence of commands gives us an unexpected error message in MariaDB 5.5:

CREATE TABLE t1 (a int);
CREATE TABLE t2 (b int);
CREATE TABLE t3 (c int);
SELECT a FROM t1 UNION SELECT b FROM t2 JOIN (t3) ON ( t2.b = t3.c );

MariaDB [test]> SELECT a FROM t1 UNION SELECT b FROM t2 JOIN (t3) ON ( t2.b = t3.c );
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON ( t2.b = t3.c )' at line 1

If we exchange SELECTs in the above UNION the query will be accepted though:

MariaDB [test]> SELECT b FROM t2 JOIN (t3) ON ( t2.b = t3.c ) UNION SELECT a FROM t1;
Empty set (0.00 sec)

The versions MariaDB 5.2/5.3 are not affected, while mysql-5.5 is affected: see http://bugs.mysql.com/bug.php?id=54382



 Comments   
Comment by Elena Stepanova [ 2012-06-24 ]

Re: Unexpected syntax error for a query with UNION of left joins
Fix released in 5.5.25

Comment by Rasmus Johansson (Inactive) [ 2012-06-24 ]

Launchpad bug id: 1010729

Generated at Thu Feb 08 06:40:40 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.