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
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Affects Version/s | 10.1 [ 16100 ] | |
| Affects Version/s | 10.2 [ 14601 ] | |
| Affects Version/s | 10.3 [ 22126 ] | |
| Affects Version/s | 10.4 [ 22408 ] |
| Fix Version/s | 10.1 [ 16100 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] |
| Assignee | Igor Babaev [ igor ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Link |
This issue is duplicated by |
| Affects Version/s | 5.5 [ 15800 ] |
| Assignee | Igor Babaev [ igor ] | Oleksandr Byelkin [ sanja ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Fix Version/s | 5.5 [ 15800 ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Assignee | Oleksandr Byelkin [ sanja ] | Igor Babaev [ igor ] |
| Component/s | Parser [ 10201 ] | |
| Fix Version/s | 5.5.66 [ 23403 ] | |
| Fix Version/s | 10.1.42 [ 23407 ] | |
| Fix Version/s | 10.2.27 [ 23717 ] | |
| Fix Version/s | 10.3.18 [ 23719 ] | |
| Fix Version/s | 10.4.8 [ 23721 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 5.5 [ 15800 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Closed [ 6 ] | Stalled [ 10000 ] |
| Priority | Major [ 3 ] | Blocker [ 1 ] |
| Resolution | Fixed [ 1 ] | |
| Status | Stalled [ 10000 ] | Closed [ 6 ] |
| Link |
This issue is duplicated by |
| Workflow | MariaDB v3 [ 98742 ] | MariaDB v4 [ 156578 ] |