Strange comment behaviour in SQL Windows

[ScaryTom]

When the user clicks on a column in the result pane of an SQL Window, the column name, data type, nullable and comments are displayed on the status bar of the window. However, if the SELECT statement that has been executed retrieves rows from two or more tables, then the comments etc. are only displayed for columns from the first table in the SELECT and not those from subsequent tables.

e.g.
SELECT a.COL1,
b.COL2
FROM TAB1 a,
TAB2 b
WHERE a.ID = b.ID

Comments are displayed when clicking in col1 in the results pane, but not when clicking in col2.

Furthermore, if two columns with the same name are selected from two different tables, the comment displayed in the status bar for both those columns will always be that taken from the first of the two tables, even if the actual comment for the column on the second table differs from that of the first.

 

[Marco Kalter]

That is indeed a restriction: only columns of the first table are described.

 

[ScaryTom]

Thanks for the fast reply.

I didn't realise that this issue was a known "feature".

Are there any plans to improve this in a future release?

cheers,

Tom

 

[Marco Kalter]

We don't have any short term plans for this, but if enough people are hindered by this restriction, this can of course change.