Nested case results in message: "Predicate CASE 42: time to implement some more"

[monetdb-team]

Date: 2011-07-18 09:41:26 +0200
From: Alfred Nordman <<alfred.nordman>>
To: SQL devs <>
Version: 11.3.7 (Apr2011-SP2) [obsolete]
CC: alfred.nordman, @njnes

Last updated: 2011-09-16 15:04:36 +0200

Comment 15963

Date: 2011-07-18 09:41:26 +0200
From: Alfred Nordman <<alfred.nordman>>

Entering the following SQL sequence doesn't return a result:

CREATE TABLE t (c int);
INSERT INTO t VALUES (1);
SELECT CASE WHEN CASE t.c WHEN 3 THEN TRUE ELSE FALSE END THEN 5 ELSE 7 END FROM t;

Instead, a message is printed:
"Predicate CASE 42: time to implement some more"

Comment 15990

Date: 2011-07-27 20:19:48 +0200
From: @njnes

implemented the fallback for 'value expression' which are used as logical predicates, ie compute value and compare with true. Added test recursive_case.Bug-2838.sql

Comment 15991

Date: 2011-07-27 20:31:03 +0200
From: @njnes

Changeset a8f20d4e65ff made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=a8f20d4e65ff

Changeset description:

fix for Bug #2838 (ie handle case expression in condition part of a
case expression)

Comment 16046

Date: 2011-07-29 11:03:53 +0200
From: @sjoerdmullender

Apr2011-SP2 has been released.

Comment 16245

Date: 2011-09-16 15:04:36 +0200
From: @sjoerdmullender

The Aug2011 version has been released.