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

Conversion error when using a blob as an argument for the EXCEPTION statement [CORE3761] #4105

Closed
firebird-automations opened this issue Feb 15, 2012 · 13 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Maxim Kuzmin (cybermax)

Relate to QA464

CREATE EXCEPTION CHECK_EXCEPTION 'Check exception';

EXECUTE BLOCK
AS
BEGIN
EXCEPTION CHECK_EXCEPTION
(SELECT LIST('WORD') FROM RDB$DATABASE);
END

Executing this block throws exception:
Overflow occurred during data type conversion.
conversion error from string "BLOB".

Commits: a0672d8 4b38132

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

A bit simplier test case:

EXCEPTION CHECK\_EXCEPTION 
    CAST \('WORD' AS BLOB SUB\_TYPE TEXT\);

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Version: 2.1.4 [ 10361 ]

Version: 2.5.0 [ 10221 ]

Version: 2.0.6 [ 10303 ]

Version: 3.0 Initial [ 10301 ]

Version: 2.1.3 [ 10302 ]

Version: 2.1.2 [ 10270 ]

Version: 2.0.5 [ 10222 ]

Version: 2.1.1 [ 10223 ]

Version: 2.1.0 [ 10041 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Version: 2.0.6 [ 10303 ] =>

Version: 2.0.5 [ 10222 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

summary: Exception when using subquery with LIST for EXCEPTION => Conversion error when using a blob as an argument for the EXCEPTION statement

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Version: 3.0 Initial [ 10301 ] =>

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

Fixed in the v2.1 and v2.5 branches. v3.0 is not affected.

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 2.1.5 [ 10420 ]

Fix Version: 2.5.2 [ 10450 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pmakowski

Link: This issue relate to QA464 [ QA464 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pmakowski

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: Done successfully

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