Query: Bitwise Ex-Or support

[smitpatel]

Currently client eval

[ranma42]

related to #18795 (which includes also other bitwise operators)

[roji]

Interestingly, in PG the caret (^) isn't bitwise XOR, it's exponentiation; hash (#) is used for bitwise XOR. See below for a cross-database list.

@ranma42 given that XOR currently isn't supported in SQLite, can you confirm that we don't have any translations actually relying on that? Since these would fail in SQLite (IIRC you introduced XOR for SQL Server-specific search condition transformations, so seems fine - just confirming).

• SQL Server: caret (^) (docs)
• SQLite: not supported (Implement translation for XOR #34071). Expand in post-processing?
• MySQL: caret (^) (docs)
• MariaDB: caret (^) (docs)
• PostgreSQL: hash(#) (docs). The caret (^) is the exponentiation operator.
• Oracle: caret (^) (docs)
• Firebird: BIN_XOR() (docs)

[ranma42]

@ranma42 given that XOR currently isn't supported in SQLite, can you confirm that we don't have any translations actually relying on that? Since these would fail in SQLite (IIRC you introduced XOR for SQL Server-specific search condition transformations, so seems fine - just confirming).

Yes, inside of efcore the XOR is currently only used to avoid some back-and-forth between boolean value and boolean predicate in SqlServer. It would be trivial to support it for boolean values on sqlite, while other values would require plugging something like ef_xor.