[MDEV-3470] LP:943543 - A query with LEFT JOIN returns a wrong result in mariadb 5.3 Created: 2012-02-29 Updated: 2015-02-02 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 slightly modified test case for mysql bug #58456 produces a wrong result in mariadb-5.3.5 CREATE TABLE t1 ( INSERT INTO t1 VALUES (NULL,1,1), (6,2,2), (5,3,3), (NULL,4,4); CREATE TABLE t2 ( INSERT INTO t2 VALUES (3), (8), (5); SELECT t1.pk DROP TABLE t1,t2; The SELECT of the test case returns an empty set though the expected result is:
----
---- |
| Comments |
| Comment by Igor Babaev [ 2012-03-01 ] |
|
Re: A query with LEFT JOIN returns a wrong result in mariadb 5.3 |
| Comment by Igor Babaev [ 2012-03-01 ] |
|
Re: A query with LEFT JOIN returns a wrong result in mariadb 5.3 |
| Comment by Elena Stepanova [ 2012-04-27 ] |
|
Re: A query with LEFT JOIN returns a wrong result in mariadb 5.3 |
| Comment by Rasmus Johansson (Inactive) [ 2012-04-27 ] |
|
Launchpad bug id: 943543 |