You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I am using Jaybird 2.2.7
I was trying to use
UPDATE ... RETURNING....
I used
"....
ResultSet rset = statement.executeQuery();
boolean test=rset.next();
.."
I expected test to be false in the case that update
does not affect any rows.
This differs from the PostgresSQL behaviour which I think is correct.
The text was updated successfully, but these errors were encountered:
I am not sure if I can fix this. UPDATE ... RETURNING ... and friends are treated as executable procedures in Firebird (and because of that it can only be used for singleton updates). The way these are executed always produces a row, even when nothing was updated and the row is empty (all null).
I initially thought to check the update count, but that is not possible because for example actual executable procedures (which are indiscernible from UPDATE ... RETURNING ...) might have a zero update count even though they produce a result.
I will check with the core developers if I am missing an option.
Submitted by: Wiesław Poszewiecki (wiesiek)
I am using Jaybird 2.2.7
I was trying to use
UPDATE ... RETURNING....
I used
"....
ResultSet rset = statement.executeQuery();
boolean test=rset.next();
.."
I expected test to be false in the case that update
does not affect any rows.
This differs from the PostgresSQL behaviour which I think is correct.
The text was updated successfully, but these errors were encountered: