× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2015-08-10T17:37:53Z  · tomconrad last modified 2018-03-15T17:01:49Z

Introduce Qualified Columns for Table Alias : displays only 1 table columns


customer request PM
Dev
QA
Priority Low
Complexity Unknown
Component Q Analyzer - Auto-Completion
Version Future

Introduce Qualified Columns for Table Alias : displays only 1 table columns

When a query uses 2 tables which are the same, but have an alias, the “Introduce Qualified Columns” generates the columns, but uses the prefix for 1 table only. Expected result is to use the Alias of participating tables.

To reproduce:

Navigate to Sybase ASE and pubs2 database

Type the query below:

SELECT  FROM dbo.sales A,
             dbo.sales B
Move the cursor between the SELECT and FROM and then select  “Introduce Qualified Columns” function under the automate menu. You can see that the qualified columns are from table A only.

Issue #13651

In Progress
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017