[MCOL-4644] bit operators don't work in WHERE clause - Jira

XML

Word

Printable

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.

duplicates

MCOL-4666 Empty set when using BIT OR and BIT AND functions in WHERE

relates to

MCOL-4666 Empty set when using BIT OR and BIT AND functions in WHERE

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.