xerial / sqlite-jdbc

SQLite JDBC Driver
Apache License 2.0
2.86k stars 619 forks source link

Implement DatabaseMetaData#getRowIdLifetime #1070

Closed onacit closed 9 months ago

onacit commented 9 months ago

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

Describe the solution you'd like IMHO, [DatabaseMetaData#getRowIdLifetime()](https://docs.oracle.com/en/java/javase/21/docs/api/java.sql/java/sql/DatabaseMetaData.html#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 9 months ago

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.