Changeset: 84732374fa30 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=84732374fa30 Modified Files: sql/test/BugTracker-2009/Tests/count_bug.SF-2604583.sql sql/test/BugTracker-2009/Tests/count_bug.SF-2604583.stable.out Branch: default Log Message:
Add an order by clause to the query to make the result output stable on testweb. diffs (24 lines): diff --git a/sql/test/BugTracker-2009/Tests/count_bug.SF-2604583.sql b/sql/test/BugTracker-2009/Tests/count_bug.SF-2604583.sql --- a/sql/test/BugTracker-2009/Tests/count_bug.SF-2604583.sql +++ b/sql/test/BugTracker-2009/Tests/count_bug.SF-2604583.sql @@ -2,7 +2,7 @@ create table countt1( a int , b int ) ; insert into countt1 values ( 3, 1 ) , ( 4, 2 ) , ( 5, 3 ) , ( 6, 4 ) , ( 7, 5 ) ; select * from countt1; -select cast( ( select count( * )+1 from countt1 as tt3 where tt3.b < tt2.b ) as bigint) from countt1 as tt2; +select cast( ( select count( * )+1 from countt1 as tt3 where tt3.b < tt2.b ) as bigint) from countt1 as tt2 order by 1; --the result : the last SQL should returns 1,2,3,4,5 , not null,2,3,4,5 drop table countt1; diff --git a/sql/test/BugTracker-2009/Tests/count_bug.SF-2604583.stable.out b/sql/test/BugTracker-2009/Tests/count_bug.SF-2604583.stable.out --- a/sql/test/BugTracker-2009/Tests/count_bug.SF-2604583.stable.out +++ b/sql/test/BugTracker-2009/Tests/count_bug.SF-2604583.stable.out @@ -36,7 +36,7 @@ stdout of test 'count_bug.SF-2604583` in [ 5, 3 ] [ 6, 4 ] [ 7, 5 ] -#select cast( ( select count( * )+1 from countt1 as tt3 where tt3.b < tt2.b ) as bigint) from countt1 as tt2; +#select cast( ( select count( * )+1 from countt1 as tt3 where tt3.b < tt2.b ) as bigint) from countt1 as tt2 order by 1; % . # table_name # .L6 # table_name % L # name _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
