User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/47.0.2526.106 Safari/537.36
MonetDB doesn't handle ANY/SOME/ALL operator correctly
Steps to Reproduce:
1.create table t1 (f1 int, f2 int); create table t3 (f1 int, f2 int);
2.insert some rows into the 2 tables
3.select * from t1 where f1 > ANY (select f2 from t3);
cardinality violation (11>1)
(SOME/ALL operator got the same result)
return rows in t1 where f1 > any f2 column in t3;
This case works well in other DB, such as PostgreSQL.
the parser already handled the any|more and all syntax. Now in the default branch also the semantics are properly handled. This (somewhat new feature) will be in the release after the Jun2016.
Jul2015-SP4 has been released.