Implement DatabaseMetaData#getRowIdLifetime
onacit opened this issue · 1 comments
onacit commented
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
gotson commented
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.