Re: [Maria-developers] MDEV-9372 select 100 between 1 and 9223372036854775808 returns false

Hi, Alexander! On Apr 20, Alexander Barkov wrote:

Hi Sergei,

Please review a patch for MDEV-9372.

Thanks.

commit b3df1c60a294fe906ca5dba804ee0c1f218a1728 Author: Alexander Barkov <bar@mariadb.org> Date: Wed Apr 20 12:08:36 2016 +0400

MDEV-9372 select 100 between 1 and 9223372036854775808 returns false

Integer comparison of INT expressions with different signess in BETWEEN is not safe. Switching to DECIMAL comparison in case if INT arguments have different signess.

ok to push Regards, Sergei Chief Architect MariaDB and security@mariadb.org