ofbiz-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Le Roux (Jira)" <j...@apache.org>
Subject [jira] [Commented] (OFBIZ-11573) Incorrect column alias in EntitySQLProcessor for sql query working with mysql
Date Wed, 01 Apr 2020 16:13:00 GMT

    [ https://issues.apache.org/jira/browse/OFBIZ-11573?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17072915#comment-17072915
] 

Jacques Le Roux commented on OFBIZ-11573:
-----------------------------------------

HI Pawan,

I wonder because it works correctly in trunk demo where the code is the same. I have also
no problem locally with R18. I did not check further with R17 when I got: "SQL Exception while
executing the following:SELECT PARTY_ID AS customerPartyId FROM PARTY (Table/View 'PARTY'
does not exist.) " Maybe a wrong data load locally on my side.

> Incorrect column alias in EntitySQLProcessor for sql query working with mysql 
> ------------------------------------------------------------------------------
>
>                 Key: OFBIZ-11573
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-11573
>             Project: OFBiz
>          Issue Type: Bug
>          Components: framework/webtools
>    Affects Versions: Release Branch 18.12, Release Branch 17.12, Trunk
>            Reporter: Pawan Verma
>            Assignee: Pawan Verma
>            Priority: Major
>         Attachments: EntitySQLProcessor.png, OFBIZ-11573.patch
>
>
> Steps to reproduce:
>  # Go to EntitySQLProcessor.
>  # Try simple SQL query: SELECT PARTY_ID AS customerPartyId FROM PARTY
>  # See the column alias in the result, it should be the provided one.
>  # See screenshot for more details.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Mime
View raw message