-
Notifications
You must be signed in to change notification settings - Fork 37
Expand file tree
/
Copy pathlogfile
More file actions
144 lines (144 loc) · 4.57 KB
/
logfile
File metadata and controls
144 lines (144 loc) · 4.57 KB
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
131
132
133
134
135
136
137
138
139
140
141
142
143
144
LOG: database system was shut down at 2016-05-08 18:27:52 ICT
LOG: MultiXact member wraparound protections are now enabled
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
ERROR: relation "v" does not exist at character 15
STATEMENT: select * from v
FATAL: database "juhasm" does not exist
ERROR: syntax error at or near "`" at character 15
STATEMENT: create schema `sample`;
ERROR: syntax error at or near "'sample'" at character 15
STATEMENT: create schema 'sample';
ERROR: schema "sample" already exists
STATEMENT: create schema sample;
ERROR: relation "t" does not exist at character 117
STATEMENT: SELECT
v,
ROW_NUMBER() OVER(ORDER BY v),
RANK() OVER(ORDER BY v),
DENSE_RANK() OVER(ORDER BY v)
FROM t
ORDER BY 1, 2
ERROR: function first() does not exist at character 135
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
STATEMENT: SELECT
letter,
ROW_NUMBER() OVER(ORDER BY letter),
RANK() OVER(ORDER BY letter),
DENSE_RANK() OVER(ORDER BY letter),
FIRST() OVER(ORDER BY letter)
FROM sample.test
ORDER BY 1, 2
;
ERROR: function first(text) does not exist at character 135
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
STATEMENT: SELECT
letter,
ROW_NUMBER() OVER(ORDER BY letter),
RANK() OVER(ORDER BY letter),
DENSE_RANK() OVER(ORDER BY letter),
FIRST(letter)
FROM sample.test
ORDER BY 1, 2
;
ERROR: column "test.letter" must appear in the GROUP BY clause or be used in an aggregate function at character 10
STATEMENT: SELECT
letter,
ROW_NUMBER() OVER(ORDER BY letter),
RANK() OVER(ORDER BY letter),
DENSE_RANK() OVER(ORDER BY letter),
FIRST(letter)
FROM sample.test
ORDER BY 1, 2
;
ERROR: syntax error at or near "GROUP" at character 154
STATEMENT: SELECT
letter,
ROW_NUMBER() OVER(ORDER BY letter),
RANK() OVER(ORDER BY letter),
DENSE_RANK() OVER(ORDER BY letter),
FIRST(letter) OVER(GROUP BY letter ORDER BY letter)
FROM sample.test
ORDER BY 1, 2
;
ERROR: function last(text) does not exist at character 174
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
STATEMENT: SELECT
letter,
ROW_NUMBER() OVER(ORDER BY letter),
RANK() OVER(ORDER BY letter),
DENSE_RANK() OVER(ORDER BY letter),
FIRST(letter) OVER(ORDER BY letter),
LAST(letter) OVER(ORDER BY letter)
FROM sample.test
ORDER BY 1, 2
;
ERROR: function last_vvalue(text) does not exist at character 165
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
STATEMENT: SELECT
letter,
ROW_NUMBER() OVER(ORDER BY letter),
RANK() OVER(ORDER BY letter),
DENSE_RANK() OVER(ORDER BY letter),
FIRST_VALUE(letter) OVER(),
LAST_VVALUE(letter) OVER()
FROM sample.test
ORDER BY 1, 2
;
ERROR: window function nth_value requires an OVER clause at character 194
STATEMENT: SELECT
letter,
ROW_NUMBER() OVER(ORDER BY letter),
RANK() OVER(ORDER BY letter),
DENSE_RANK() OVER(ORDER BY letter),
FIRST_VALUE(letter) OVER(),
LAST_VALUE(letter) OVER(),
NTH_VALUE(letter, 2)
FROM sample.test
ORDER BY 1, 2
;
ERROR: syntax error at or near "(" at character 258
STATEMENT: SELECT
letter,
ROW_NUMBER() OVER(ORDER BY letter),
RANK() OVER(ORDER BY letter),
DENSE_RANK() OVER(ORDER BY letter),
FIRST_VALUE(letter) OVER(),
LAST_VALUE(letter) OVER(),
NTH_VALUE(letter, 3) OVER(ORDER BY letter),
LAG(letter)
LEAD(letter)
FROM sample.test
ORDER BY 1, 2
;
ERROR: window function lag requires an OVER clause at character 240
STATEMENT: SELECT
letter,
ROW_NUMBER() OVER(ORDER BY letter),
RANK() OVER(ORDER BY letter),
DENSE_RANK() OVER(ORDER BY letter),
FIRST_VALUE(letter) OVER(),
LAST_VALUE(letter) OVER(),
NTH_VALUE(letter, 3) OVER(ORDER BY letter),
LAG(letter),
LEAD(letter)
FROM sample.test
ORDER BY 1, 2
;
ERROR: function ntile() does not exist at character 175
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
STATEMENT: SELECT
letter,
ROW_NUMBER() OVER(ORDER BY letter),
RANK() OVER(ORDER BY letter),
DENSE_RANK() OVER(ORDER BY letter),
PERCENT_RANK() OVER(ORDER BY letter),
NTILE() OVER(ORDER BY letter),
FIRST_VALUE(letter) OVER(),
LAST_VALUE(letter) OVER(),
NTH_VALUE(letter, 3) OVER(ORDER BY letter),
LAG(letter) OVER(),
LEAD(letter) OVER()
FROM sample.test
ORDER BY 1, 2
;