Update of /cvsroot/monetdb/sql/src/test/bugs/Tests
In directory
sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv15058/src/test/bugs/Tests
Added Files:
in_or_bug.sql
Log Message:
propagated changes of Wednesday Mar 10 2010 - Monday Mar 15 2010
from the Feb2010 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2010/03/10 - nielsnes: src/test/bugs/Tests/in_or_bug.sql,1.1.2.1
add test for bug in in with or processing
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: in_or_bug.sql ---
CREATE TABLE "sys"."t1" ("c1" varchar(3),"c2" varchar(3), "c3" varchar(3));
insert into t1 values (1,2,3);
insert into t1 values (3,2,1);
select count(*) from t1 where c1='1' and (c2='3' or c3='3');
select count(*) from t1 where c1='1' and (c2 in ('3') or c3 in ('3'));
drop table t1;
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
