Changeset: c723ea6fb21f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c723ea6fb21f Added Files: sql/test/BugTracker-2020/Tests/select-and.Bug-6878.sql Modified Files: sql/test/BugTracker-2020/Tests/All Branch: Jun2020 Log Message:
Added test for bug 6878 diffs (34 lines): diff --git a/sql/test/BugTracker-2020/Tests/All b/sql/test/BugTracker-2020/Tests/All --- a/sql/test/BugTracker-2020/Tests/All +++ b/sql/test/BugTracker-2020/Tests/All @@ -9,3 +9,4 @@ window-order-by-extract.Bug-6828 ntile-wrong-results.Bug-6829 HAVE_PYMONETDB?global_table_propagation.Bug-6846 ilike-matches.Bug-6864 +select-and.Bug-6878 diff --git a/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.sql b/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/select-and.Bug-6878.sql @@ -0,0 +1,21 @@ +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); +INSERT INTO temp_table VALUES (0.17424371009,0.2865480811,12.5,18.5); +INSERT INTO temp_table VALUES (0.2865480811,0.7201958679,18.5,24.75); +INSERT INTO temp_table VALUES (0.7201958679,1.0,24.75,31.0); +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 + +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; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
