Update of /cvsroot/monetdb/sql/src/server
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv24744/src/server
Modified Files:
Tag: May2009
rel_bin.mx
Log Message:
fix bug in handling (IN / OR) lists with equal values
U rel_bin.mx
Index: rel_bin.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/server/rel_bin.mx,v
retrieving revision 1.78.2.1
retrieving revision 1.78.2.2
diff -u -d -r1.78.2.1 -r1.78.2.2
--- rel_bin.mx 9 Jun 2009 20:11:27 -0000 1.78.2.1
+++ rel_bin.mx 24 Jul 2009 13:42:51 -0000 1.78.2.2
@@ -230,9 +230,9 @@
s = stmt_append(s, i);
}
c = exp_bin(sql, ce, left, right, grp, NULL);
-// s = stmt_mark_tail(stmt_reverse(stmt_semijoin(stmt_reverse(c),
stmt_reverse(s))), 0);
- /* not really a projection join !! */
- s = stmt_project(c, stmt_reverse(s));
+ //s = stmt_mark_tail(stmt_reverse(stmt_semijoin(stmt_reverse(c),
stmt_reverse(s))), 0);
+ /* not really a projection join, therefor make sure left values are
unique !! */
+ s = stmt_project(c, stmt_reverse(stmt_unique(s, NULL)));
list_destroy(nl);
return s;
------------------------------------------------------------------------------
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
