[DERBY-3277] CREATE TABLE Test (n BIGINT);SELECT CASE WHEN n > -1 THEN n END FROM Test; FAILS

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 10.2.2.0
• Fix Version/s: 10.3.2.1
• Component/s: SQL

Environment

~ $ java -version; uname -primo
java version "1.6.0_03"
Java(TM) SE Runtime Environment (build 1.6.0_03-b05)
Java HotSpot(TM) 64-Bit Server VM (build 1.6.0_03-b05, mixed mode)
2.6.23-gentoo-r3-6 x86_64 Intel(R) Core(TM)2 Quad CPU Q6600 @ 2.40GHz GenuineIntel GNU/Linux

• Assignee: Unassigned
• Reporter: James Alan Shepherd
• Created: 14/Dec/07 20:11
• Updated: 05/Feb/08 08:42
• Resolved: 04/Feb/08 21:39

Description

ij> CREATE TABLE Test (n BIGINT);
0 rows inserted/updated/deleted
ij> SELECT CASE WHEN n > -1 THEN n END FROM Test;
ERROR 42X89: Types 'BIGINT' and 'CHAR' are not type compatible. Neither type is assignable to the other type.
ij>

fixed in 10.3.2.1, so this is just posted FYI

Issue Links

• duplicates: DERBY-1620 SQL CASE statement returns ERROR 42X89 when including NULL as a return value