Changeset: ab4438aa9308 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=ab4438aa9308 Modified Files: sql/test/BugTracker-2012/Tests/algebra_find.Bug-2728.sql sql/test/BugTracker-2012/Tests/row_number_does_not_work_in_complex_query.Bug-2805.stable.out Branch: Oct2012 Log Message:
teest 2728 cleanup tables approved output diffs (21 lines): diff --git a/sql/test/BugTracker-2012/Tests/algebra_find.Bug-2728.sql b/sql/test/BugTracker-2012/Tests/algebra_find.Bug-2728.sql --- a/sql/test/BugTracker-2012/Tests/algebra_find.Bug-2728.sql +++ b/sql/test/BugTracker-2012/Tests/algebra_find.Bug-2728.sql @@ -29,3 +29,5 @@ insert into kvk values (1, 'test', 1, 0, select count(*) from vve, kvk where toevoeging is null and vve.huisnummer is not null and vve.postcode = kvk.postcode and kvk.adres like ' %'||vve.huisnummer; +drop table kvk; +drop table vve; diff --git a/sql/test/BugTracker-2012/Tests/row_number_does_not_work_in_complex_query.Bug-2805.stable.out b/sql/test/BugTracker-2012/Tests/row_number_does_not_work_in_complex_query.Bug-2805.stable.out --- a/sql/test/BugTracker-2012/Tests/row_number_does_not_work_in_complex_query.Bug-2805.stable.out +++ b/sql/test/BugTracker-2012/Tests/row_number_does_not_work_in_complex_query.Bug-2805.stable.out @@ -254,7 +254,7 @@ Ready. [ 1 ] #with Raw as (select a,b,c,count(*) as value from T where e<10 and c<50 group by a,b,c) select Raw.*, row_number() over (partition by a order by value desc) from Raw; % sys.raw, sys.raw, sys.raw, sys.raw, . # table_name -% a, b, c, value, row_number_value # name +% a, b, c, value, row_number_a # name % int, int, int, wrd, int # type % 1, 1, 1, 1, 1 # length [ 7, 7, 7, 1, 1 ] _______________________________________________ checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
