ISQL: different behaviour when 'SET BAIL' contains typo

7 views
Skip to first unread message

Pavel Zotov

unread,
Jul 2, 2026, 5:06:03 PM (5 days ago) Jul 2
to firebird-devel
Consider script:
============
set bail on;
set heading off;
connect 'localhost:employee' user 'sysdba' password 'masterkey';

select 'point-0' as msg from rdb$database;
set bail off:
select 'point-1' as msg from rdb$database;
set bail off;
select 'point-2' as msg from rdb$database;

============
(NOTE: second line with 'set bail off' (after select 'point-0' ... ) ends with COLON character rather than `;`

For all 3.x ... 5.x and up to 6.0.0.565-5fc5969 this script output is:
============
select 'point-0' as msg from rdb$database;

point-0

set bail off:
select 'point-1' as msg from rdb$database;
Command error: set bail off: select 'point-1' as msg from rdb$database

============

Since 6.0.0.570-c3c8dd9 (built 30-dec-2024 20:16 +0000) this script shows:
============
select 'point-0' as msg from rdb$database;

point-0

set bail off:
select 'point-1' as msg from rdb$database;
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, column 5
-bail

============

I'm not sure whether this is regression or no, want just to inform all involved.



Reply all
Reply to author
Forward
0 new messages