description: SQL> select *
CON> from rdb$relations r left join
CON> (select first 1 * from rdb$relation_fields rf
CON> where err_identifier = rf.rdb$relation_name
CON> order by rdb$field_name) rf
CON> on r.rdb$relation_name = rf.rdb$relation_name;

returns error

Statement failed, SQLCODE = -206
Dynamic SQL Error
-SQL error code = -206
-Column unknown
-ERR_IDENTIFIER
-At line 6, column 29

Error position is incorrect, as it points to "r1.rdb$relation_name"
in "on r.rdb$relation_name = r1.rdb$relation_name" condition

It should be "At line 4, column 8", as in 2.0.x branch

Best regards, Eugene

=>

SQL> select *
CON> from rdb$relations r left join
CON> (select first 1 * from rdb$relation_fields rf
CON> where err_identifier = rf.rdb$relation_name
CON> order by rdb$field_name) r1
CON> on r.rdb$relation_name = r1.rdb$relation_name;

returns error

Statement failed, SQLCODE = -206
Dynamic SQL Error
-SQL error code = -206
-Column unknown
-ERR_IDENTIFIER
-At line 6, column 29

Error position is incorrect, as it points to "r1.rdb$relation_name"
in "on r.rdb$relation_name = r1.rdb$relation_name" condition

It should be "At line 4, column 8", as in 2.0.x branch

Best regards, Eugene

Workflow: jira [ 13702 ] => Firebird [ 14018 ]