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

Bools coerced to 0/1 in query results #4511

Closed
jtcohen6 opened this issue Dec 17, 2021 · 0 comments · Fixed by #4512
Closed

Bools coerced to 0/1 in query results #4511

jtcohen6 opened this issue Dec 17, 2021 · 0 comments · Fixed by #4512
Labels
bug Something isn't working dependencies Changes to the version of dbt dependencies regression
Milestone

Comments

@jtcohen6
Copy link
Contributor

jtcohen6 commented Dec 17, 2021

This is probably the result of allowing newer versions of agate (#3585):

Screenshot 2021-12-17 at 23 30 54

I thought we had a fix in v0.21 (#3499) that prevented agate from coercing query results (including from booleans to 0/1, wireservice/agate#733), but it clearly still is, somehow.

Let's confirm whether the agate dependency is the cause, and if so:

  • (worse fix) Roll it back to 1.6.1
  • (better fix) Fix the type coercion logic
@jtcohen6 jtcohen6 added bug Something isn't working dependencies Changes to the version of dbt dependencies regression labels Dec 17, 2021
@jtcohen6 jtcohen6 added this to the v1.0.1 milestone Dec 17, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working dependencies Changes to the version of dbt dependencies regression
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant