Changeset: e99282ffc112 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=e99282ffc112 Modified Files: sql/test/BugTracker-2009/Tests/arithmetic-small-values-null.SF-2921310.sql Branch: Dec2011 Log Message:
proper brackets needed as the 'operator precedence rules' of sql are unclear diffs (12 lines): diff --git a/sql/test/BugTracker-2009/Tests/arithmetic-small-values-null.SF-2921310.sql b/sql/test/BugTracker-2009/Tests/arithmetic-small-values-null.SF-2921310.sql --- a/sql/test/BugTracker-2009/Tests/arithmetic-small-values-null.SF-2921310.sql +++ b/sql/test/BugTracker-2009/Tests/arithmetic-small-values-null.SF-2921310.sql @@ -1,7 +1,7 @@ -- http://bugs.monetdb.org/show_bug.cgi?id=2291 -- yields NULL :/ -select (4.4054292 - 4.40572025343667)^2 + (52.0903881 - 52.091375762174)^2; +select ((4.4054292 - 4.40572025343667)^2) + ((52.0903881 - 52.091375762174)^2); -- correct answer select cast((4.4054292 - 4.40572025343667)^2 as double) + cast((52.0903881 - 52.091375762174)^2 as double); _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
