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
UNION vs UTF8 literals : arithmetic exception is thrown [CORE1126] #1547
Comments
Modified by: @dyemanovdescription: SELECT _UTF8 'Z' FROM RDB$DATABASE throws isc_arith_except. But it works OK if a collation is explicitly specified: SELECT _UTF8 'Z' COLLATE UNICODE FROM RDB$DATABASE => SELECT _UTF8 'Z' FROM RDB$DATABASE throws isc_arith_except. But it works OK if a collation is explicitly specified: SELECT _UTF8 'Z' COLLATE UNICODE FROM RDB$DATABASE summary: ORDER BY vs UTF8 literals : arithmetic exception is thrown => UNION vs UTF8 literals : arithmetic exception is thrown |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.0.1 [ 10090 ] Fix Version: 2.1 [ 10041 ] |
Commented by: @pmakowski Q/A test made and ok |
Modified by: @pmakowskistatus: Resolved [ 5 ] => Closed [ 6 ] |
Commented by: @pcisar Reopened to update ticket information. |
Modified by: @pcisarWorkflow: jira [ 11592 ] => Firebird [ 15457 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovQA Status: No test => Done successfully |
Submitted by: @dyemanov
SELECT _UTF8 'Z' FROM RDB$DATABASE
UNION ALL
SELECT _UTF8 'A' FROM RDB$DATABASE
throws isc_arith_except. But it works OK if a collation is explicitly specified:
SELECT _UTF8 'Z' COLLATE UNICODE FROM RDB$DATABASE
UNION ALL
SELECT _UTF8 'A' COLLATE UNICODE FROM RDB$DATABASE
Commits: bb68ec8 a57d797
The text was updated successfully, but these errors were encountered: