Issue Details (XML | Word | Printable)

Key: JDBC-481
Type: Bug Bug
Status: Closed Closed
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

Token recognition error for generated keys query with whitespace in (quoted) table name

Created: 27/Feb/17 02:45 PM   Updated: 05/Mar/17 01:00 PM
Component/s: JDBC driver
Affects Version/s: Jaybird 2.2.9, Jaybird 2.2.10, Jaybird 2.2.11, Jaybird 2.2.12, Jaybird 3.0.0-alpha-1, Jaybird 3.0.0-beta-1, Jaybird 3.0.0-beta-2
Fix Version/s: Jaybird 3.0.0-beta-3, Jaybird 2.2.13, Jaybird 3.0.0


 Description  « Hide
A generated keys query with a insert statement with a space in the (quoted) table name results in a token recognition error

PreparedStatement pstmt = con.prepareStatement("INSERT INTO \"IDENTITY TABLE\" (theValue) VALUES (?)", Statement.RETURN_GENERATED_KEYS)

line 1:12 token recognition error at: '"IDENTITY '
line 1:27 token recognition error at: '" '

Note that the insert statement works, but it will not output generated keys.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Rotteveel added a comment - 27/Feb/17 04:02 PM
Added additional tests and committed fix to Jaybird 2.2 and 3.0