Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv8112/src/test/BugTracker-2009/Tests
Added Files:
Tag: Nov2009
semijoin_bug.SF-2869818.sql
Log Message:
propagated changes of Monday Oct 05 2009 - Tuesday Oct 06 2009
from the Aug2009 branch to the Nov2009 branch
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/10/05 - nielsnes:
src/test/BugTracker-2009/Tests/semijoin_bug.SF-2869818.sql,1.1.2.1
add test and fixed bug in IN handling
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2009/10/05 - nielsnes:
src/test/BugTracker-2009/Tests/semijoin_bug.SF-2869818.sql,1.1.2.2
add stable output
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--- NEW FILE: semijoin_bug.SF-2869818.sql ---
CREATE TABLE "sys"."kvk" (
"kvk" bigint,
"bedrijfsnaam" varchar(255),
"adres" varchar(64),
"postcode" varchar(6),
"plaats" varchar(32),
"type" varchar(16),
"kvks" int,
"sub" int
);
CREATE TABLE "sys"."concernrelaties" (
"kvk" bigint,
"ouder" varchar(30),
"postcode" varchar(6),
"plaats" varchar(32),
"ouderkvk" int
);
select * from kvk,concernrelaties where upper(bedrijfsnaam) like
'VANAD%' and (kvk.kvk=concernrelaties.kvk or kvk.kvk=ouderkvk) limit 10;
drop table kvk;
drop table concernrelaties;
------------------------------------------------------------------------------
Come build with us! The BlackBerry® Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9-12, 2009. Register now!
http://p.sf.net/sfu/devconf
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
