On JDBC data sources SQL with column aliases don't return any rows. - Support and Troubleshooting

On JDBC data sources SQL with column aliases don't return any rows.  JDBC Data Sources with SQL Column Aliases Return 0 Rows

Problem When using a JDBC data source, if the SQL statement contains column aliases, no rows are returned.

Symptoms Steps to reproduce:

Create a SQL JDBC data source Add a SQL query with column aliases, for example: select as from Test by loading 20 records. The query will run, but it will not return any rows.

The same query without the column alias returns data back. (select from ).

Cause This is due to PRB648117 - SQL Aliases do not work with JDBC Data Source imports.

Workaround Add the following property to the JDBC connection URL to enforce the old behavior: ?useOldAliasMetadataBehavior=true

1. Personalize the form and add the connection URL 2. Open the data source 3. Append the property to the end of the connection URL. I.e. jdbc:mysql://localhost/glide?useOldAliasMetadataBehavior=true