Details
Blocker Description
This query gives Unknown column 't12.a' in 'field list' error after upgrade to 10.2.26 from 10.2.25.
SELECT
|
t12.a
|
FROM
|
`t1` AS t11,
|
`t2` AS t12,
|
`t3` AS t8
|
JOIN `t4` AS t10
|
LEFT JOIN `t5` AS t9
|
ON
|
t9.`a` = t10.`a`
|
WHERE
|
t10.`a` = t11.`a` AND t10.`a` = t12.`a` AND t8.`a` = t11.`a`;
|
Sample data:
create table t1 (a int);
|
insert into t1 values (7), (2), (9);
|
create table t2 (a int);
|
insert into t2 values (5), (1), (7);
|
create table t3 (a int);
|
insert into t3 values (2), (7), (3);
|
create table t4 (a int);
|
insert into t4 values (2), (7), (3);
|
create table t5 (a int);
|
insert into t5 values (2), (7), (3);
|
Attachments
Issue Links
- is duplicated by
-
MDEV-20330 Combination of "," (comma), cross join and left join fails to parse (regression since 10.1.40)
-
- Closed
-
-
-
- Closed
-