Thanks for the workaround. It is unclear to me why SQL Server can't translate a boolean expression into BIT type which seems straightforward. I guess I should close this issue, no?

Boolean data type was unavailable in Oracle Database for a long time, resulting in many workarounds negatively influencing the data retrieval and overall processing performance. In April 2023, Oracle ...

@jounii The MySql does not have internal BOOLEAN data type. Types like BOOLEAN and BOOL are TINYINT (1) internally. In Changelog the TypeOrm team wrote this: some column types were removed. Now orm ...

I'm trying to implement full-text searching against a database with a large number of relevant columns (think searching through user profiles with a bunch of valid fields). For my initial stab at ...