subselect with reference to outer select fails [CORE3967] #4300
Assignees
Comments
Modified by: @dyemanovassignee: Dmitry Yemanov [ dimitr ] |
Modified by: @dyemanovstatus: Open [ 1 ] => In Progress [ 3 ] |
Modified by: @dyemanovstatus: In Progress [ 3 ] => Open [ 1 ] |
Modified by: @dyemanovstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Alpha 1 [ 10331 ] |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Submitted by: Frank Schlottmann-Goedde (fsg)
Using the following script in isql against the employee database demonstrates the error
/*
subselect with reference to outer select
fails with:
Statement failed, SQLSTATE = 42S22
Dynamic SQL Error
-SQL error code = -206
-Column unknown
-R1.RDB$RELATION_NAME
-At line 8, column 32
*/
select R1.RDB$RELATION_NAME
from RDB$RELATION_FIELDS F1
join RDB$RELATIONS R1 on F1.RDB$RELATION_NAME = R1.RDB$RELATION_NAME
where F1.RDB$FIELD_NAME ='EMP_NO' and
(not exists(select R2.RDB$RELATION_NAME
from RDB$RELATION_FIELDS F2
join RDB$RELATIONS R2 on F2.RDB$RELATION_NAME=R1.RDB$RELATION_NAME
where F2.RDB$FIELD_NAME ='PHONE_EXT'));
Commits: 92e6b2e
The text was updated successfully, but these errors were encountered: