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 <column> as <aliasName> from <table>
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 <column> from <table>).
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