Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.11.16, 11.4.10, 11.8.6
Description
After porting database (by script) from 11.4.2 into fresh new 11.8.6 database some of views were not recreated. That was because new system found an error in select while the old version runs the query fine. I've reduced the query to the minimum:
SELECT * from DP j
|
WHERE
|
not exists (
|
select 0 from src |
where src.dp_id = j.dp_id
|
union all
|
select 0 from dev |
where j.dp_id = src.dp_id
|
)
|
|
and it still output:
SQL Error (1054): Unknown column 'j.dp_id' in 'WHERE'
The essential is 'union all' construct. It runs without error If only the first or the second part in not exists subquery left.
That worked in Oracle, that worked in 11.4.2, not working in 11.8.6. Does it mean that such SQL statement isn't legal anymore?
Attachments
Issue Links
- is caused by
-
MDEV-37325 Incorrect results for INTERSECT ALL in ORACLE mode
-
- Closed
-
- relates to
-
MDEV-30979 mariadb gives error for unknown column in subquery but mysql runs fine
-
- Confirmed
-