← Back to team overview

maria-discuss team mailing list archive

Problem with bit operations in certain expressions



Need some help here. I have the following expression:

SELECT IF(1=1, 0x2, 0x4) | 0x1

which in MySQL evaluates to: 3

but in MariaDB it evaluates to: 1

MySQL's result seems correct to me. Would appreciate any advice on this.

Many thanks!


Follow ups