Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv5073
Modified Files:
All
Added Files:
orIssue.SF-2812504.sql
Log Message:
Added test file for observed misbehavior.
U All
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests/All,v
retrieving revision 1.34
retrieving revision 1.35
diff -u -d -r1.34 -r1.35
--- All 20 Jul 2009 19:04:21 -0000 1.34
+++ All 20 Jul 2009 19:30:32 -0000 1.35
@@ -68,3 +68,5 @@
view-except-limit.SF-2798333
utf8_bug.SF-2822855
reorder.SF-2770608.sql
+orIssue.SF-2812504.sql
+
--- NEW FILE: orIssue.SF-2812504.sql ---
-- implementation limitation on OR semantics
CREATE TABLE "sys"."kvk" (
"kvk" bigint,
"bedrijfsnaam" varchar(255),
"adres" varchar(64),
"postcode" varchar(6),
"plaats" varchar(32),
"type" varchar(16)
);
CREATE TABLE "sys"."anbi" (
"naam" varchar(256),
"vestigingsplaats" varchar(32),
"beschikking" date,
"intrekking" date
);
select * from kvk,anbi where lower(naam) = lower(bedrijfsnaam) and
(vestigingsplaats = 'DEN HAAG' or vestigingsplaats LIKE '%GRAVE%');
------------------------------------------------------------------------------
Enter the BlackBerry Developer Challenge
This is your chance to win up to $100,000 in prizes! For a limited time,
vendors submitting new applications to BlackBerry App World(TM) will have
the opportunity to enter the BlackBerry Developer Challenge. See full prize
details at: http://p.sf.net/sfu/Challenge
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
