Unexpected results when integer overflow

[DerZc]

What happens?

Consider the following program:

CREATE TABLE t0(c1 INT8);
INSERT INTO t0(c1) VALUES ((1));

SELECT t0.c1 FROM t0 WHERE (((-1314689763))+((-1947665992))<=((false)));  -- 1

SELECT t0.c1 FROM t0 WHERE (((-1314689763))+((-1947665992))<=( EXISTS(SELECT t0.c1 FROM t0 WHERE false)));  --  0 rows

In the second query, the condition of subquery is FLASE, so these two queries should be equivalent. But these two queries have different results.

I tried this query SELECT ((-1314689763))+((-1947665992)) FROM t0; and get an error message Error: near line 20: Out of Range Error: Overflow in addition of INT32 (-1314689763 + -1947665992)!. I am not sure if the second query didn't catch the integer overflow.

To Reproduce

I build duckdb from the latest commit version eaf5070

OS:

ubuntu 22.04

DuckDB Version:

eaf5070

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

[github-actions]

This issue is stale because it has been open 90 days with no activity. Remove stale label or comment or this will be closed in 30 days.

[github-actions]

This issue was closed because it has been stale for 30 days with no activity.