MySQL Bugs: #119129: Unexpected error `BIGINT value is out of range in '--9223372036854775808'`

Bug #119129	Unexpected error `BIGINT value is out of range in '--9223372036854775808'`
Submitted:	10 Oct 14:13
Reporter:	chi zhang	Email Updates:
Status:	Open	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	9.4.0	OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Hi,

In the following test case, there are two equivalent queries, the normal query succeeds, but the prepared query triggers an error.

```
SELECT ((- (-9223372036854775808))); -- 9223372036854775808
SET @a = -9223372036854775808;
PREPARE prepare_query FROM 'SELECT ((- (?)))';
EXECUTE prepare_query USING @a;
DEALLOCATE PREPARE prepare_query;  -- BIGINT value is out of range in '--9223372036854775808'
```

How to repeat:
```
SELECT ((- (-9223372036854775808))); -- 9223372036854775808
SET @a = -9223372036854775808;
PREPARE prepare_query FROM 'SELECT ((- (?)))';
EXECUTE prepare_query USING @a;
DEALLOCATE PREPARE prepare_query;  -- BIGINT value is out of range in '--9223372036854775808'
```