Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Duplicate
-
11.3.2, 10.11
-
None
-
Not for Release Notes
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'
Attachments
Issue Links
- duplicates
-
MDEV-19779 Optimizer replacement of expressions leads to 'value is out of range' exception and ignores range restrictions.
-
- Confirmed
-