[SPARK-38889] Invalid column name while querying bit type column in MSSQL

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 3.3.0
• Fix Version/s: 3.3.0
• Component/s: SQL
• Assignee: Allison Wang
• Reporter: Allison Wang
• Created: 13/Apr/22 17:58
• Updated: 12/Dec/22 18:10
• Resolved: 14/Apr/22 04:11

Description

After https://issues.apache.org/jira/browse/SPARK-36644 boolean column filters can be pushed to data sources. However, MSSQL only accepts bit type columns, and the current JDBC dialect for MSSQL does not compile the boolean type values in the pushed predicates into the bit type.

Issue Links

• links to: [Github] Pull Request #36182 (allisonwang-db)