Incorrect column alias in EntitySQLProcessor for sql query working with mysql
More details: Method getColumnLabel returns the designated column's suggested title for use in printouts and displays. Method getColumnName returns the designated column's name.
Thanks: Suraj and Jacques for the review.
@@ -45,7 +45,7 @@ if (sqlCommand && selGroup) {
rsmd = rs.getMetaData()
numberOfColumns = rsmd.getColumnCount()
for (i = 1; i <= numberOfColumns; i++) {
- columns.add(rsmd.getColumnName(i))
+ columns.add(rsmd.getColumnLabel(i))
}
rowLimitReached = false
while (rs.next()) {
