[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