Changeset: 6cc0ad3e009b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/6cc0ad3e009b Modified Files: sql/test/SQLancer/Tests/sqlancer17.test Branch: Jan2022 Log Message:
Issue with min/max propagation with inserts and deletes. I am going to leave the test for now diffs (31 lines): diff --git a/sql/test/SQLancer/Tests/sqlancer17.test b/sql/test/SQLancer/Tests/sqlancer17.test --- a/sql/test/SQLancer/Tests/sqlancer17.test +++ b/sql/test/SQLancer/Tests/sqlancer17.test @@ -415,3 +415,27 @@ UPDATE t2 SET c0 = 1 FROM t0 WHERE (leas statement ok ROLLBACK +statement ok +CREATE TABLE t2(c0 INTERVAL DAY) + +statement ok rowcount 1 +INSERT INTO t2(c0) VALUES(INTERVAL '3' DAY) + +statement ok rowcount 1 +DELETE FROM t2 WHERE TRUE + +statement error types tinyint(1,0) and day_interval(4,0) are not equal +INSERT INTO t2(c0) VALUES(1) + +statement ok rowcount 2 +INSERT INTO t2(c0) VALUES(INTERVAL '2' DAY), (INTERVAL '1' DAY) + +query T rowsort +SELECT c0 FROM t2 +---- +1 +2 + +statement ok +DROP TABLE t2 + _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
