Changeset: 23d41c408edf for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=23d41c408edf Modified Files: Branch: default Log Message:
Merge with Jun2010 branch. See also bug 2597. diffs (164 lines): diff -r 83cbe43676dc -r 23d41c408edf sql/src/test/Tests/rank.stable.out --- a/sql/src/test/Tests/rank.stable.out Mon Jul 12 12:41:02 2010 +0200 +++ b/sql/src/test/Tests/rank.stable.out Mon Jul 12 15:22:51 2010 +0200 @@ -34,25 +34,7 @@ % sys. # table_name % foo # name % int # type -% 1 # length -[ 1 ] -[ 2 ] -[ 3 ] -[ 4 ] -[ 5 ] -[ 6 ] -[ 1 ] -[ 2 ] -[ 3 ] -[ 4 ] -[ 5 ] -[ 6 ] -[ 1 ] -[ 2 ] -[ 3 ] -[ 4 ] -[ 5 ] -[ 6 ] +% 2 # length [ 1 ] [ 2 ] [ 3 ] @@ -62,6 +44,24 @@ [ 7 ] [ 8 ] [ 9 ] +[ 10 ] +[ 11 ] +[ 12 ] +[ 13 ] +[ 14 ] +[ 15 ] +[ 16 ] +[ 17 ] +[ 18 ] +[ 19 ] +[ 20 ] +[ 21 ] +[ 22 ] +[ 23 ] +[ 24 ] +[ 25 ] +[ 26 ] +[ 27 ] #select ROW_NUMBER() over (PARTITION BY id) as foo, id from ranktest; % ., sys.ranktest # table_name % foo, id # name @@ -159,25 +159,7 @@ % sys. # table_name % foo # name % int # type -% 1 # length -[ 1 ] -[ 2 ] -[ 3 ] -[ 4 ] -[ 5 ] -[ 6 ] -[ 1 ] -[ 2 ] -[ 3 ] -[ 4 ] -[ 5 ] -[ 6 ] -[ 1 ] -[ 2 ] -[ 3 ] -[ 4 ] -[ 5 ] -[ 6 ] +% 2 # length [ 1 ] [ 2 ] [ 3 ] @@ -187,6 +169,24 @@ [ 7 ] [ 8 ] [ 9 ] +[ 10 ] +[ 11 ] +[ 12 ] +[ 13 ] +[ 14 ] +[ 15 ] +[ 16 ] +[ 17 ] +[ 18 ] +[ 19 ] +[ 20 ] +[ 21 ] +[ 22 ] +[ 23 ] +[ 24 ] +[ 25 ] +[ 26 ] +[ 27 ] #select RANK() over (PARTITION BY id) as foo, id from ranktest; % ., sys.ranktest # table_name % foo, id # name @@ -284,34 +284,34 @@ % sys., sys.ranktest, sys.ranktest # table_name % foo, id, k # name % int, int, clob # type -% 1, 4, 8 # length +% 2, 4, 8 # length [ 1, 1061, "varchar" ] [ 2, 1061, "int" ] [ 3, 1061, "varchar" ] [ 4, 1061, "varchar" ] [ 5, 1061, "int" ] [ 6, 1061, "int" ] -[ 1, 1061, "varchar" ] -[ 2, 1061, "varchar" ] -[ 3, 1061, "boolean" ] -[ 4, 1061, "boolean" ] -[ 5, 1061, "int" ] -[ 6, 1061, "varchar" ] -[ 1, 1061, "char" ] -[ 2, 1062, "int" ] -[ 3, 1062, "char" ] -[ 4, 1062, "char" ] -[ 5, 1062, "int" ] -[ 6, 1062, "smallint" ] -[ 1, 1062, "boolean" ] -[ 2, 1062, "smallint" ] -[ 3, 1061, "int" ] -[ 4, 1061, "varchar" ] -[ 5, 1061, "int" ] -[ 6, 1061, "varchar" ] -[ 7, 1061, "int" ] -[ 8, 1061, "int" ] -[ 9, 1061, "smallint" ] +[ 7, 1061, "varchar" ] +[ 8, 1061, "varchar" ] +[ 9, 1061, "boolean" ] +[ 10, 1061, "boolean" ] +[ 11, 1061, "int" ] +[ 12, 1061, "varchar" ] +[ 13, 1061, "char" ] +[ 14, 1062, "int" ] +[ 15, 1062, "char" ] +[ 16, 1062, "char" ] +[ 17, 1062, "int" ] +[ 18, 1062, "smallint" ] +[ 19, 1062, "boolean" ] +[ 20, 1062, "smallint" ] +[ 21, 1061, "int" ] +[ 22, 1061, "varchar" ] +[ 23, 1061, "int" ] +[ 24, 1061, "varchar" ] +[ 25, 1061, "int" ] +[ 26, 1061, "int" ] +[ 27, 1061, "smallint" ] #select RANK() over (PARTITION BY id) as foo, id, k from ranktest; % ., sys.ranktest, sys.ranktest # table_name % foo, id, k # name _______________________________________________ Checkin-list mailing list Checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list
