[h2] Re: Window functions in H2

2013-11-26 Thread Daniel Gredler
Hi guys, I'm thinking of taking a crack at implementing window / analytic functions like ROW_NUMBER, RANK and DENSE_RANK -- but it's a little daunting. Does anyone have any hints, pointers or advice? We have one use case for this, but I'm afraid that scratching this itch may be more painful

Re: [h2] Oracle compatibility patch (issue 522)

2013-11-21 Thread Daniel Gredler
Great, thanks! On Thu, Nov 21, 2013 at 3:48 AM, Noel Grandin noelgran...@gmail.com wrote: On 2013-11-14 17:21, Daniel Gredler wrote: I've attached a patch to issue 522 (treat empty strings like NULL in Oracle compatibility mode). Can a committer review the patch? I have some other

[h2] Oracle compatibility patch (issue 522)

2013-11-14 Thread Daniel Gredler
Hi guys, I've attached a patch to issue 522 (treat empty strings like NULL in Oracle compatibility mode). Can a committer review the patch? I have some other Oracle compatibility patches that I'd like to submit, but they need this first patch to be applied first (it contains a new test class

[h2] Add support for sequence min value, max value and cycle

2013-10-30 Thread Daniel Gredler
Hi guys, I've attached a patch to issue 520 ( https://code.google.com/p/h2database/issues/detail?id=520) adding support for some extra sequence attributes (min value, max value and cycle) that are fairly common in other RDBMS. Can a committer have a look and let me know if it looks good?