Hi, This is *far for being finished* but I'm working on the function ROW_NUMBER( ) OVER( ) and ROWNUM() in order to handle it the same way as PostGreSQL. I post it here before going further because I want to know if such patch when done have a change to be merged or not.
The idea is to be able to retrieve original row number when using ROWNUM( ) in a sub-request. The the following line in document would be removed "(even when the index conditions are specified in an outer query)" Sample with Postgre: <raw> create index on london."osm-line"(highway) select ROW_ID, highway from (select ROW_NUMBER() OVER () ROW_ID,* from london."osm-line") as d where d.highway = 'footway' limit 5; row_id(int8) highway(varchar) 3 footway 10 footway 11 footway 13 footway 20 footway </raw> The *first try* of the patch is here, but it return the original index without using sub-request, and it is not expected. https://github.com/nicolas-f/H2-Mirror/commit/7e68a515c2f02e45f890203e1f5e5182a6953606 -Nicolas IRSTV FR CNRS 2488 -- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
