Details
Description
MariaDB returns an error message: BIGINT value is out of range in '-9223372036854775808 * 1454377110' when performing a SELECT.
However, I didn't directly have -9223372036854775808 * 1454377110 in my SELECT.
Repeat steps:
Create the table:
CREATE TABLE t0 (c_0 INT, c_1 INT, c_2 INT); |
Execute the following query:
SELECT t0.c_1 |
FROM t0 |
WHERE (t0.c_1 = t0.c_0 * t0.c_1 AND t0.c_0 = -9223372036854775808) |
AND t0.c_1 = 1454377110; |
Expected Behavior
The query should return an empty set
Actual Behavior
The query results in an error message: BIGINT value is out of range in '-9223372036854775808 * 1454377110'