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

UPDATE OR INSERT with RETURNING causes "Invalid Cursor" error [CORE3203] #3577

Closed
firebird-issue-importer opened this issue Oct 28, 2010 · 13 comments

Comments

@firebird-issue-importer

Submitted by: Rodrigo Coelho (n3rv0u5)

Is related to CORE2903

Attachments:
UpdateOrInsert.rar

When I execute the UPDATE OR INSERT command with RETURNING occurs a "Invalid Cursor" error

Sometimes the command is not execute successfully.

Commits: d15dc50 1ee06e5

====== Test Details ======

Archieve does not contain necessary dll (dbxfb.dll), but even after downloading it launching of `Project1.exe ` produces "unsupported on-disk structure for file C:\TEMP\UPDATEORINSERT-1\UPDATEORINSERT\UPD_OR_INS.FDB; found 11.2, support 11.1". Need backup of that database.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 28, 2010

Commented by: @dyemanov

What is the *exact* error message returned by the server?

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 28, 2010

Modified by: Sean Leyne (seanleyne)

description: When I execute the UPDATE OR INSERT command with RETURNING_VALUES occurs a "Invalid Cursor" error

Sometimes the command is not execute successfully.

Sincerely,
Rodrigo.

=>

When I execute the UPDATE OR INSERT command with RETURNING_VALUES occurs a "Invalid Cursor" error

Sometimes the command is not execute successfully.

summary: UPDATE OR INSERT causes Cursor error => UPDATE OR INSERT with RETURNING_VALUES causes "Invalid Cursor" error

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 28, 2010

Commented by: Rodrigo Coelho (n3rv0u5)

"Invalid Cursor reference
Cursor is not open."

This error is show on Delphi application.

I attached a sample demonstrating it.

Steps to reproduce:

1 - Type an ID and Name;
2 - Click on "It not works";
3 - Click on "It works"

Sincerely,
Rodrigo.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 28, 2010

Modified by: Rodrigo Coelho (n3rv0u5)

Attachment: UpdateOrInsert.rar [ 11805 ]

description: When I execute the UPDATE OR INSERT command with RETURNING_VALUES occurs a "Invalid Cursor" error

Sometimes the command is not execute successfully.

=>

When I execute the UPDATE OR INSERT command with RETURNING occurs a "Invalid Cursor" error

Sometimes the command is not execute successfully.

summary: UPDATE OR INSERT with RETURNING_VALUES causes "Invalid Cursor" error => UPDATE OR INSERT with RETURNING causes "Invalid Cursor" error

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 28, 2010

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 28, 2010

Modified by: @dyemanov

status: Open [ 1 ] => In Progress [ 3 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 28, 2010

Modified by: @dyemanov

Link: This issue is related to CORE2903 [ CORE2903 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 31, 2010

Modified by: @dyemanov

status: In Progress [ 3 ] => Open [ 1 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 31, 2010

Commented by: @dyemanov

Please try the next snapshot build (to appear in a couple of days) and report back. It should be fixed there.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 3, 2010

Commented by: Rodrigo Coelho (n3rv0u5)

OK, the problem was fixed

Thanks,
Rodrigo.

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 3, 2010

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 2.5.1 [ 10333 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 4, 2011

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 19, 2015

Modified by: @pavel-zotov

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

QA Status: Cannot be tested

Test Details: Archieve does not contain necessary dll (dbxfb.dll), but even after downloading it launching of `Project1.exe ` produces "unsupported on-disk structure for file C:\TEMP\UPDATEORINSERT-1\UPDATEORINSERT\UPD_OR_INS.FDB; found 11.2, support 11.1". Need backup of that database.

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
2 participants