20.12.2021 13:58, Dimitry Sibiryakov wrote:
Even non-scrollable cursors can know total number of records if plan SORT is used
Sort may be hidden inside other execution nodes, so it's not always as easy to know. I'd rather avoid returning (or not) info depending on the query plan.
or they are fetched to the end
This is surely possible, but is it really needed? The cursor is likely to be closed soon, who would need a row count at this point?
Dmitry Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel