Hi, I have an opinion. - The rowId could be a way to retrieve an entry for the table by primary key, whether the table has a single primary column or multiple ones. Currently we have a pseudo-column _key, but it fits for an Ignite-aware client. It is difficult to imagine using it in any JDBC client. - About rowNum, I do not have a strong opinion, but if Oracle has this ability, why do we not have the same? But I think it's based on window functions, which are not supported currently.
On Thu, Feb 26, 2026 at 12:12 PM ткаленко кирилл <[email protected]> wrote: > Hello, igniters! > > To migrate a project to Ignite 2 (using Calcite), I'm missing two > pseudo-columns like in Oracle: rowid[1] and rownum[2]. Since it's not an > ANSI standard, they're missing, as expected. > > But I really need them, as there's some legacy code that I can't change. > > Any objections to me adding them? > If so, why, and what alternatives are there? > > [1] - > https://docs.oracle.com/en/database/oracle/oracle-database/26/sqlrf/ROWID-Pseudocolumn.html > [2] - > https://docs.oracle.com/en/database/oracle/oracle-database/26/sqlrf/ROWNUM-Pseudocolumn.html > -- Vladislav Pyatkov
