Changeset: 7e360c6915c8 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7e360c6915c8 Modified Files: sql/test/BugTracker-2010/Tests/join_problem.Bug-2694.sql Branch: default Log Message:
Terrible hack to circumvent mitosis-induced rounding errors. diffs (21 lines): diff --git a/sql/test/BugTracker-2010/Tests/join_problem.Bug-2694.sql b/sql/test/BugTracker-2010/Tests/join_problem.Bug-2694.sql --- a/sql/test/BugTracker-2010/Tests/join_problem.Bug-2694.sql +++ b/sql/test/BugTracker-2010/Tests/join_problem.Bug-2694.sql @@ -53,7 +53,7 @@ INSERT INTO time( data_id, header_id, da select t1.opr_date, t1.opr_hr, t1.svalue, t1.yyyymmddhh - t2.avg_yyyymmddhh from time t1 left join -- works -(select extract(year from opr_date) as y, extract(month from opr_date) as m, svalue, avg(yyyymmddhh) as avg_yyyymmddhh from time group by y, m, svalue) as t2 +(select extract(year from opr_date) as y, extract(month from opr_date) as m, svalue, cast(cast(avg(yyyymmddhh) as decimal(14,4)) as double) as avg_yyyymmddhh from time group by y, m, svalue) as t2 on extract(year from t1.opr_date) = t2.y and extract(month from t1.opr_date) = t2.m and t1.svalue = t2.svalue @@ -62,7 +62,7 @@ order by t1.opr_hr; select t1.opr_date, t1.opr_hr, t1.svalue, t1.yyyymmddhh - t2.avg_yyyymmddhh from time t1 join -- crashes (assertion fails) -(select extract(year from opr_date) as y, extract(month from opr_date) as m, svalue, avg(yyyymmddhh) as avg_yyyymmddhh from time group by y, m, svalue) as t2 +(select extract(year from opr_date) as y, extract(month from opr_date) as m, svalue, cast(cast(avg(yyyymmddhh) as decimal(14,4)) as double) as avg_yyyymmddhh from time group by y, m, svalue) as t2 on extract(year from t1.opr_date) = t2.y and extract(month from t1.opr_date) = t2.m and t1.svalue = t2.svalue _______________________________________________ checkin-list mailing list checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list
