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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
