[FRG-277] parser does not accept subquery in WHEN clause of CASE

LucidDB / luciddb

DEFUNCT: See README

https://github.com/LucidDB/luciddb

Apache License 2.0

53 stars 24 forks source link

[FRG-277] parser does not accept subquery in WHEN clause of CASE #595

Closed dynamobi-build closed 12 years ago

dynamobi-build commented 12 years ago

[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)

dynamobi-build commented 12 years ago

[author="zfong", created="Wed, 19 Mar 2008 20:39:30 -0500 (GMT-05:00)"] Fixed in lcs branch in Eigenchange 10734.

dynamobi-build commented 12 years ago

[author="zfong", created="Tue, 8 Apr 2008 16:08:52 -0500 (GMT-05:00)"] Changes integrated to lu/dev in Eigenchange 10838.