[jira] [Commented] (OFBIZ-5199) Complex Alias is not working with default value.

["ASF subversion and git services (Jira)" <ji...@apache.org>]

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

ASF subversion and git services commented on OFBIZ-5199:
--------------------------------------------------------

Commit 43bb3f5fce760eef875ef466a2a08fa8a2920772 in ofbiz-framework's branch refs/heads/OFBIZ-5199-Complex-Alias-default-field from Deepak Dixit
[ https://gitbox.apache.org/repos/asf?p=ofbiz-framework.git;h=43bb3f5fce ]

Fixed: ComplexAliasField default value not quoted for non-numeric fields in SQL COALESCE (OFBIZ-5199)
The defaultValue in ComplexAliasField.makeAliasColName() was inserted raw
into COALESCE SQL, causing syntax errors for date-time and string field types.
Numeric literals (0) worked fine but timestamp/string values were unquoted.


> Complex Alias is not working with default value.
> ------------------------------------------------
>
>                 Key: OFBIZ-5199
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-5199
>             Project: OFBiz
>          Issue Type: Bug
>          Components: framework
>    Affects Versions: Release 10.04, Release Branch 11.04, Release Branch 12.04, Trunk, Upcoming Branch
>            Reporter: Deepak Dixit
>            Assignee: Deepak Dixit
>            Priority: Minor
>         Attachments: OFBIZ-5199-R.patch, OFBIZ-5199.patch
>
>
> If we pass the default value then complex alias is broken and throwing exception while executing the query.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)