Update of /cvsroot/monetdb/sql/src/server
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv3481/src/server
Modified Files:
sql_optimize.mx
Log Message:
propagated changes of Thursday Jul 10 2008 - Monday Jul 14 2008
from the SQL_2-24 branch to the development trunk
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
2008/07/10 - nielsnes: src/server/sql_optimize.mx,1.92.2.3
fixed support for IS NULL in selection
fixed bug in groupby and selection with constants (old bin alg only)
fixed bug in range join rewrites
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Index: sql_optimize.mx
===================================================================
RCS file: /cvsroot/monetdb/sql/src/server/sql_optimize.mx,v
retrieving revision 1.94
retrieving revision 1.95
diff -u -d -r1.94 -r1.95
--- sql_optimize.mx 23 Jun 2008 14:32:10 -0000 1.94
+++ sql_optimize.mx 14 Jul 2008 07:57:08 -0000 1.95
@@ -1241,12 +1241,14 @@
stmt_reverse(stmt_dup(o2->op2.stval)),
cmp);
} else {
+ /* we need to swap compare */
+ if (cmp == 1 || cmp == 2)
+ cmp = 3-cmp;
s = stmt_join2(
stmt_reverse(stmt_dup(o1->op2.stval)),
- /* we need to swap order too */
stmt_dup(o2->op1.stval),
stmt_dup(o1->op1.stval),
- 3-cmp);
+ cmp);
}
stmt_destroy(o1);
stmt_destroy(o2);
-------------------------------------------------------------------------
Sponsored by: SourceForge.net Community Choice Awards: VOTE NOW!
Studies have shown that voting for your favorite open source project,
along with a healthy diet, reduces your potential for chronic lameness
and boredom. Vote Now at http://www.sourceforge.net/community/cca08
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
