search

LucidDB / luciddb

DEFUNCT: See README
https://github.com/LucidDB/luciddb
Apache License 2.0
52 stars 24 forks source link

[FRG-121] IN cannot handle compound keys #749

Closed dynamobi-build closed 12 years ago

dynamobi-build commented 12 years ago

[reporter="jvs", created="Mon, 1 May 2006 18:20:40 -0500 (GMT-05:00)"] select * from sales.emps where where (empno,deptno) in (110,20)

gives

Error: DDL validation error: Reference to unknown datatype "ROW" (state=,code=0)

(And why is it a DDL validation error?!)

dynamobi-build commented 12 years ago

[author="jvs", created="Sun, 22 Oct 2006 22:15:03 -0500 (GMT-05:00)"] I think you already fixed this one.

dynamobi-build commented 12 years ago

[author="rchen", created="Mon, 23 Oct 2006 15:38:36 -0500 (GMT-05:00)"] Row types are supported for IN operator now. However, the correct syntax should be:

select * from sales.emps where where (empno,deptno) in ((110,20));