Skip to content

[BUG] Allow boolean comparison with Int #1345

@osipovartem

Description

@osipovartem
select true::boolean = 0

Cannot infer common argument type for comparison operation Boolean = Int64

Snowflake returns boolean, comparison works as 0 vs other values (1,2,100, etc.)

 > select true::boolean = 0;
+-------------------+
| TRUE::BOOLEAN = 0 |
|-------------------|
| False             |
+-------------------+
 > select true::boolean = 10;
+--------------------+
| TRUE::BOOLEAN = 10 |
|--------------------|
| True               |
+--------------------+

Metadata

Metadata

Assignees

Labels

dbtRelated to dbtengineengine team area

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions