#908 the query result don't show column label in mysql 5.1 driver

3.1
closed
nobody
5
2010-10-30
2010-10-19
No

when a query with column label is executed (ie select ID as myid, description as mydesc ...) the result show the column name instead of the column label, this is, ID and description instead of myid and mydesc.
The problem can be that is used the getColumnName instead of getColumnLabel

Discussion

  • Gerd Wagner

    Gerd Wagner - 2010-10-30

    Right, the problem lies in getColumnName versus getColumnLabel. Unfortunately databases handle labels and names different. We lately introduces a new global preference to cope with the problem. See the change log entry cited below:

    "Introduced a new general data type property 'Use column labels instead of column names in result headers'.
    See Global Preferences --> Tab 'Data Type Controls'. Will be useful e.g. for MySQL if Aliases are used in Select clauses."

    This bug will be closed.

     
  • Gerd Wagner

    Gerd Wagner - 2010-10-30
    • status: open --> closed
     

Log in to post a comment.