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

Unexpectedly different text of message for parameterized expression starting from second run [CORE6447] #6680

Closed
firebird-issue-importer opened this issue Nov 17, 2020 · 7 comments

Comments

@firebird-issue-importer

Submitted by: @pavel-zotov

Following statement produces same SQLSTATE but different text of message since 2nd run:

SQL> set sqlda_display on;
SQL> select 1 from rdb$fields where current_timestamp = ? and current_time = ?;
. . .
Statement failed, SQLSTATE = 07002
Dynamic SQL Error
-SQLDA error
-No SQLDA for input values provided <<<<<<<<<<<<<< [ 1 ]

SQL> select 1 from rdb$fields where current_timestamp = ? and current_time = ?;
. . .
Statement failed, SQLSTATE = 07002
Dynamic SQL Error
-SQLDA error
-Wrong number of parameters (expected 2, got 0) <<<<<<<<<<< [ 2 ]

Commits: b1561ff b1c2329 FirebirdSQL/fbt-repository@775a92a

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 17, 2020

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 17, 2020

Commented by: @hvlad

SET SQLDA_DISPLAY setting have no effect at all, the bug is independent on it.
The bug happens with network connections only, i.e. it not affects embedded connections.
I see no harm of it, but it should be fixed of course.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 17, 2020

Modified by: @hvlad

priority: Major [ 3 ] => Minor [ 4 ]

Version: 3.0.6 [ 10889 ]

Version: 3.0.5 [ 10885 ]

Version: 4.0 Beta 1 [ 10750 ]

Version: 3.0.4 [ 10863 ]

Version: 3.0.3 [ 10810 ]

Version: 4.0 Alpha 1 [ 10731 ]

Version: 3.0.2 [ 10785 ]

Version: 3.0.1 [ 10730 ]

Version: 3.0.0 [ 10740 ]

Version: 4.0 Initial [ 10621 ]

Fix Version: 4.0 RC 1 [ 10930 ]

Fix Version: 3.0.8 [ 10960 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 17, 2020

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 18, 2020

Modified by: @pavel-zotov

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

QA Status: No test => Done successfully

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 18, 2020

Modified by: @pavel-zotov

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

@firebird-issue-importer
Copy link
Author

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

Modified by: @dyemanov

summary: SET SQLDA_DISPLAY ON: different text of message for parameterized expression starting from second run => Unexpectedly different text of message for parameterized expression starting from second run

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