Issue Details (XML | Word | Printable)

Key: JDBC-562
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Mark Rotteveel
Reporter: Mark Rotteveel
Votes: 0
Watchers: 0
Operations

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

DatabaseMetaData patterns: treat escape character as normal when not followed by _, % or itself.

Created: 30/Oct/18 04:02 PM   Updated: 31/Oct/18 04:51 PM
Component/s: None
Affects Version/s: Jaybird 2.2.14, Jaybird 3.0.5
Fix Version/s: Jaybird 4

Issue Links:
Relate
 


 Description  « Hide
Metadata patterns in JDBC are derived from ODBC, and ODBC specifies with regard to the escape:

"""
An escape character, which is driver-specific and is used to include underscores, percent signs, and the escape character as literals. If the escape character precedes a non-special character, the escape character has no special meaning. If the escape character precedes a special character, it escapes the special character. For example, "\a" would be treated as two characters, "\" and "a", but "\%" would be treated as the non-special single character "%".
"""
(from: https://docs.microsoft.com/en-us/sql/odbc/reference/develop-app/pattern-value-arguments?view=sql-server-2017)

An escape followed by a non-special is currently not handled correctly, this needs to be fixed.

See also JDBC-559.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Rotteveel added a comment - 30/Oct/18 04:25 PM
Don't forget to change SqlLikeMatcher as well (and consider renaming to MetadataPatternMatcher).