xerial/sqlite-jdbc

Implement DatabaseMetaData#getRowIdLifetime

onacit opened this issue · 1 comments

Is your feature request related to a problem? Please describe.
N/A

Describe the solution you'd like
IMHO, DatabaseMetaData#getRowIdLifetime() may just return the RowIdLifeTime#ROWID_UNSUPPORTED instead throwing a SQLFeatureNotSupportedException.

Describe alternatives you've considered
N/A

Additional context
N/A

From the SQLite documentation it seems the rowid can be modified with an UPDATE statement, thus they would not qualify as "lifetime", no ?

Rowid values may be modified using an UPDATE statement in the same way as any other column value can, either using one of the built-in aliases ("rowid", "oid" or "rowid") or by using an alias created by an integer primary key.