Closed
Description
What happens?
The following program triggers a segmentation fault:
CREATE TABLE t0(c0 VARCHAR);
CREATE TABLE t1(c0 DATE);
INSERT INTO t1(c0) VALUES ((TIMESTAMP '1970-01-25 15:59:18'));
INSERT INTO t0(c0) VALUES ((DATE '1969-12-20')), ((TIMESTAMP '1970-01-11 21:25:45')), (DEFAULT), (('1')), (('')), ((TIMESTAMP '1969-12-15 21:35:22'));
CREATE VIEW v0(c0) AS SELECT t1.c0 FROM t1, t0;
SELECT t0.rowid FROM t0, t1 LEFT JOIN v0 ON (1) WHERE t0.c0 >= v0.c0 AND t0.c0 <= v0.c0;
If I remove any value of t0.c0, then can not reproduce this segmentation fault.
And the BETWEEN can also trigger this bug like SELECT t0.rowid FROM t0, t1 LEFT JOIN v0 ON (1) WHERE (t0.c0 BETWEEN v0.c0 AND v0.c0);
To Reproduce
I can reproduce this on the latest commit version 6e908cf
OS:
ubuntu 22.04
DuckDB Version:
DuckDB Client:
CLI
Full Name:
Chi Zhang
Affiliation:
Nanjing University, National University of Singapore
Have you tried this on the latest master branch?
- I agree
Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?
- I agree
Metadata
Metadata
Assignees
Labels
No labels