Issue Details (XML | Word | Printable)

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

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

BLOB isn't compatible with [VAR]CHAR in COALESCE

Created: 02/Oct/07 11:46 AM   Updated: 07/Oct/08 05:07 AM
Component/s: Engine
Affects Version/s: 2.1 Alpha 1, 2.1 Beta 1, 2.1 Beta 2
Fix Version/s: 2.1 RC1

Time Tracking:
Not Specified

Issue Links:
Relate
 


 Description  « Hide
Test case:

create table t (b blob sub_type text);

insert into t values (NULL);
insert into t values ('test');

select coalesce(b, '') from t;

Statement failed, SQLCODE = -104
SQL error code = -104
-Datatypes are not comparable in expression COALESCE


 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Philippe Makowski added a comment - 07/Oct/08 05:07 AM
Q/A test ok