Changeset: 697db481ec12 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/697db481ec12 Added Files: sql/test/BugTracker-2023/Tests/insert-delete-insert-crash-7415.test Modified Files: sql/test/BugTracker-2023/Tests/All Branch: Dec2023 Log Message:
Add test for issue 7415. gdk/gdk_heap.c:1161: HEAP_malloc: Assertion `trail == 0 || block > trail' failed. See also analysis https://github.com/MonetDB/MonetDB/issues/7415 diffs (68 lines): diff --git a/sql/test/BugTracker-2023/Tests/All b/sql/test/BugTracker-2023/Tests/All --- a/sql/test/BugTracker-2023/Tests/All +++ b/sql/test/BugTracker-2023/Tests/All @@ -18,3 +18,4 @@ join-on-row_number-over-7403 parse_interval-crash-7412 between-crash-7413 corr-issue-7414 +insert-delete-insert-crash-7415 diff --git a/sql/test/BugTracker-2023/Tests/insert-delete-insert-crash-7415.test b/sql/test/BugTracker-2023/Tests/insert-delete-insert-crash-7415.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2023/Tests/insert-delete-insert-crash-7415.test @@ -0,0 +1,55 @@ +statement ok +CREATE TABLE t1 AS SELECT t1.value AS id, CAST( sys.group_concat( CASE WHEN id.value IS NOT NULL THEN 'DB' ELSE '' END , '') AS BLOB) AS name FROM sys.generate_series(0, 1000) AS t1 LEFT JOIN sys.generate_series(0, 1000) AS id ON id.value < t1.value GROUP BY id ORDER BY id + +query I +select count(*) from t1 +---- +1000 + +statement ok +insert into t1 (select * from t1) + +statement ok +insert into t1 (select * from t1) + +statement ok +insert into t1 (select * from t1) + +statement ok +insert into t1 (select * from t1) + +query I +select count(*) from t1 +---- +16000 + +query I +select count(*) from t1 WHERE id=1 +---- +16 + +statement ok +DELETE FROM t1 WHERE id=1 + +--statement error 42S02!SELECT: no such table 'analytics' +--select nth_value(aa, 1) over (partition by bb) from analytics + +query I +select count(*) from t1 +---- +15984 + +-- the next insert causes a HEAP_malloc: Assertion `trail == 0 || block > trail' failed. in gdk/gdk_heap.c:1161 +statement ok +insert into t1 (select * from t1) + +statement ok +insert into t1 (select * from t1) + +query I +select count(*) from t1 +---- +56610 + +statement ok +DROP TABLE t1 _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
