Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
firebird-automations opened this issue Jan 11, 2017 · 4 comments

Comments

@firebird-automations
Copy link
Collaborator

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

Fix Version: 3.0.3 [ 10810 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Done successfully

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 3.0.2 [ 10785 ]

Fix Version: 3.0.3 [ 10810 ] =>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment