Skip to content
New issue

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

Fix Java validation of SQL virtual tables with null column values #452

Closed
mikir opened this issue Nov 10, 2022 · 0 comments
Closed

Fix Java validation of SQL virtual tables with null column values #452

mikir opened this issue Nov 10, 2022 · 0 comments
Assignees
Labels
bug Something isn't working java Java language generator
Milestone

Comments

@mikir
Copy link
Contributor

mikir commented Nov 10, 2022

The validation of SQL virtual tables with null column values fails in Java with the following error:

Message: Column TestTable.anotherId type check failed (UNKNOWN doesn't match to INTEGER)!
Type: INVALID_COLUMN_TYPE

Used schema:

subtype int16 AnotherId;

sql_table TestTable using fts4
{
    sql_virtual int64 docId;
    string text;
    AnotherId anotherId;

    sql "notindexed='anotherId'";
};

To reproduce this bug, it is enough to set column anotherId to null and to use new JDBC driver.

@mikir mikir added bug Something isn't working java Java language generator labels Nov 10, 2022
@mikir mikir added this to the 2.9 milestone Nov 10, 2022
@mikir mikir self-assigned this Nov 10, 2022
@mikir mikir closed this as completed Nov 14, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working java Java language generator
Projects
None yet
Development

No branches or pull requests

1 participant