Zarafa and aria?
Hi!
https://forums.zarafa.com/showthread.php?7980-SQL-error-on-Zarafa-7-1-with-MariaDB-5-5-25
Seems vTiger, Redmine, and Alfresco work fine with MariaDB & Aria, but maybe Zarafa has an error? Is this something we can look into fixing?
Thanks
Answer
in
SELECT 1 - 0x8501;
MariaDB complains about unsigned underflow and wraparound. You subtract two unsigned numbers, and by default the result is unsigned too. A possible workaround would be
SELECT -0x8501 + 1;
because in this case, you add a signed number (-0x8501) and an unsigned number. The result is signed.
The proper solution is to set the corresponding sql mode:
set @@sql_mode=no_unsigned_subtraction; SELECT 1 - 0x8501;
In this case any subtraction will return a signed number.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
