Is this a bug or a feature I do not understand?
On R Studio Pro Server, this MS SQL query worked fine in R 3.4.2 and R.3.5.0 but fails in R 3.5.1 and R 3.6.0.
[Part of a much larger query originally.]
ageIntervals <-
fEncounter %>%
head(10) %>%
summarize(n90plus = sum(as.integer(AGE_IN_YEARS >= 90), na.rm=TRUE)) %>%
collect()
R 3.4.2 and 3.5.0 show this for show_query (everything worked fine)
<SQL>
SELECT SUM(CAST(CONVERT(BIT, IIF("AGE_IN_YEARS" >= 90.0, 1.0, 0.0)) AS INT)) AS "n90plus"
FROM (SELECT TOP 10 *
FROM XXXXXXX.XX_X_ENCOUNTER) "uyzjpitrzg"
R 3.5.1 and R 3.6.0 show this for show_query and fails:
<SQL>
SELECT SUM(CAST("AGE_IN_YEARS" >= 90.0 AS INT)) AS "n90plus"
FROM (SELECT TOP(10) *
FROM XXXXXXX.XX_X_ENCOUNTER) "dbplyr_002"
The failure message:
Error: <SQL> 'SELECT SUM(CAST("AGE_IN_YEARS" >= 90.0 AS INT)) AS "n90plus" FROM (SELECT TOP(10) * FROM XXXXXXX.XX_X_ENCOUNTER) "dbplyr_001"' nanodbc/nanodbc.cpp:1587: 42000: [Microsoft][ODBC Driver 17 for SQL Server][SQL
17. stop(structure(list(message = "<SQL> 'SELECT SUM(CAST(\"AGE_IN_YEARS\" >= 90.0 AS INT)) AS \"n90plus\"\nFROM (SELECT TOP(10) *\nFROM blinded.HF_F_ENCOUNTER) \"dbplyr_001\"'\n nanodbc/nanodbc.cpp:1587: 42000: [Microsoft][ODBC Driver 17 for SQL Server][SQL ", call = NULL, cppstack = NULL), class = c("odbc::odbc_error", "C++Error", "error", "condition")))
Bug or feature?