ISQL: Add "Stop on Error" switch to immediatelly stop script error occurs during execution [CORE4232] #4556
Submitted by: @pavel-zotov
I have a few huge scripts to be handled by ISQL. These scripts contains many EXECUTE BLOCKs delimited by COMMIT statement.
For some test purpoces its needed to stop immediately all of ISQLs if server has been crashed or detected some serious error in database.
The "-b" switch (or the command issued inside ISQL prompt: set bail on) - doesn`t help in such situation:
The text was updated successfully, but these errors were encountered:
Modified by: Sean Leyne (seanleyne)
summary: ISQL: provide switch to immediatelly cancel script containing many 'heavy statements' if database in shutdown or any engine error occured => ISQL: Add "Stop on Error" switch to immediatelly stop script error occurs during execution
Commented by: @pavel-zotov
Now (FB 3.0.x) - yes, the problem exists only in case of few commands in SINGLE line.
I re-run simple test that did not stops in 2.5.x even when `-b` was specified:
And when I run in session #1:
- then issuing in session #2 gfix -shut full - force 0 causes session #1 to immediately to stop:
So, my apologies: this switch DOES work correctly, at leat on FB 3.0.x