[#CORE-3479] ASCII_VAL raises error instead of return 0 for empty strings

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:

There are no comments yet on this issue.