We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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?
to your account
dplyr::translate_sql_q(quote(!is.na(if (w > 0) w)))
<SQL> CASE WHEN "w" > 0.0 THEN "w" ENDIS NULL
The keyword ENDIS is not part of any SQL dialect I know of and it seems like a space fell through the cracks.
Comparing the defs for is.na and is.null in base_scalar seems to confirm the hypothesis
build_sql(x, "IS NULL")
build_sql(x, " IS NULL")
The text was updated successfully, but these errors were encountered:
Fix spacing issue with is.na sql translation.
I now get:
translate_sql(!is.na(if (x) y else z))
#> <SQL> NOT((CASE WHEN ("x") THEN ("y") ELSE ("z") END) IS NULL)
I think that's more likely to parse correctly.
Sorry, something went wrong.
No branches or pull requests