firebird icon indicating copy to clipboard operation
firebird copied to clipboard

ISQL can not prepare query containing ascii_char(26), issuing "Expected end of statement, encountered EOF"

Open pavel-zotov opened this issue 8 months ago • 3 comments

Consider script (unpack it from attached .zip):

connect '/:employee';
set echo on;
set list on;

select '1←2' from rdb$database;

select '1→2' from rdb$database;
quit;

Run it ( isql -q -i ... ). Output will be:

isql -q -i isql-prepaing-fail.sql
set list on;
select '1←2' from rdb$database;
CONSTANT                        1←2

select '1
Expected end of statement, encountered EOF

isql-prepaing-fail.sql.zip

pavel-zotov avatar Apr 10 '25 12:04 pavel-zotov

I think it's an odd choice to use an unprintable C0 control code in a test.

mrotteveel avatar Apr 10 '25 14:04 mrotteveel

I think it's an odd choice to use an unprintable C0 control code in a test.

Yes, but unprintable control character can be used as delimiter, see https://github.com/FirebirdSQL/firebird/pull/8418#issuecomment-2792461612 (i.e. we have no intention to sent such character to client but we still have to handle it in some parsing etc)

pavel-zotov avatar Apr 10 '25 15:04 pavel-zotov