Changeset: a9ebbd5b2e53 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a9ebbd5b2e53 Modified Files: sql/test/BugTracker-2017/Tests/avggroupbysq.Bug-6178.sql sql/test/BugTracker-2017/Tests/avggroupbysq.Bug-6178.stable.out Branch: Dec2016 Log Message:
Update for Bug 6178, issue only appears when using AVG diffs (92 lines): diff --git a/sql/test/BugTracker-2017/Tests/avggroupbysq.Bug-6178.sql b/sql/test/BugTracker-2017/Tests/avggroupbysq.Bug-6178.sql --- a/sql/test/BugTracker-2017/Tests/avggroupbysq.Bug-6178.sql +++ b/sql/test/BugTracker-2017/Tests/avggroupbysq.Bug-6178.sql @@ -6,14 +6,22 @@ COPY 2 RECORDS INTO x FROM STDIN USING D "N907MQ", "N907MQ",191 -SELECT * FROM x; +-- correct result, 191 +SELECT AVG( arr_delay ) FROM x; + +-- wrong result, NULL SELECT tailnum , AVG( arr_delay ) FROM x GROUP BY tailnum; --- these two should be the same?! --- N907MQ|NULL is in the data, hence N907MQ|NULL should also be the result +-- works fine with MIN +SELECT tailnum , MIN( arr_delay ) FROM x GROUP BY tailnum; +-- correct again SELECT tailnum , AVG( arr_delay ) FROM x WHERE tailnum = 'N907MQ' GROUP BY tailnum; + +-- wrong again SELECT * FROM ( SELECT tailnum , AVG( arr_delay ) FROM x GROUP BY tailnum ) AS xxx WHERE tailnum = 'N907MQ'; +-- both work fine with MIN +SELECT tailnum , MIN( arr_delay ) FROM x WHERE tailnum = 'N907MQ' GROUP BY tailnum; +SELECT * FROM ( SELECT tailnum , MIN( arr_delay ) FROM x GROUP BY tailnum ) AS xxx WHERE tailnum = 'N907MQ'; - diff --git a/sql/test/BugTracker-2017/Tests/avggroupbysq.Bug-6178.stable.out b/sql/test/BugTracker-2017/Tests/avggroupbysq.Bug-6178.stable.out --- a/sql/test/BugTracker-2017/Tests/avggroupbysq.Bug-6178.stable.out +++ b/sql/test/BugTracker-2017/Tests/avggroupbysq.Bug-6178.stable.out @@ -64,31 +64,48 @@ Ready. #"N907MQ", #"N907MQ",191 [ 2 ] -#SELECT * FROM x; -% sys.x, sys.x # table_name -% tailnum, arr_delay # name -% clob, int # type -% 6, 3 # length -[ "N907MQ", NULL ] -[ "N907MQ", 191 ] +#SELECT AVG( arr_delay ) FROM x; +% sys.L4 # table_name +% L3 # name +% double # type +% 24 # length +[ 191 ] #SELECT tailnum , AVG( arr_delay ) FROM x GROUP BY tailnum; % sys.x, sys.L4 # table_name % tailnum, L3 # name % clob, double # type % 6, 24 # length -[ "N907MQ", NULL ] +[ "N907MQ", 191 ] +#SELECT tailnum , MIN( arr_delay ) FROM x GROUP BY tailnum; +% sys.x, sys.L4 # table_name +% tailnum, L3 # name +% clob, int # type +% 6, 3 # length +[ "N907MQ", 191 ] #SELECT tailnum , AVG( arr_delay ) FROM x WHERE tailnum = 'N907MQ' GROUP BY tailnum; % sys.x, sys.L4 # table_name % tailnum, L3 # name % clob, double # type % 6, 24 # length -[ "N907MQ", NULL ] +[ "N907MQ", 191 ] #SELECT * FROM ( SELECT tailnum , AVG( arr_delay ) FROM x GROUP BY tailnum ) AS xxx WHERE tailnum = 'N907MQ'; % sys.xxx, sys.xxx # table_name % tailnum, L3 # name % clob, double # type % 6, 24 # length -[ "N907MQ", NULL ] +[ "N907MQ", 191 ] +#SELECT tailnum , MIN( arr_delay ) FROM x WHERE tailnum = 'N907MQ' GROUP BY tailnum; +% sys.x, sys.L4 # table_name +% tailnum, L3 # name +% clob, int # type +% 6, 3 # length +[ "N907MQ", 191 ] +#SELECT * FROM ( SELECT tailnum , MIN( arr_delay ) FROM x GROUP BY tailnum ) AS xxx WHERE tailnum = 'N907MQ'; +% sys.xxx, sys.xxx # table_name +% tailnum, L3 # name +% clob, int # type +% 6, 3 # length +[ "N907MQ", 191 ] # 18:20:39 > # 18:20:39 > "Done." _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
