Issue Details (XML | Word | Printable)

Key: JDBC-372
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

Current method of quoting in FBRowUpdater incorrect for dialect 1

Created: 15/Nov/14 10:21 AM   Updated: 30/Dec/14 12:01 PM
Component/s: JDBC driver
Affects Version/s: Jaybird 2.2, Jaybird 2.2.1, Jaybird 2.2.2, Jaybird 2.2.3, Jaybird 2.2.4, Jaybird 2.2.5
Fix Version/s: Jaybird 2.2.6, Jaybird 3.0.0

 Description  « Hide
It looks like the current method of quoting object names in FBRowUpdater is wrong for dialect 1 databases. Test this and fix if necessary.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mark Rotteveel added a comment - 02/Dec/14 07:37 PM - edited
Added test. As expected insertRow(), updateRow() fail and deleteRow() doesn't delete due to quotes (which are not supported in dialect 1). deleteRow() with dialect1 might actually delete the entire table if the value of the primary is a string and is equal to its own name (as the quoted column name is interpreted as a string).

Mark Rotteveel added a comment - 13/Dec/14 02:29 PM
Fixed in 2.2 and 3.0