Changeset: 1ea955fc42c0 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=1ea955fc42c0 Added Files: sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.err sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.out Modified Files: sql/test/BugTracker-2020/Tests/select-and.Bug-6878.sql Branch: Jun2020 Log Message:
Approved output diffs (99 lines): diff --git a/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.sql b/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.sql --- a/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.sql +++ b/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.sql @@ -17,5 +17,7 @@ 0.715 0.809 0.504 + +select (temp_table.mmax - temp_table.mmin)+temp_table.mmin from temp_value, temp_table where temp_value.vvalue<=temp_table.norm_max and temp_value.vvalue>temp_table.norm_min; select (0.72/2147483648.0)*(temp_table.mmax - temp_table.mmin)+temp_table.mmin from temp_value, temp_table where temp_value.vvalue<=temp_table.norm_max and temp_value.vvalue>temp_table.norm_min; rollback; diff --git a/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.err b/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.err @@ -0,0 +1,12 @@ +stderr of test 'select-and.Bug-6878` in directory 'sql/test/BugTracker-2020` itself: + + +# 12:06:59 > +# 12:06:59 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-28423" "--port=31728" +# 12:06:59 > + + +# 12:06:59 > +# 12:06:59 > "Done." +# 12:06:59 > + diff --git a/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.out b/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.stable.out @@ -0,0 +1,66 @@ +stdout of test 'select-and.Bug-6878` in directory 'sql/test/BugTracker-2020` itself: + + +# 12:06:59 > +# 12:06:59 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-28423" "--port=31728" +# 12:06:59 > + +#start transaction; +#CREATE TABLE temp_table(norm_min float, norm_max float, mmin float, mmax float); +#INSERT INTO temp_table VALUES (0.0,0.17424371009,6.0,12.25); +[ 1 ] +#INSERT INTO temp_table VALUES (0.17424371009,0.2865480811,12.5,18.5); +[ 1 ] +#INSERT INTO temp_table VALUES (0.2865480811,0.7201958679,18.5,24.75); +[ 1 ] +#INSERT INTO temp_table VALUES (0.7201958679,1.0,24.75,31.0); +[ 1 ] +#CREATE TABLE temp_value(vvalue float); +#COPY 10 RECORDS INTO "sys"."temp_value" FROM stdin USING DELIMITERS E'\t',E'\n','"'; +#0.72 +#0.524 +#0.782 +#0.936 +#0.94 +#0.111 +#0.776 +#0.715 +#0.809 +#0.504 +[ 10 ] +#select (temp_table.mmax - temp_table.mmin)+temp_table.mmin from temp_value, temp_table where temp_value.vvalue<=temp_table.norm_max and temp_value.vvalue>temp_table.norm_min; +% sys.%1 # table_name +% %1 # name +% double # type +% 24 # length +[ 24.75 ] +[ 24.75 ] +[ 31 ] +[ 31 ] +[ 31 ] +[ 12.25 ] +[ 31 ] +[ 24.75 ] +[ 24.75 ] +[ 31 ] +#select (0.72/2147483648.0)*(temp_table.mmax - temp_table.mmin)+temp_table.mmin from temp_value, temp_table where temp_value.vvalue<=temp_table.norm_max and temp_value.vvalue>temp_table.norm_min; +% .%1 # table_name +% %1 # name +% double # type +% 24 # length +[ 18.5 ] +[ 18.5 ] +[ 24.75 ] +[ 24.75 ] +[ 24.75 ] +[ 6 ] +[ 24.75 ] +[ 18.5 ] +[ 18.5 ] +[ 24.75 ] +#rollback; + +# 12:06:59 > +# 12:06:59 > "Done." +# 12:06:59 > + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
