We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
stored
It seems like generated columns with stored in sqlite are not marked as generated.
create the following schema with sqlite:
create table foo( id integer primary key, bar int not null generated always as (id + 1) stored );
Then, on that column .isGenerated is false. Without the stored keyword, it is true.
.isGenerated
false
true
No response
16.21.1
21
NixOS unstable
sqlite
org.xerial:sqlite-jdbc::3.46.0.0
The text was updated successfully, but these errors were encountered:
@fdietze This is not a SchemaCrawler issue, since SchemaCrawler simply reports the information that the SQLite JDBC driver provides.
See JDBC3DatabaseMetaData. It only checks for a value of "2", when according to the SQLite documentation, it should be checking for both 2 and 3.
Sorry, something went wrong.
I created issue xerial/sqlite-jdbc#1132 to make the fix.
@fdietze Here is the PR I submitted: xerial/sqlite-jdbc#1133
That was quick. Thank you so much for your work!
@fdietze The SQLite JDBC driver team has merged the PR. Once they release, I will release a new version of SchemaCrawler.
sualeh
No branches or pull requests
Description
It seems like generated columns with
stored
in sqlite are not marked as generated.How to Reproduce
create the following schema with sqlite:
Then, on that column
.isGenerated
isfalse
. Without thestored
keyword, it istrue
.Relevant log output
No response
SchemaCrawler Version
16.21.1
Java Version
21
Operating System and Version
NixOS unstable
Relational Database System and Version
sqlite
JDBC Driver and Version
org.xerial:sqlite-jdbc::3.46.0.0
The text was updated successfully, but these errors were encountered: