[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: |
|
| Description |
|
The following sequence of commands gives us an unexpected error message in MariaDB 5.5: CREATE TABLE t1 (a int); MariaDB [test]> SELECT a FROM t1 UNION SELECT b FROM t2 JOIN (t3) ON ( t2.b = t3.c ); 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; 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 |
| Comment by Rasmus Johansson (Inactive) [ 2012-06-24 ] |
|
Launchpad bug id: 1010729 |