[jira] [Commented] (OFBIZ-5146) in ModelViewEntity.java, a Map is built with only a few of the SQL functions, extend the map to include the MONTH and Year functions.

[Nicolas Malin (Jira)]

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

Jacopo Cappellato commented on OFBIZ-5146:
------------------------------------------

Thanks to all of you for your reviews and feedback; in rev. 1644348 I have committed an implementation based on the EXTRACT function that is part of the Standard SQL:2011 specification.
As mentioned in your comments, Derby doesn't support it because it uses instead the (non standard) YEAR, MONTH, DAY functions.
I am going to propose a patch soon to provide a simple mechanism to use functions without doing any mapping.

> in ModelViewEntity.java, a Map is built with only a few of the SQL functions, extend the map to include the MONTH and Year functions.
> -------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-5146
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-5146
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: Trunk
>            Reporter: Jaideep Singh
>            Assignee: Jacopo Cappellato
>         Attachments: ModelViewEntity.patch, ModelViewEntity.patch, OFBIZ-5146.patch, OFBIZ-5146.patch
>
>
> in ModelViewEntity.java, a Map is built with only a few of the SQL functions, extend the map to include the MONTH and Year functions.

--
This message was sent by Atlassian JIRA
(v6.3.4#6332)