Re: [hibernate-dev] 6.0 - formalized standard functions

2017-05-31 Thread Christian Beikov
Answers inline... Am 31.05.2017 um 14:38 schrieb Steve Ebersole: > Thanks for reply Christian.. > > > On Wed, May 31, 2017 at 7:18 AM Christian Beikov > mailto:christian.bei...@gmail.com>> wrote: > > Looks good. OTOH I'd also like to see the following functions > > * millisecond_diff >

Re: [hibernate-dev] 6.0 - formalized standard functions

2017-05-31 Thread Steve Ebersole
Thanks for reply Christian.. On Wed, May 31, 2017 at 7:18 AM Christian Beikov wrote: > Looks good. OTOH I'd also like to see the following functions > > * millisecond_diff > * second_diff > * minute_diff > * hour_diff > * day_diff > * week_diff > * month_diff > * quater_diff >

Re: [hibernate-dev] 6.0 - formalized standard functions

2017-05-31 Thread Steve Ebersole
Ok, as there are no objections to switching `str` from CHAR to VARCHAR cast I will make that change. On Tue, May 30, 2017 at 8:09 AM Sanne Grinovero wrote: > On 30 May 2017 at 13:02, Steve Ebersole wrote: > > For whatever reason JPA and a few of the databases do not categorize > > coalesce and

Re: [hibernate-dev] 6.0 - formalized standard functions

2017-05-31 Thread Christian Beikov
Looks good. OTOH I'd also like to see the following functions * millisecond_diff * second_diff * minute_diff * hour_diff * day_diff * week_diff * month_diff * quater_diff * year_diff * epoch - generally defined as `extract(epoch from ?1)` * group_concat - string aggregation f

Re: [hibernate-dev] 6.0 - formalized standard functions

2017-05-30 Thread Sanne Grinovero
On 30 May 2017 at 13:02, Steve Ebersole wrote: > For whatever reason JPA and a few of the databases do not categorize > coalesce and nullif as functions - hence the "not technically a function" > part. > > However in Hibernate I have defined them as functions for the sake of users > being able to

Re: [hibernate-dev] 6.0 - formalized standard functions

2017-05-30 Thread Steve Ebersole
For whatever reason JPA and a few of the databases do not categorize coalesce and nullif as functions - hence the "not technically a function" part. However in Hibernate I have defined them as functions for the sake of users being able to plug in custom function templates. On Tue, May 30, 2017 at

Re: [hibernate-dev] 6.0 - formalized standard functions

2017-05-30 Thread Sanne Grinovero
Hi Steve, just a curiosity; for `coalesce` and `nullif` you stated "not technically a function, but supported as such to allow overriding". What does it mean? Thanks! Sanne On 29 May 2017 at 22:29, Steve Ebersole wrote: > Hibernate has always defined a set of functions that should always be > a

[hibernate-dev] 6.0 - formalized standard functions

2017-05-29 Thread Steve Ebersole
Hibernate has always defined a set of functions that should always be available on every Dialect/database. JPA formalized some of these, but Hibernate still had a superset. So I wanted to formalize the complete set of supported functions. Here is the formalized list of what Hibernate has always