MySQL Alias doesnt work

[Manoj Chaurasia]

Hey there.

I'm trying to change the name of a column via MySQL. Here the statement:

 

SELECT id AS Personalnumber FROM PersonTable

Works fine with my Oracle DB but not with MySQL. The output field of my process will not refresh the name and is still called id.

Any ideas

 

greetz kakl

[David Abragimov]

https://support.tibco.com/s/article/Using-Column-Alias-in-MySQL-and-MariaDB Column alias is not working with MySQL

Resolution

 Just append "useOldAliasMetadataBehavior=true" this property to the JDBC URL e.g.:

For MySQL-

jdbc:mysql://host:3306/mysqluseOldAliasMetadataBehavior=true