Issue Details (XML | Word | Printable)

Key: CORE-6398
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Alexander Peshkov
Reporter: Alexander Peshkov
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Error converting string with hex representation of integer to smallint

Created: 03/Sep/20 04:45 PM   Updated: 04/Sep/20 05:35 AM
Component/s: None
Affects Version/s: 2.5.9, 4.0 Beta 2, 3.0.6
Fix Version/s: 4.0 RC 1

QA Status: Done successfully


 Description  « Hide
SQL> select cast('0x8000' as smallint) from rdb$database;

   CAST
=======
Statement failed, SQLSTATE = 22003
arithmetic exception, numeric overflow, or string truncation
-numeric value is out of range

On the other hand:
SQL> select cast('0x80000000' as int) from rdb$database;

        CAST
============
 -2147483648


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Alexander Peshkov added a comment - 03/Sep/20 04:52 PM
No plans to backport fix to FB3 - it's based on previous changes, not backported and rather big.