|
The bit operators |, ^, <, > don't appear to work in a where clause.
MariaDB [tpch1]> SELECT cidx,CDECIMAL18_2, CDECIMAL4_2 | 4 from DataTypeTestm where (CDECIMAL4_2 | 4) <> CDECIMAL18_2;
|
Empty set (0.039 sec)
|
|
MariaDB [tpch1]> SELECT cidx,CDECIMAL18_2, CDECIMAL4_2 | 4 from DataTypeTestm where (CDECIMAL4_2 | 4) < CDECIMAL18_2;
|
Empty set (0.035 sec)
|
|
MariaDB [tpch1]> SELECT cidx,CDECIMAL18_2, CDECIMAL4_2 | 4 from DataTypeTestm where (CDECIMAL4_2 | 4) > CDECIMAL18_2;
|
Empty set (0.033 sec)
|
|
MariaDB [tpch1]> SELECT cidx,CDECIMAL18_2, CDECIMAL4_2 | 4 from DataTypeTestm where (CDECIMAL4_2 | 4) = CDECIMAL18_2;
|
Empty set (0.052 sec)
|
At least one of these should evaluate true and return rows.
|