tests/testthat/_snaps/translate-sql-quantile.md

In dbplyr: A 'dplyr' Back End for Databases

quantile and median don't change without warning

Code
  test_translate_sql(quantile(x, 0.75, na.rm = TRUE), window = FALSE)
Output
  <SQL> PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY `x`)

Code
  test_translate_sql(quantile(x, 0.75, na.rm = TRUE), vars_group = "g")
Output
  <SQL> PERCENTILE_CONT(0.75) WITHIN GROUP (ORDER BY `x`) OVER (PARTITION BY `g`)

Code
  test_translate_sql(median(x, na.rm = TRUE), window = FALSE)
Output
  <SQL> PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY `x`)

Code
  test_translate_sql(median(x, na.rm = TRUE), vars_group = "g")
Output
  <SQL> PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY `x`) OVER (PARTITION BY `g`)

dbplyr documentation built on Oct. 26, 2023, 9:06 a.m.