Changeset: 90a3e165d27d for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=90a3e165d27d Modified Files: sql/test/BugTracker-2014/Tests/case-sqrt.Bug-3627.stable.err sql/test/BugTracker-2014/Tests/case-sqrt.Bug-3627.stable.out Branch: default Log Message:
keep correct output diffs (58 lines): diff --git a/sql/test/BugTracker-2014/Tests/case-sqrt.Bug-3627.stable.err b/sql/test/BugTracker-2014/Tests/case-sqrt.Bug-3627.stable.err --- a/sql/test/BugTracker-2014/Tests/case-sqrt.Bug-3627.stable.err +++ b/sql/test/BugTracker-2014/Tests/case-sqrt.Bug-3627.stable.err @@ -30,22 +30,6 @@ stderr of test 'case-sqrt.Bug-3627` in d # 15:36:03 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-29576" "--port=33717" # 15:36:03 > -MAPI = (monetdb) /var/tmp/mtest-17200/.s.monetdb.32363 -QUERY = SELECT t0.id - ,t0.colint - ,t0.sqrt_colint - FROM (SELECT id - ,colint - ,CASE WHEN colint < 0 - THEN SQRT(-1 * colint) - ELSE SQRT(colint) - END AS sqrt_colint - FROM t1 - ) t0 - ; -ERROR = !Math exception: Numerical argument out of domain - - # 15:36:03 > # 15:36:03 > "Done." # 15:36:03 > diff --git a/sql/test/BugTracker-2014/Tests/case-sqrt.Bug-3627.stable.out b/sql/test/BugTracker-2014/Tests/case-sqrt.Bug-3627.stable.out --- a/sql/test/BugTracker-2014/Tests/case-sqrt.Bug-3627.stable.out +++ b/sql/test/BugTracker-2014/Tests/case-sqrt.Bug-3627.stable.out @@ -60,6 +60,28 @@ Ready. [ 5 ] #SELECT t0.id # ,t0.colint +# ,t0.sqrt_colint +# FROM (SELECT id +# ,colint +# ,CASE WHEN colint < 0 +# THEN SQRT(-1 * colint) +# ELSE SQRT(colint) +# END AS colint_sq +# FROM t1 +# ) t0 +#; +% sys.t0, sys.t0, sys.L # table_name +% id, colint, sqrt_colint_sq # name +% int, int, double # type +% 1, 2, 24 # length +[ 1, -2, 1.414213562 ] +[ 2, -1, 1 ] +[ 3, 0, 0 ] +[ 4, 1, 1 ] +[ 5, 2, 1.414213562 ] + +#SELECT t0.id +# ,t0.colint # ,SQRT(t0.colint_sq) # FROM (SELECT id # ,colint _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
