dynamobi/dynamobi — Issue #595: [FRG-277] parser does not accept subquery in WHEN clause of CASE
Author: dynamobi-build
Created: 2011-12-30 03:37:28+00:00
State: open
Labels: FRG, SQL Parser

[reporter="jvs", created="Tue, 3 Jul 2007 10:56:58 -0500 (GMT-05:00)"]
0: jdbc:luciddb:> select case when (select count(*) from sys_root.dba_tables)=1 then 2 else 3 end from (values(0));

Error: Query expression encountered in illegal context (state=,code=0)