File: string_literals.sql

package info (click to toggle)
sqlfluff 3.5.0-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 34,000 kB
  • sloc: python: 106,131; sql: 34,188; makefile: 52; sh: 8
file content (30 lines) | stat: -rw-r--r-- 604 bytes parent folder | download | duplicates (3)
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
-- Examples from https://cloud.google.com/bigquery/docs/reference/standard-sql/lexical#string_and_bytes_literals
SELECT
    "",
    '',
    "abc",
    "it's",
    'it\'s',
    'Title: "Boy"',
    "test \"escaped\"",
    'test \'escaped\'',
    "test \\\"escaped",
    "test \"escaped\\\"",
    r"",
    r'',
    r"abc+",
    R"abc+",
    r'abc+',
    R'abc+',
    r'f\(abc, (.*),def\)',
    r"f\(abc, (.*),def\)",
    b'abc',
    B"abc",
    rb"abc*",
    rB"abc*",
    Rb'abc*',
    br'abc+',
    RB"abc+",
    r''' as foo ''  bar ''',
    B""" triple ''' quoted '' "" string are """ as hard
FROM dummy