File: query-select.md

package info (click to toggle)
r-cran-dbplyr 2.3.0%2Bdfsg-1
  • links: PTS, VCS
  • area: main
  • in suites: bookworm
  • size: 2,376 kB
  • sloc: sh: 13; makefile: 2
file content (30 lines) | stat: -rw-r--r-- 514 bytes parent folder | download
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
# select_query() print method output is as expected

    Code
      mf
    Output
      <SQL SELECT>
      From:
        <IDENT> df
      Select:   *
      Where:    `x` > 1
      Group by: `x`
      Order by: `x`
      Limit:    10

# queries generated by select() don't alias unnecessarily

    Code
      lf_render
    Output
      <SQL> SELECT `x`
      FROM `df`

---

    Code
      lazy_frame(x = 1, y = 1) %>% select()
    Condition
      Error in `sql_clause_select()`:
      ! Query contains no columns