Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory
23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv17322/src/test/BugTracker-2009/Tests
Modified Files:
Tag: Aug2009
All
Added Files:
Tag: Aug2009
semijoin_bug.SF-2869818.sql
Log Message:
add test and fixed bug in IN handling
U All
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/All,v
retrieving revision 1.37.2.27
retrieving revision 1.37.2.28
diff -u -d -r1.37.2.27 -r1.37.2.28
--- All 1 Oct 2009 20:32:47 -0000 1.37.2.27
+++ All 5 Oct 2009 20:43:28 -0000 1.37.2.28
@@ -103,6 +103,7 @@
updating_non-loaded_columns.SF-2864313_KO-2
updating_non-loaded_columns.SF-2864313_KO-3
updating_non-loaded_columns.SF-2864313_OK-4
+semijoin_bug.SF-2869818.sql
#
# The following test currently crashes and this fact (or its remains) might
# harm sub-sequent tests; hence, this test should be last in this directory.
--- 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
);
explain 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
