Changeset: 08e52f8cff56 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=08e52f8cff56 Modified Files: sql/src/test/Tests/marcin2.stable.out sql/src/test/marcin2.sql Branch: Oct2010 Log Message:
omit unordered column from result to avoid ambiguous output order diffs (80 lines): diff -r d649e349472f -r 08e52f8cff56 sql/src/test/Tests/marcin2.stable.out --- a/sql/src/test/Tests/marcin2.stable.out Sat Oct 30 12:08:27 2010 +0200 +++ b/sql/src/test/Tests/marcin2.stable.out Sat Oct 30 17:35:11 2010 +0200 @@ -39,33 +39,35 @@ [ 1 ] [ 1 ] [ 1 ] -% sys.t3, sys.t3 # table_name -% id, val # name -% int, int # type -% 1, 1 # length -[ 2, NULL ] -[ 1, NULL ] -[ NULL, NULL ] -[ 2, 5 ] -[ 1, 5 ] -[ NULL, 5 ] -[ 2, 6 ] -[ 1, 6 ] -[ NULL, 6 ] -#select * from t3 order by id; -% sys.t3, sys.t3 # table_name -% id, val # name -% int, int # type -% 1, 1 # length -[ NULL, 5 ] -[ NULL, 6 ] -[ NULL, NULL ] -[ 1, NULL ] -[ 1, 5 ] -[ 1, 6 ] -[ 2, 6 ] -[ 2, NULL ] -[ 2, 5 ] +#commit; +#select val from t3 order by val; +% sys.t3 # table_name +% val # name +% int # type +% 1 # length +[ NULL ] +[ NULL ] +[ NULL ] +[ 5 ] +[ 5 ] +[ 5 ] +[ 6 ] +[ 6 ] +[ 6 ] +#select id from t3 order by id; +% sys.t3 # table_name +% id # name +% int # type +% 1 # length +[ NULL ] +[ NULL ] +[ NULL ] +[ 1 ] +[ 1 ] +[ 1 ] +[ 2 ] +[ 2 ] +[ 2 ] #select * from t3 order by val,id; % sys.t3, sys.t3 # table_name % id, val # name diff -r d649e349472f -r 08e52f8cff56 sql/src/test/marcin2.sql --- a/sql/src/test/marcin2.sql Sat Oct 30 12:08:27 2010 +0200 +++ b/sql/src/test/marcin2.sql Sat Oct 30 17:35:11 2010 +0200 @@ -12,8 +12,8 @@ commit; -- those 2 don't sort (bad server_output?) -select * from t3 order by val; -select * from t3 order by id; +select val from t3 order by val; +select id from t3 order by id; -- but those 2 do select * from t3 order by val,id; _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
