description: For the following query

with CTE as (SELECT column1 from TABLEA T)
select CT.column1 from CTE CT

isc_info_sql_relation_alias reports an incorrect alias. It reports 'CT T', while 'CT' is expected.

Note that this also applies for all variants with/without an explicit alias, for example

with CTE as (SELECT column1 from TABLEA)
select column1 from CTE

will report 'CTE TABLEA' instead of 'CTE'

This is especially a problem if you use the alias information to generate enhancements for a base query (see JDBC513).

=>

For the following query

with CTE as (SELECT column1 from TABLEA T)
select CT.column1 from CTE CT

isc_info_sql_relation_alias reports an incorrect alias. It reports 'CT T', while 'CT' is expected.

Note that this also applies for all variants with/without an explicit alias, for example

with CTE as (SELECT column1 from TABLEA)
select column1 from CTE

will report 'CTE TABLEA' instead of 'CTE'

And for nested queries, eg

select * from (select column1 from tablea t) d

will return an alias 'd t' instead of 't'.

This is especially a problem if you use the alias information to generate enhancements for a base query (see JDBC513).

summary: isc_info_sql_relation_alias reports incorrect alias for CTE => isc_info_sql_relation_alias reports incorrect alias for CTE or nested queryies

description: For the following query

with CTE as (SELECT column1 from TABLEA T)
select CT.column1 from CTE CT

isc_info_sql_relation_alias reports an incorrect alias. It reports 'CT T', while 'CT' is expected.

Note that this also applies for all variants with/without an explicit alias, for example

with CTE as (SELECT column1 from TABLEA)
select column1 from CTE

will report 'CTE TABLEA' instead of 'CTE'

And for nested queries, eg

select * from (select column1 from tablea t) d

will return an alias 'd t' instead of 't'.

This is especially a problem if you use the alias information to generate enhancements for a base query (see JDBC513).

=>

For the following query

with CTE as (SELECT column1 from TABLEA T)
select CT.column1 from CTE CT

isc_info_sql_relation_alias reports an incorrect alias. It reports 'CT T', while 'CT' is expected.

Note that this also applies for all variants with/without an explicit alias, for example

with CTE as (SELECT column1 from TABLEA)
select column1 from CTE

will report 'CTE TABLEA' instead of 'CTE'

And for nested queries, eg

select * from (select column1 from tablea t) d

will return an alias 'd t' instead of 'd'.

This is especially a problem if you use the alias information to generate enhancements for a base query (see JDBC513).

summary: isc_info_sql_relation_alias reports incorrect alias for CTE or nested queryies => isc_info_sql_relation_alias reports incorrect alias for CTE or nested queries

Link: This issue is duplicated by JDBC513 [ JDBC513 ]

assignee: Vlad Khorsun [ hvlad ]

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 3.0.3 [ 10810 ]

Fix Version: 4.0 Beta 1 [ 10750 ]

Version: 3.0.1 [ 10730 ]

Version: 2.5.6 [ 10721 ]

Version: 3.0.0 [ 10740 ]

Version: 4.0 Initial [ 10621 ]

Version: 2.5.5 [ 10670 ]

Version: 2.5.4 [ 10585 ]

Version: 2.5.3 Update 1 [ 10650 ]

Version: 2.1.7 [ 10651 ]

Version: 2.5.3 [ 10461 ]

Version: 2.5.2 Update 1 [ 10521 ]

Version: 2.5.2 [ 10450 ]

Version: 2.5.1 [ 10333 ]

Version: 2.5.0 [ 10221 ]

Fix Version: 2.5.8 [ 10809 ]

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Covered by another test(s)

Test Details: See test for CORE5667

status: Resolved [ 5 ] => Resolved [ 5 ]

Test Details: See test for CORE5667 => See test for CORE5667.
Two samples from here were added into core_5667.fbt.

status: Resolved [ 5 ] => Closed [ 6 ]