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 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