On Friday, March 17, 2017 at 8:09:09 PM UTC+1, Charles Woerner wrote: > > Hi, > > Thank you for your great work on H2. I work at Quantcast and we use it > extensively for unit testing. I'm just wondering whether anyone has > actually ever taken (or is currently taking) a stab at the Priority 2 > feature to support ROW_NUMBER() OVER([PARTITION BY][ORDER BY])? If they > have, I'd be interested in learning about what kinds of issues they ran > into (performance, memory, just plain hard to implement). > > I've seen a few references to this proposed feature on this list, but > afaict nobody has actually tried to implement it. >
Now that 12c supports row limiting <http://docs.oracle.com/database/121/SQLRF/statements_10002.htm#BABBADDD> wouldn't it be easier to switch to this and implement the missing rest in H2 rather than implement window functions? I'm not against implementing window functions it just looks easier to me to extend the existing row limiting support with Oracle syntax rather than implement window functions. Cheers Philippe -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
