Issue Details (XML | Word | Printable)

Key: CORE-3479
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Philippe Makowski
Votes: 0
Watchers: 1
Operations

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

ASCII_VAL raises error instead of return 0 for empty strings

Created: 16/May/11 01:16 PM   Updated: 16/May/12 02:12 PM
Component/s: Engine
Affects Version/s: 2.5.0, 2.1.4
Fix Version/s: 2.5.1, 2.1.5, 3.0 Alpha 1

Time Tracking:
Not Specified

Planning Status: Unspecified


 Description  « Hide
select ascii_val('') from rdb$database;

Firebird 2.5.0

ASCII_VAL
=========
Statement failed, SQLSTATE = 22018
arithmetic exception, numeric overflow, or string truncation
-Cannot transliterate character between character sets

Firebird 2.1.4

ASCII_VAL
=========
Statement failed, SQLCODE = -802
arithmetic exception, numeric overflow, or string truncation
-Cannot transliterate character between character sets
according to RN, it should return 0



 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.