You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@ofbiz.apache.org by "Jacques Le Roux (Jira)" <ji...@apache.org> on 2020/04/01 16:13:00 UTC
[jira] [Commented] (OFBIZ-11573) Incorrect column alias in
EntitySQLProcessor for sql query working with mysql
[ 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)