[fpc-devel] TSQLScript doesn't execute last statement not terminated by '; ' (FTerminator)

Ondrej Pokorny lazarus at kluug.net
Sat Sep 16 21:37:02 CEST 2017


Hello,

if I run this script with TSQLScript:

INSERT INTO A (ID) VALUES (1);
INSERT INTO A (ID) VALUES (2)

Only the first insert is executed. Not the second one - it's ignored 
because it lacks the terminating ';'. Furthermore, no exception is 
raised - so I even don't know about it! IMO it is a bug.

All 3 tools I have installed (pgAdmin for Postgres, SQL Studio for MSSQL 
and SQLDeveloper for Oracle) do not ignore the last unterminated statement.
(Btw. Pascal doesn't either:)
begin
   one;
   two
end;

Should I fix it and send a patch?

MSSQL





More information about the fpc-devel mailing list