The Ultimate Guide to High Availability with MariaDB

Zarafa and aria?

You are viewing an old version of this question. View the current version here.

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.

Comments

Comments loading...
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.