You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
EXECUTE STATEMENT <e> when <e> starts with '--' (comment) issues "-Unexpected end of command - line 1, column <NNN>", value <NNN> is invalid (2.5 ... 4.0) and can change randomly (only in 3.0, 4.0) [CORE5447]
#5718
recreate table test(x int);
commit;
set term ^;
execute block as
declare ddl varchar(128);
begin
ddl = '-- table ''test'' has no trigger, DROP TRIGGER is skipped.';
execute statement ddl;
end
^
set term ;^
Output will be:
### FB 2.5 ###
C:\FBTESTING\OLTP-EMUL\src>C:\FB\25sC\bin\isql /:e25 -i qq.sql
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Unexpected end of command - line 1, column 1676729881
-At block line: 5, col: 3
After line 3 in file qq.sql
For 2nd and subsequent runs:
-Unexpected end of command - line 1, column 1676795417
-Unexpected end of command - line 1, column 1676729881
-Unexpected end of command - line 1, column 1676795417
-Unexpected end of command - line 1, column 1676729881
-Unexpected end of command - line 1, column 1676795417
(then these two numbers are alternated, no more new values)
### FB 4.0 ###
C:\FBTESTING\OLTP-EMUL\src>isql /:e40 -i qq.sql
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Unexpected end of command - line 1, column -106316575
-At block line: 5, col: 3
After line 3 in file qq.sql
For 2nd and subsequent runs:
-Unexpected end of command - line 1, column -100957727
-Unexpected end of command - line 1, column -105479711
-Unexpected end of command - line 1, column -105414175
-Unexpected end of command - line 1, column -105414175
-Unexpected end of command - line 1, column -95387167
-Unexpected end of command - line 1, column -89030175
Submitted by: @pavel-zotov
Run following script several times:
recreate table test(x int);
commit;
set term ^;
execute block as
declare ddl varchar(128);
begin
ddl = '-- table ''test'' has no trigger, DROP TRIGGER is skipped.';
execute statement ddl;
end
^
set term ;^
Output will be:
### FB 2.5 ###
C:\FBTESTING\OLTP-EMUL\src>C:\FB\25sC\bin\isql /:e25 -i qq.sql
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Unexpected end of command - line 1, column 1676729881
-At block line: 5, col: 3
After line 3 in file qq.sql
For 2nd and subsequent runs:
-Unexpected end of command - line 1, column 1676795417
-Unexpected end of command - line 1, column 1676729881
-Unexpected end of command - line 1, column 1676795417
-Unexpected end of command - line 1, column 1676729881
-Unexpected end of command - line 1, column 1676795417
(then these two numbers are alternated, no more new values)
### FB 4.0 ###
C:\FBTESTING\OLTP-EMUL\src>isql /:e40 -i qq.sql
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Unexpected end of command - line 1, column -106316575
-At block line: 5, col: 3
After line 3 in file qq.sql
For 2nd and subsequent runs:
-Unexpected end of command - line 1, column -100957727
-Unexpected end of command - line 1, column -105479711
-Unexpected end of command - line 1, column -105414175
-Unexpected end of command - line 1, column -105414175
-Unexpected end of command - line 1, column -95387167
-Unexpected end of command - line 1, column -89030175
(values of column seems to be changed randomly).
Commits: 32e7474 a8e6309 24d9982 00586d5
The text was updated successfully, but these errors were encountered: