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

DatabaseMetaData.getTypeInfo column SEARCHABLE: incorrect value [JDBC323] #369

Closed
firebird-automations opened this issue Aug 10, 2013 · 5 comments

Comments

@firebird-automations
Copy link

Submitted by: @mrotteveel

The DatabaseMetaData.getTypeInfo() column SEARCHABLE contains the wrong value for a lot of types, it declares typeSearchable for all types (except boolean), while most types should be typePredBasic as most types cannot be queried using LIKE.

Commits: 2e571b3

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

Version: Jaybird 2.2.3 [ 10510 ]

Version: Jaybird 2.2.2 [ 10480 ]

Version: Jaybird 2.2.1 [ 10474 ]

Version: Jaybird 2.2 [ 10053 ]

Version: Jaybird 2.1.6 [ 10285 ]

Version: Jaybird 2.2.4 [ 10531 ]

Fix Version: Jaybird 2.3 [ 10440 ]

@firebird-automations
Copy link
Author

Commented by: @mrotteveel

Turns out I was wrong, must data types can be searched with LIKE (because they are automatically converted to string for the comparison).

@firebird-automations
Copy link
Author

Commented by: @mrotteveel

Actually broadened searchability of blobs (type text and binary) to fully searchable on Firebird 2.1 and higher. Left others untouched.

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Author

Modified by: @mrotteveel

status: Resolved [ 5 ] => Closed [ 6 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment