Update of /cvsroot/monetdb/sql/src/test
In directory sfp-cvsdas-1.v30.ch3.sourceforge.com:/tmp/cvs-serv11541
Modified Files:
rank.sql setoptimizer.sql
Log Message:
Make them less order dependent.
Index: rank.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/rank.sql,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- rank.sql 6 Jun 2009 14:04:42 -0000 1.5
+++ rank.sql 31 Dec 2009 14:46:32 -0000 1.6
@@ -45,8 +45,8 @@
select RANK() over (PARTITION BY id ORDER BY id, k) as foo, id, k from
ranktest;
select RANK() over (ORDER BY id, k) as foo, id, k from ranktest;
-select DENSE_RANK() over () as foo, id, k from ranktest;
-select DENSE_RANK() over (PARTITION BY id) as foo, id, k from ranktest;
-select DENSE_RANK() over (PARTITION BY id ORDER BY id, k) as foo, id, k from
ranktest;
-select DENSE_RANK() over (ORDER BY id, k) as foo, id, k from ranktest;
+select DENSE_RANK() over () as foo, id, k from ranktest order by k;
+select DENSE_RANK() over (PARTITION BY id) as foo, id, k from ranktest order
by k;
+select DENSE_RANK() over (PARTITION BY id ORDER BY id, k) as foo, id, k from
ranktest order by k;
+select DENSE_RANK() over (ORDER BY id, k) as foo, id, k from ranktest order by
k;
drop table ranktest;
Index: setoptimizer.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/setoptimizer.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- setoptimizer.sql 26 Oct 2009 10:13:01 -0000 1.2
+++ setoptimizer.sql 31 Dec 2009 14:46:32 -0000 1.3
@@ -1,4 +1,5 @@
-- show behavior of optimizer plans
+set optimizer='default_pipe'; -- overrule others
select optimizer;
set optimizer='off';
------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
