databend-common-ast 0.0.3

SQL parser for Databend
Documentation 
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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110

---------- Input ----------
select * from customer join where a = b
---------- Output ---------
error: 
  --> SQL:1:24
  |
1 | select * from customer join where a = b
  | ------                 ^^^^ expecting more oprands
  | |                       
  | while parsing `SELECT ...`


---------- Input ----------
from t1 select * from t2
---------- Output ---------
error: 
  --> SQL:1:1
  |
1 | from t1 select * from t2
  | ^^^^
  | |
  | duplicated FROM clause
  | while parsing `SELECT ...`


---------- Input ----------
from t1 select * from t2 where a = b
---------- Output ---------
error: 
  --> SQL:1:1
  |
1 | from t1 select * from t2 where a = b
  | ^^^^
  | |
  | duplicated FROM clause
  | while parsing `SELECT ...`


---------- Input ----------
select * from join customer
---------- Output ---------
error: 
  --> SQL:1:15
  |
1 | select * from join customer
  | ------        ^^^^ missing lhs or rhs for the binary operator
  | |              
  | while parsing `SELECT ...`


---------- Input ----------
select * from customer natural inner join orders on a = b
---------- Output ---------
error: 
  --> SQL:1:50
  |
1 | select * from customer natural inner join orders on a = b
  | ------                                           ^^ join condition conflicting with NATURAL
  | |                                                 
  | while parsing `SELECT ...`


---------- Input ----------
select * order a
---------- Output ---------
error: 
  --> SQL:1:16
  |
1 | select * order a
  | ------         ^ unexpected `a`, expecting `BY`
  | |               
  | while parsing `SELECT ...`


---------- Input ----------
select * order
---------- Output ---------
error: 
  --> SQL:1:15
  |
1 | select * order
  | ------        ^ unexpected end of input, expecting `BY`
  | |             
  | while parsing `SELECT ...`


---------- Input ----------
select number + 5 as a, cast(number as float(255))
---------- Output ---------
error: 
  --> SQL:1:45
  |
1 | select number + 5 as a, cast(number as float(255))
  | ------                  ----                ^ unexpected `(`, expecting `)`, `NULL`, or `NOT`
  | |                       |                    
  | |                       while parsing `CAST(... AS ...)`
  | |                       while parsing expression
  | while parsing `SELECT ...`


---------- Input ----------
select 1 1
---------- Output ---------
error: 
  --> SQL:1:10
  |
1 | select 1 1
  |          ^ unexpected `1`, expecting <Ident>, <LiteralString>, `IDENTIFIER`, `AS`, `,`, `FROM`, `WHERE`, `GROUP`, `HAVING`, `WINDOW`, `QUALIFY`, `(`, `WITH`, `UNION`, `EXCEPT`, `INTERSECT`, `SELECT`, `VALUES`, `ORDER`, `LIMIT`, `OFFSET`, or `IGNORE_RESULT`