-
Notifications
You must be signed in to change notification settings - Fork 3.8k
/
stmt_raise
130 lines (120 loc) · 1.56 KB
/
stmt_raise
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
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
parse
DECLARE
BEGIN
RAISE;
END
----
expected parse error: at or near ";": syntax error: unimplemented: this syntax
parse
DECLARE
BEGIN
RAISE EXCEPTION USING MESSAGE = "why is this so involved?";
END
----
DECLARE
BEGIN
RAISE exception
USING message = "why is this so involved?";
END
parse
DECLARE
BEGIN
RAISE LOG USING HINT = "Insert HINT";
END
----
DECLARE
BEGIN
RAISE log
USING hint = "Insert HINT";
END
parse
DECLARE
BEGIN
RAISE LOG 'Nonexistent ID --> %', user_id;
END
----
DECLARE
BEGIN
RAISE log 'Nonexistent ID --> %', user_id;
END
parse
DECLARE
BEGIN
RAISE LOG 'Nonexistent ID --> %', user_id
USING HINT = "check...userid?" ;
END
----
DECLARE
BEGIN
RAISE log 'Nonexistent ID --> %', user_id
USING hint = "check...userid?";
END
parse
DECLARE
BEGIN
RAISE 'foo %', 'bar';
END
----
DECLARE
BEGIN
RAISE 'foo %', 'bar';
END
parse
DECLARE
i INT := 0;
BEGIN
RAISE 'foo %', i;
END
----
DECLARE
i INT8 := 0;
BEGIN
RAISE 'foo %', i;
END
parse
DECLARE
i INT := 0;
BEGIN
RAISE 'foo %', (SELECT count(*) FROM xy WHERE x = i);
END
----
DECLARE
i INT8 := 0;
BEGIN
RAISE 'foo %', (SELECT count(*) FROM xy WHERE x = i);
END
parse
DECLARE
BEGIN
RAISE SQLSTATE '222222' USING HINT = "hm";
END
----
DECLARE
BEGIN
RAISE SQLSTATE '222222'
USING hint = hm;
END
parse
DECLARE
BEGIN
RAISE internal_screaming;
END
----
DECLARE
BEGIN
RAISE internal_screaming;
END
parse
DECLARE
BEGIN
RAISE internal_screaming
USING MESSAGE = 'blah blah blah',
USING COLUMN = 'foo';
END
----
DECLARE
BEGIN
RAISE internal_screaming
USING message = 'blah blah blah',
USING column = 'foo';
END