Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

The iif operation does not work with literal tables in the Snowflake backend #10402

Open
radeusgd opened this issue Jun 28, 2024 · 0 comments
Open
Assignees
Labels
--bug Type: bug l-db-connector Libraries: database connectors

Comments

@radeusgd
Copy link
Member

See the test

+
+            # Literal tables only make sense in the DB.
+            if setup.is_database then group_builder.specify "iif should work with literal tables" <|
+                literal_table = setup.light_table_builder [["X", [True, False, Nothing]], ["row_id", [1, 2, 3]]] . sort "row_id"
+                literal_table.at "X" . value_type . should_equal Value_Type.Boolean
+                c = literal_table.at "X" . iif 10 20
+                c.to_vector . should_equal [10, 20, Nothing]

Currently it fails on Snowflake.

@radeusgd radeusgd self-assigned this Jun 28, 2024
@radeusgd radeusgd added --bug Type: bug l-db-connector Libraries: database connectors labels Jun 28, 2024
radeusgd added a commit that referenced this issue Jun 28, 2024
radeusgd added a commit that referenced this issue Jun 28, 2024
radeusgd added a commit that referenced this issue Jul 1, 2024
radeusgd added a commit that referenced this issue Jul 2, 2024
radeusgd added a commit that referenced this issue Jul 2, 2024
radeusgd added a commit that referenced this issue Jul 3, 2024
radeusgd added a commit that referenced this issue Jul 3, 2024
radeusgd added a commit that referenced this issue Jul 4, 2024
radeusgd added a commit that referenced this issue Jul 5, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
--bug Type: bug l-db-connector Libraries: database connectors
Projects
Status: New
Development

No branches or pull requests

1 participant