#868 "AS" does not work anymore

3.1
open
Rob Manning
Unknown (89)
5
2012-12-29
2010-04-30
Anonymous
No

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.

Discussion

  • Claus
    Claus
    2010-06-30

    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.