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-issue-importer opened this issue Sep 13, 2007 · 5 comments

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 29, 2007

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 3.0.0 [ 10048 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 13, 2007

Modified by: @dyemanov

Fix Version: 2.5 Alpha 1 [ 10224 ]

Fix Version: 3.0.0 [ 10048 ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 28, 2008

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 12, 2009

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 19, 2016

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
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant