Conversion from string to number is not standard compliant [CORE1120] #1541
Assignees
Comments
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.1 [ 10041 ] |
Modified by: @pcisarVersion: 2.1.0 [ 10041 ] => |
|
Commented by: @pcisar Fix confirmed for 2.1 Alpha 1. Test added. |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
|
Commented by: @pcisar Reopened to update ticket information. |
Modified by: @pcisarWorkflow: jira [ 11563 ] => Firebird [ 15513 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovQA Status: No test => Done successfully |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Submitted by: @asfernandes
Is related to QA87
Converting a string to number gives different result than converting from number to number:
------------------
SQL> select cast(5.6 as integer) from rdb$database;
============
6
SQL> select cast('5.6' as integer) from rdb$database;
============
5
------------------
And this is accepted without generate error:
------------------
cast('5,6' as integer),
cast('5,6,7 8 9' as integer)
------------------
Commits: a86bf29
The text was updated successfully, but these errors were encountered: