Changeset: 354bb2e1939b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=354bb2e1939b Modified Files: monetdb5/modules/mal/manifold.c sql/test/SQLancer/Tests/sqlancer13.test Branch: default Log Message:
The manifold switch on uuid was missing diffs (37 lines): diff --git a/monetdb5/modules/mal/manifold.c b/monetdb5/modules/mal/manifold.c --- a/monetdb5/modules/mal/manifold.c +++ b/monetdb5/modules/mal/manifold.c @@ -101,6 +101,7 @@ typedef struct{ case TYPE_oid: ManifoldLoop(oid,__VA_ARGS__); break; \ case TYPE_flt: ManifoldLoop(flt,__VA_ARGS__); break; \ case TYPE_dbl: ManifoldLoop(dbl,__VA_ARGS__); break; \ + case TYPE_uuid: ManifoldLoop(uuid,__VA_ARGS__); break; \ case TYPE_str: \ default: { \ for (;;) { \ diff --git a/sql/test/SQLancer/Tests/sqlancer13.test b/sql/test/SQLancer/Tests/sqlancer13.test --- a/sql/test/SQLancer/Tests/sqlancer13.test +++ b/sql/test/SQLancer/Tests/sqlancer13.test @@ -202,6 +202,9 @@ statement ok START TRANSACTION statement ok +CREATE TABLE "sys"."t0" ("c2" INTEGER NOT NULL) + +statement ok CREATE TABLE "sys"."t2" ("c7" TINYINT NOT NULL,"c6" UUID,"c5" TIMESTAMP,"c4" BIGINT) statement ok @@ -211,5 +214,12 @@ query I rowsort SELECT 1 FROM t2 JOIN (SELECT 2) AS sub0 (c0) ON (CASE WHEN CAST(2 AS BOOLEAN) THEN NULL END <> t2.c6) ---- +query I rowsort +SELECT CAST(SUM(count) AS BIGINT) FROM (SELECT ALL CAST(NOT ((CASE WHEN TRUE THEN FALSE END) = TRUE) AS INT) as count FROM t2 JOIN +((SELECT ((1)/(round(0.84, 0.7281314))) FROM t0, t2 WHERE CAST(abs(t2.c7) AS BOOLEAN)) EXCEPT ALL (SELECT least("epoch_ms"(TIME '21:17:08'), +CASE WHEN TRUE THEN ((-23)/(t2.c7)) WHEN ((r'1e500')LIKE(r'H')) THEN sql_max(2, 2) WHEN least(TRUE, FALSE) THEN ((t0.c2)%(4)) END) FROM t0, t2 WHERE FALSE)) AS sub0 ON ((CASE WHEN CAST(2 AS BOOLEAN) THEN NULL END)<>(t2.c6))) as res +---- +NULL + statement ok ROLLBACK _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list