回复: Re: GROUP BY month(date)

[Lei Wu]

Jacopo,

I tested both patches and it turns out at least Derby is not happy with these changes. I tried SQL grammar EXTRACT(YEAR/MONTH/DAY FROM '2014-11-26') literally in database Derby and I found Derby does not support such grammar. I then searched WWW and found MySQL and Oracle support such grammar well. However I didn't get the chance to test the patches in these two databases. Whereas I did configured an Ofbiz instance with database postgresQL in my lab environment, I'll try the SQL grammar in postgresQL tomorrow, and if it supports the grammar well, I'll test the patches again in that instance. I will let you know as soon as results come out.

--
发自我的ONEPLUS智能手机

Jacopo Cappellato <[hidden email]>编写：

>Thank you!
>It would be even better if you could test the latest patch I have attached to Jira:
>
>https://issues.apache.org/jira/secure/attachment/12683398/OFBIZ-5146.patch
>
>This last one also supports the "day" function.
>
>Regards,
>
>Jacopo
>
>On Nov 25, 2014, at 4:56 AM, [hidden email] wrote:
>
>> Jacopo,
>>
>> Sure, I'll test this new patch and let you know the results once it's done.
>>
>> --
>> 发自我的ONEPLUS智能手机
>>
>>
>>
>> Jacopo Cappellato <[hidden email]>编写：
>>
>