Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
10.2(EOL)
Description
Note: I'm not sure whether it's supposed to work, but it looks suspicious.
create table t1 (i int); |
create table t2 (j int); |
|
# This of course works: |
select * from t1 where exists ( select * from t2 where j = i ); |
# Empty set (0.01 sec) |
|
# But this does not: |
select * from t1 where exists ( with cte as ( select * from t2 where j = i ) select * from cte ); |
# ERROR 1054 (42S22): Unknown column 'i' in 'where clause' |
Attachments
Issue Links
- is duplicated by
-
MDEV-19337 CTEs not working with outer references
- Closed