Re: Bitwise OR failed, bit 5 not set

[Rick James]

You are grossly mixing decimal and hex (or octal? or binary?)

mysql> SELECT HEX(0x200000 | 2);
+-------------------+
| HEX(0x200000 | 2) |
+-------------------+
| 200002            |
+-------------------+
1 row in set (0.00 sec)

mysql> SELECT HEX(0x200000 | 32);
+--------------------+
| HEX(0x200000 | 32) |
+--------------------+
| 200020             |
+--------------------+
1 row in set (0.00 sec)