"AS" does not work anymore
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
Menu
▾
▴
#868 "AS" does not work anymore
In 3.0.3, I could do a request like this: SELECT MY_FIELD AS 'another name for my field' FROM MY_TABLE and get the header of the result renamed to 'another name for my field'. This is no longer the case in 3.1.1, the column header stays the same and does not get renamed.
Which DB-System?
I use DB2 v8 / v9.5 and it works.
The problem is, that JDBC 4 drivers return the column alias in the "columnLabel" metaData, but squirrel shows the "columnName", which is the original name.