[ofbiz-framework] branch release18.12 updated: Incorrect column alias in EntitySQLProcessor for sql query working with mysql (OFBIZ-11573)

[Pawan Verma-2]

This is an automated email from the ASF dual-hosted git repository.

pawan pushed a commit to branch release18.12
in repository https://gitbox.apache.org/repos/asf/ofbiz-framework.git


The following commit(s) were added to refs/heads/release18.12 by this push:
     new 8e2bb29  Incorrect column alias in EntitySQLProcessor for sql query working with mysql (OFBIZ-11573)
8e2bb29 is described below

commit 8e2bb295cf78389c7b686184ad89acb8d315a0fc
Author: Pawan Verma <[hidden email]>
AuthorDate: Tue Apr 28 10:54:57 2020 +0530

    Incorrect column alias in EntitySQLProcessor for sql query working with mysql
    (OFBIZ-11573)
   
    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.
---
 framework/webtools/groovyScripts/entity/EntitySQLProcessor.groovy | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/framework/webtools/groovyScripts/entity/EntitySQLProcessor.groovy b/framework/webtools/groovyScripts/entity/EntitySQLProcessor.groovy
index 8d16cd3..c85fed2 100644
--- a/framework/webtools/groovyScripts/entity/EntitySQLProcessor.groovy
+++ b/framework/webtools/groovyScripts/entity/EntitySQLProcessor.groovy
@@ -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()) {