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) -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Key: CORE-5447 URL: http://tracker.firebirdsql.org/browse/CORE-5447 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.1, 2.5.6, 4.0 Initial Reporter: Pavel Zotov Priority: Minor 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). -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ Developer Access Program for Intel Xeon Phi Processors Access to Intel Xeon Phi processor-based developer platforms. With one year of Intel Parallel Studio XE. Training and support from Colfax. Order your platform today. http://sdm.link/xeonphi Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel