SELECT statements are processed for getGeneratedKeys by appending RETURNING (+ all columnnames) [JDBC391] #433
Labels
affect-version: Jaybird 2.2
affect-version: Jaybird 2.2.1
affect-version: Jaybird 2.2.2
affect-version: Jaybird 2.2.3
affect-version: Jaybird 2.2.4
affect-version: Jaybird 2.2.5
affect-version: Jaybird 2.2.6
affect-version: Jaybird 2.2.7
component: jdbc driver
fix-version: Jaybird 2.2.8
fix-version: Jaybird 3.0.0
priority: critical
resolution: fixed
type: bug
Submitted by: @mrotteveel
The generated keys implementation assumes that the parser throws an exception on SELECT queries, and would then proceed executing the query normally. Unfortunately the parser doesn't throw an exception on a SELECT, and instead it processes the query by appending `RETURNING` + all columns in the database (which seems to be another bug in and of itself).
There are currently no tests that check the assumption that SELECT is treated unmodified.
See http://stackoverflow.com/questions/29752184/query-error-using-firebird-rdbms-with-coldfusion-11
Commits: ab19e0c 4ccd923 845ea7b 047825d 91e0013 9573cae d082495 15c8aeb FirebirdSQL/fbt-repository@fff75aa FirebirdSQL/fbt-repository@74b8e4f
The text was updated successfully, but these errors were encountered: