Changeset: d2219fa94709 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d2219fa94709 Modified Files: sql/test/BugTracker-2009/Tests/count_bug.SF-2604583.sql sql/test/BugTracker-2009/Tests/count_bug.SF-2604583.stable.out.int128 Branch: Apr2019 Log Message:
Stabilize ordering. diffs (37 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 ( select count( * )+1 from countt1 as tt3 where tt3.b < tt2.b ) from countt1 as tt2; +select ( select count( * )+1 from countt1 as tt3 where tt3.b < tt2.b ) as cnt from countt1 as tt2 order by cnt; --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.int128 b/sql/test/BugTracker-2009/Tests/count_bug.SF-2604583.stable.out.int128 --- a/sql/test/BugTracker-2009/Tests/count_bug.SF-2604583.stable.out.int128 +++ b/sql/test/BugTracker-2009/Tests/count_bug.SF-2604583.stable.out.int128 @@ -34,16 +34,17 @@ Ready. [ 5, 3 ] [ 6, 4 ] [ 7, 5 ] -#select ( select count( * )+1 from countt1 as tt3 where tt3.b < tt2.b ) from countt1 as tt2; -% .L6 # table_name -% L6 # name +#select ( select count( * )+1 from countt1 as tt3 where tt3.b < tt2.b ) as cnt from countt1 as tt2 order by cnt; +% .L7 # table_name +% cnt # name % hugeint # type % 1 # length +[ 1 ] [ 2 ] [ 3 ] [ 4 ] [ 5 ] -[ 1 ] +#drop table countt1; # 13:45:53 > # 13:45:53 > Done. _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
