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

isql linecount facility in scripts goes out of sync after an INPUT command. [CORE1507] #1922

Closed
firebird-automations opened this issue Sep 13, 2007 · 5 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Claudio Valderrama C. (robocop)

Assigned to: Claudio Valderrama C. (robocop)

When running a script, isql v2.X has a feature that tries to identify the line of an error, relative to the script, since FB error messages are relative to each command. The typical output is
-At line L, column C -> end of translated message from the server
At line SL in file <script_filename>
This is even more useful when running nested scripts, namely some scripts than in turn have INPUT commands that load other scripts.

This is an example of the current failure. The db used is irrelevant, since we need any db to query for something that doesn't exist:
F:\fb2dev\fbbuild\firebird2\temp\debug\firebird\bin>isql qi.fdb -i i1.txt
Statement failed, SQLCODE = -204
Dynamic SQL Error
-SQL error code = -204
-Table unknown
-CATS
-At line 1, column 15
At line 1 in file i5.txt
Statement failed, SQLCODE = -204
Dynamic SQL Error
-SQL error code = -204
-Table unknown
-CATS
-At line 2, column 2
At line 2 in file i1.txt <-----

In the second case, the error should be:
Statement failed, SQLCODE = -204
Dynamic SQL Error
-SQL error code = -204
-Table unknown
-CATS
-At line 2, column 2
At line 4 in file i1.txt <------

The sample scripts follow.

i1.txt is:
input
i5.txt;
select 0 from
cats;

i5.txt is:
select 0 from cats; <no newline at the end>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 3.0.0 [ 10048 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 2.5 Alpha 1 [ 10224 ]

Fix Version: 3.0.0 [ 10048 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 13272 ] => Firebird [ 13995 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

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