Issue Details (XML | Word | Printable)

Key: JDBC-555
Type: Improvement Improvement
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

Re-check FirebirdVersionMetaData and remove words reserved in SQL:2003

Created: 01/Oct/18 07:59 PM   Updated: 22/Apr/19 03:38 PM
Component/s: None
Affects Version/s: Jaybird 3.0.0, Jaybird 3.0.1, Jaybird 3.0.2, Jaybird 3.0.3, Jaybird 3.0.4, Jaybird 3.0.5, Jaybird 4
Fix Version/s: Jaybird 4


 Description  « Hide
When looking at JDBC-554 I noticed some Firebird 3 keywords that are reserved in SQL:2003 (for example the REGR_* keywords, CHAR_LENGTH and CHARACTER_LENGTH). Check keyword list and fix.

It is probably best to rebuild (and retain) the full list of keywords, and re-check fully, instead of just removing the currently present keywords that are in SQL:2003.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Rotteveel added a comment - 03/Nov/18 01:21 PM
I may have done this because - not sure - Hibernate 5 used an incomplete keyword list (or from an earlier SQL standard version), or maybe because JDBC 3 and earlier used SQL92 as baseline; including those additional keywords allows for better support of quoting object names when necessary. I'll need to double check that.

Mark Rotteveel added a comment - 22/Apr/19 03:38 PM
Created a tool to track reserved/non-reserved words (at https://github.com/mrotteveel/firebird-reserved-words) and refreshed the lists in FirebirdVersionMetaData