Issue Details (XML | Word | Printable)

Key: JDBC-323
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Mark Rotteveel
Reporter: Mark Rotteveel
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
Jaybird JCA/JDBC Driver

DatabaseMetaData.getTypeInfo column SEARCHABLE: incorrect value

Created: 10/Aug/13 11:40 AM   Updated: 07/May/17 12:32 PM
Component/s: JDBC driver
Affects Version/s: Jaybird 2.1.6, Jaybird 2.2, Jaybird 2.2.1, Jaybird 2.2.2, Jaybird 2.2.3, Jaybird 2.2.4
Fix Version/s: Jaybird 3.0.0

 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Rotteveel added a comment - 15/Jul/16 09:54 AM
Turns out I was wrong, must data types can be searched with LIKE (because they are automatically converted to string for the comparison).

Mark Rotteveel added a comment - 15/Jul/16 10:17 AM
Actually broadened searchability of blobs (type text and binary) to fully searchable on Firebird 2.1 and higher. Left others untouched.