Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
10.9.4
-
None
-
mariadb docker
Description
Consider the following statements:
SELECT -5 & -4; – expected: -8, actual: 18446744073709551608
SELECT '-5' | '-4'; – expected: -3, actual: 18446744073709551615
SELECT '5' ^ '-4'; – expected: -7, actual: 18446744073709551609
SELECT ~5; – expected: -6, actual: 18446744073709551610
SELECT -3 > ('5' ^ '-4'); – expected: 1, actual: 0
The result should be negative, but it actually becomes a large value, We think this should be a spillover issue.
version :10.9.4-MariaDB-1:10.9.4+maria~ubu2204