I think you're going to need to run your new query before the main select and then re-init the main select
Running it on-demand like that is going to lead to it trying to run somewhere inside the main select and confusing things. Which means that the top-level select code will probably have to somewhere do an explicit walk over the tree to run RANK-type queries, but that is fine, I always assumed that RANK-type stuff would need special handling at the top level. -- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.