Changeset: 7453aeba321d for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7453aeba321d Added Files: sql/test/VOC/Tests/double_is_null.Bug-3116.test sql/test/VOC/Tests/median.Bug-3096.test Branch: mtest Log Message:
Added missing VOC directory test files diffs (85 lines): diff --git a/sql/test/VOC/Tests/double_is_null.Bug-3116.test b/sql/test/VOC/Tests/double_is_null.Bug-3116.test new file mode 100644 --- /dev/null +++ b/sql/test/VOC/Tests/double_is_null.Bug-3116.test @@ -0,0 +1,35 @@ +statement ok +CREATE TABLE "voyages" ( + "number" integer NOT NULL, + "number_sup" char(1) NOT NULL, + "trip" integer, + "trip_sup" char(1), + "boatname" varchar(50), + "master" varchar(50), + "tonnage" integer, + "type_of_boat" varchar(30), + "built" varchar(15), + "bought" varchar(15), + "hired" varchar(15), + "yard" char(1), + "chamber" char(1), + "departure_date" date, + "departure_harbour" varchar(30), + "cape_arrival" date, + "cape_departure" date, + "cape_call" boolean, + "arrival_date" date, + "arrival_harbour" varchar(30), + "next_voyage" integer, + "particulars" varchar(530) +) + +query TI rowsort +SELECT hired, count(*) FROM voyages WHERE true AND hired IS NOT NULL AND +hired is not null GROUP BY hired ORDER BY hired +---- + +statement ok +drop table voyages + + diff --git a/sql/test/VOC/Tests/median.Bug-3096.test b/sql/test/VOC/Tests/median.Bug-3096.test new file mode 100644 --- /dev/null +++ b/sql/test/VOC/Tests/median.Bug-3096.test @@ -0,0 +1,40 @@ +statement ok +CREATE TABLE "voyages" ( + "number" integer NOT NULL, + "number_sup" char(1) NOT NULL, + "trip" integer, + "trip_sup" char(1), + "boatname" varchar(50), + "master" varchar(50), + "tonnage" integer, + "type_of_boat" varchar(30), + "built" varchar(15), + "bought" varchar(15), + "hired" varchar(15), + "yard" char(1), + "chamber" char(1), + "departure_date" date, + "departure_harbour" varchar(30), + "cape_arrival" date, + "cape_departure" date, + "cape_call" boolean, + "arrival_date" date, + "arrival_harbour" varchar(30), + "next_voyage" integer, + "particulars" varchar(530) +) + +query T rowsort +select median(departure_date) - min(departure_date) from voyages +---- +NULL + +query T rowsort +select max(departure_date) - min(departure_date) from voyages +---- +NULL + +statement ok +drop table voyages + + _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
