Update of /cvsroot/monetdb/sql/src/test
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv16351
Modified Files:
rank.sql
Log Message:
Avoid tests that are dependent on the catalog size.
Output to be approved.
U rank.sql
Index: rank.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/rank.sql,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -d -r1.3 -r1.4
--- rank.sql 25 Feb 2008 22:28:00 -0000 1.3
+++ rank.sql 6 Jun 2009 11:01:49 -0000 1.4
@@ -1,19 +1,65 @@
-select ROW_NUMBER() over () as foo from tables;
-select ROW_NUMBER() over (PARTITION BY schema_id) as foo, schema_id from
tables;
-select ROW_NUMBER() over (PARTITION BY schema_id ORDER BY schema_id) as foo,
schema_id from tables;
-select ROW_NUMBER() over (ORDER BY schema_id) as foo, schema_id from tables;
+create table ranktest ( id int, k string);
+COPY 40 RECORDS INTO ranktest FROM stdin USING DELIMITERS '|','\n';
+1061|varchar
+1061|int
+1061|varchar
+1061|varchar
+1061|int
+1061|int
+1061|varchar
+1061|varchar
+1061|boolean
+1061|boolean
+1061|int
+1061|varchar
+1061|bigint
+1061|bigint
+1061|bigint
+1061|boolean
+1061|int
+1061|smallint
+1061|int
+1061|char
+1062|int
+1062|char
+1062|char
+1062|int
+1062|varchar
+1062|int
+1062|varchar
+1062|smallint
+1062|boolean
+1062|smallint
+1062|int
+1062|varchar
+1062|boolean
+1061|int
+1061|int
+1061|varchar
+1061|int
+1061|int
+1061|smallint
+1061|smallint
-select RANK() over () as foo from tables;
-select RANK() over (PARTITION BY schema_id) as foo, schema_id from tables;
-select RANK() over (PARTITION BY schema_id ORDER BY schema_id) as foo,
schema_id from tables;
-select RANK() over (ORDER BY schema_id) as foo, schema_id from tables;
+select count(*) from ranktest;
-select RANK() over () as foo, name, "type" from columns;
-select RANK() over (PARTITION BY name) as foo, name, "type" from columns;
-select RANK() over (PARTITION BY name ORDER BY name, "type") as foo, name,
"type" from columns;
-select RANK() over (ORDER BY name, "type") as foo, name, "type" from columns;
+select ROW_NUMBER() over () as foo from ranktest;
+select ROW_NUMBER() over (PARTITION BY id) as foo, id from ranktest;
+select ROW_NUMBER() over (PARTITION BY id ORDER BY id) as foo, id from
ranktest;
+select ROW_NUMBER() over (ORDER BY id) as foo, id from ranktest;
-select DENSE_RANK() over () as foo, name, "type" from columns;
-select DENSE_RANK() over (PARTITION BY name) as foo, name, "type" from columns;
-select DENSE_RANK() over (PARTITION BY name ORDER BY name, "type") as foo,
name, "type" from columns;
-select DENSE_RANK() over (ORDER BY name, "type") as foo, name, "type" from
columns;
+select RANK() over () as foo from ranktest;
+select RANK() over (PARTITION BY id) as foo, id from ranktest;
+select RANK() over (PARTITION BY id ORDER BY id) as foo, id from ranktest;
+select RANK() over (ORDER BY id) as foo, id from ranktest;
+
+select RANK() over () as foo, name, k from ranktest;
+select RANK() over (PARTITION BY name) as foo, name, k from ranktest;
+select RANK() over (PARTITION BY name ORDER BY name, k) as foo, name, k from
ranktest;
+select RANK() over (ORDER BY name, k) as foo, name, k from ranktest;
+
+select DENSE_RANK() over () as foo, name, k from ranktest;
+select DENSE_RANK() over (PARTITION BY name) as foo, name, k from ranktest;
+select DENSE_RANK() over (PARTITION BY name ORDER BY name, k) as foo, name, k
from ranktest;
+select DENSE_RANK() over (ORDER BY name, k) as foo, name, k from ranktest;
+drop table ranktest;
------------------------------------------------------------------------------
OpenSolaris 2009.06 is a cutting edge operating system for enterprises
looking to deploy the next generation of Solaris that includes the latest
innovations from Sun and the OpenSource community. Download a copy and
enjoy capabilities such as Networking, Storage and Virtualization.
Go to: http://p.sf.net/sfu/opensolaris-get
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
