tests/testthat/_snaps/query-set-op.md

In hadley/dbplyr: A 'dplyr' Back End for Databases

print method doesn't change unexpectedly

Code
  sql_build(union(lf1, lf2) %>% union_all(lf3))
Output
    <SQL SELECT>
    From:
      <table_path> `lf1`
    Select:   `lf1`.*, NULL

    UNION

    <SQL SELECT>
    From:
      <table_path> `lf2`
    Select:   `x`, NULL, `z`

    UNION ALL

    <SQL SELECT>
    From:
      <table_path> `lf3`
    Select:   `x`, NULL, `z`

generated sql doesn't change unexpectedly

Code
  union(lf, lf)
Output
  <SQL>
  SELECT *
  FROM `df`

  UNION

  SELECT *
  FROM `df`

Code
  setdiff(lf, lf)
Output
  <SQL>
  (
    SELECT *
    FROM `df`
  )
  EXCEPT
  (
    SELECT *
    FROM `df`
  )

Code
  intersect(lf, lf)
Output
  <SQL>
  (
    SELECT *
    FROM `df`
  )
  INTERSECT
  (
    SELECT *
    FROM `df`
  )

Code
  union(lf, lf, all = TRUE)
Output
  <SQL>
  SELECT *
  FROM `df`

  UNION ALL

  SELECT *
  FROM `df`

Code
  setdiff(lf, lf, all = TRUE)
Output
  <SQL>
  (
    SELECT *
    FROM `df`
  )
  EXCEPT ALL
  (
    SELECT *
    FROM `df`
  )

Code
  intersect(lf, lf, all = TRUE)
Output
  <SQL>
  (
    SELECT *
    FROM `df`
  )
  INTERSECT ALL
  (
    SELECT *
    FROM `df`
  )

hadley/dbplyr documentation built on May 4, 2024, 2:10 a.m.