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
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
|
USE plato;
pragma yt.DisableOptimizers="OutHorizontalJoin,HorizontalJoin,MultiHorizontalJoin,FuseMultiOutsWithOuterMaps";
SELECT
Date("2000-01-01") > na,
Date("2000-01-01") > naz,
Date("2000-01-01") > nd,
Date("2000-01-01") > ndz,
Date("2000-01-01") > nt,
Date("2000-01-01") > ntz,
Date("2000-01-01") > wa,
Date("2000-01-01") > wd,
Date("2000-01-01") > wt,
Date("2000-01-01") > waz,
Date("2000-01-01") > wdz,
Date("2000-01-01") > wtz,
TzDate("2000-01-01,Europe/Moscow") > na,
TzDate("2000-01-01,Europe/Moscow") > naz,
TzDate("2000-01-01,Europe/Moscow") > nd,
TzDate("2000-01-01,Europe/Moscow") > ndz,
TzDate("2000-01-01,Europe/Moscow") > nt,
TzDate("2000-01-01,Europe/Moscow") > ntz,
TzDate("2000-01-01,Europe/Moscow") > wa,
TzDate("2000-01-01,Europe/Moscow") > wd,
TzDate("2000-01-01,Europe/Moscow") > wt,
TzDate("2000-01-01,Europe/Moscow") > waz,
TzDate("2000-01-01,Europe/Moscow") > wdz,
TzDate("2000-01-01,Europe/Moscow") > wtz,
Datetime("2000-01-01T03:04:05Z") > na,
Datetime("2000-01-01T03:04:05Z") > naz,
Datetime("2000-01-01T03:04:05Z") > nd,
Datetime("2000-01-01T03:04:05Z") > ndz,
Datetime("2000-01-01T03:04:05Z") > nt,
Datetime("2000-01-01T03:04:05Z") > ntz,
Datetime("2000-01-01T03:04:05Z") > wa,
Datetime("2000-01-01T03:04:05Z") > wd,
Datetime("2000-01-01T03:04:05Z") > wt,
Datetime("2000-01-01T03:04:05Z") > waz,
Datetime("2000-01-01T03:04:05Z") > wdz,
Datetime("2000-01-01T03:04:05Z") > wtz,
TzDatetime("2000-01-01T03:04:05,Europe/Moscow") > na,
TzDatetime("2000-01-01T03:04:05,Europe/Moscow") > naz,
TzDatetime("2000-01-01T03:04:05,Europe/Moscow") > nd,
TzDatetime("2000-01-01T03:04:05,Europe/Moscow") > ndz,
TzDatetime("2000-01-01T03:04:05,Europe/Moscow") > nt,
TzDatetime("2000-01-01T03:04:05,Europe/Moscow") > ntz,
TzDatetime("2000-01-01T03:04:05,Europe/Moscow") > wa,
TzDatetime("2000-01-01T03:04:05,Europe/Moscow") > wd,
TzDatetime("2000-01-01T03:04:05,Europe/Moscow") > wt,
TzDatetime("2000-01-01T03:04:05,Europe/Moscow") > waz,
TzDatetime("2000-01-01T03:04:05,Europe/Moscow") > wdz,
TzDatetime("2000-01-01T03:04:05,Europe/Moscow") > wtz,
Timestamp("2000-01-01T03:04:05.678912Z") > na,
Timestamp("2000-01-01T03:04:05.678912Z") > naz,
Timestamp("2000-01-01T03:04:05.678912Z") > nd,
Timestamp("2000-01-01T03:04:05.678912Z") > ndz,
Timestamp("2000-01-01T03:04:05.678912Z") > nt,
Timestamp("2000-01-01T03:04:05.678912Z") > ntz,
Timestamp("2000-01-01T03:04:05.678912Z") > wa,
Timestamp("2000-01-01T03:04:05.678912Z") > wd,
Timestamp("2000-01-01T03:04:05.678912Z") > wt,
Timestamp("2000-01-01T03:04:05.678912Z") > waz,
Timestamp("2000-01-01T03:04:05.678912Z") > wdz,
Timestamp("2000-01-01T03:04:05.678912Z") > wtz,
TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") > na,
TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") > naz,
TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") > nd,
TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") > ndz,
TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") > nt,
TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") > ntz,
TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") > wa,
TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") > wd,
TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") > wt,
TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") > waz,
TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") > wdz,
TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow") > wtz
FROM Dates;
SELECT
Date32("1900-01-01") > na,
Date32("1900-01-01") > naz,
Date32("1900-01-01") > nd,
Date32("1900-01-01") > ndz,
Date32("1900-01-01") > nt,
Date32("1900-01-01") > ntz,
Date32("1900-01-01") > wa,
Date32("1900-01-01") > wd,
Date32("1900-01-01") > wt,
Date32("1900-01-01") > waz,
Date32("1900-01-01") > wdz,
Date32("1900-01-01") > wtz,
Datetime64("1900-01-01T03:04:05Z") > na,
Datetime64("1900-01-01T03:04:05Z") > naz,
Datetime64("1900-01-01T03:04:05Z") > nd,
Datetime64("1900-01-01T03:04:05Z") > ndz,
Datetime64("1900-01-01T03:04:05Z") > nt,
Datetime64("1900-01-01T03:04:05Z") > ntz,
Datetime64("1900-01-01T03:04:05Z") > wa,
Datetime64("1900-01-01T03:04:05Z") > wd,
Datetime64("1900-01-01T03:04:05Z") > wt,
Datetime64("1900-01-01T03:04:05Z") > waz,
Datetime64("1900-01-01T03:04:05Z") > wdz,
Datetime64("1900-01-01T03:04:05Z") > wtz,
Timestamp64("1900-01-01T03:04:05.678912Z") > na,
Timestamp64("1900-01-01T03:04:05.678912Z") > naz,
Timestamp64("1900-01-01T03:04:05.678912Z") > nd,
Timestamp64("1900-01-01T03:04:05.678912Z") > ndz,
Timestamp64("1900-01-01T03:04:05.678912Z") > nt,
Timestamp64("1900-01-01T03:04:05.678912Z") > ntz,
Timestamp64("1900-01-01T03:04:05.678912Z") > wa,
Timestamp64("1900-01-01T03:04:05.678912Z") > wd,
Timestamp64("1900-01-01T03:04:05.678912Z") > wt,
Timestamp64("1900-01-01T03:04:05.678912Z") > waz,
Timestamp64("1900-01-01T03:04:05.678912Z") > wdz,
Timestamp64("1900-01-01T03:04:05.678912Z") > wtz,
TzDate32("1900-01-01,Europe/Moscow") > na,
TzDate32("1900-01-01,Europe/Moscow") > naz,
TzDate32("1900-01-01,Europe/Moscow") > nd,
TzDate32("1900-01-01,Europe/Moscow") > ndz,
TzDate32("1900-01-01,Europe/Moscow") > nt,
TzDate32("1900-01-01,Europe/Moscow") > ntz,
TzDate32("1900-01-01,Europe/Moscow") > wa,
TzDate32("1900-01-01,Europe/Moscow") > wd,
TzDate32("1900-01-01,Europe/Moscow") > wt,
TzDate32("1900-01-01,Europe/Moscow") > waz,
TzDate32("1900-01-01,Europe/Moscow") > wdz,
TzDate32("1900-01-01,Europe/Moscow") > wtz,
TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") > na,
TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") > naz,
TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") > nd,
TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") > ndz,
TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") > nt,
TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") > ntz,
TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") > wa,
TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") > wd,
TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") > wt,
TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") > waz,
TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") > wdz,
TzDatetime64("1900-01-01T03:04:05,Europe/Moscow") > wtz,
TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") > na,
TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") > naz,
TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") > nd,
TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") > ndz,
TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") > nt,
TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") > ntz,
TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") > wa,
TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") > wd,
TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") > wt,
TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") > waz,
TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") > wdz,
TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow") > wtz,
Interval("P1D") > ni,
Interval("P1D") > wi,
Interval64("P1D") > ni,
Interval64("P1D") > wi,
FROM Dates;
SELECT
na > Date("2000-01-01"),
naz > Date("2000-01-01"),
nd > Date("2000-01-01"),
ndz > Date("2000-01-01"),
nt > Date("2000-01-01"),
ntz > Date("2000-01-01"),
wa > Date("2000-01-01"),
wd > Date("2000-01-01"),
wt > Date("2000-01-01"),
waz > Date("2000-01-01"),
wdz > Date("2000-01-01"),
wtz > Date("2000-01-01"),
na > TzDate("2000-01-01,Europe/Moscow"),
naz > TzDate("2000-01-01,Europe/Moscow"),
nd > TzDate("2000-01-01,Europe/Moscow"),
ndz > TzDate("2000-01-01,Europe/Moscow"),
nt > TzDate("2000-01-01,Europe/Moscow"),
ntz > TzDate("2000-01-01,Europe/Moscow"),
wa > TzDate("2000-01-01,Europe/Moscow"),
wd > TzDate("2000-01-01,Europe/Moscow"),
wt > TzDate("2000-01-01,Europe/Moscow"),
waz > TzDate("2000-01-01,Europe/Moscow"),
wdz > TzDate("2000-01-01,Europe/Moscow"),
wtz > TzDate("2000-01-01,Europe/Moscow"),
na > Datetime("2000-01-01T03:04:05Z"),
naz > Datetime("2000-01-01T03:04:05Z"),
nd > Datetime("2000-01-01T03:04:05Z"),
ndz > Datetime("2000-01-01T03:04:05Z"),
nt > Datetime("2000-01-01T03:04:05Z"),
ntz > Datetime("2000-01-01T03:04:05Z"),
wa > Datetime("2000-01-01T03:04:05Z"),
wd > Datetime("2000-01-01T03:04:05Z"),
wt > Datetime("2000-01-01T03:04:05Z"),
waz > Datetime("2000-01-01T03:04:05Z"),
wdz > Datetime("2000-01-01T03:04:05Z"),
wtz > Datetime("2000-01-01T03:04:05Z"),
na > TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
naz > TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
nd > TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
ndz > TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
nt > TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
ntz > TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
wa > TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
wd > TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
wt > TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
waz > TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
wdz > TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
wtz > TzDatetime("2000-01-01T03:04:05,Europe/Moscow"),
na > Timestamp("2000-01-01T03:04:05.678912Z"),
naz > Timestamp("2000-01-01T03:04:05.678912Z"),
nd > Timestamp("2000-01-01T03:04:05.678912Z"),
ndz > Timestamp("2000-01-01T03:04:05.678912Z"),
nt > Timestamp("2000-01-01T03:04:05.678912Z"),
ntz > Timestamp("2000-01-01T03:04:05.678912Z"),
wa > Timestamp("2000-01-01T03:04:05.678912Z"),
wd > Timestamp("2000-01-01T03:04:05.678912Z"),
wt > Timestamp("2000-01-01T03:04:05.678912Z"),
waz > Timestamp("2000-01-01T03:04:05.678912Z"),
wdz > Timestamp("2000-01-01T03:04:05.678912Z"),
wtz > Timestamp("2000-01-01T03:04:05.678912Z"),
na > TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
naz > TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
nd > TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
ndz > TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
nt > TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
ntz > TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
wa > TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
wd > TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
wt > TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
waz > TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
wdz > TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow"),
wtz > TzTimestamp("2000-01-01T03:04:05.678912,Europe/Moscow")
FROM Dates;
SELECT
na > Date32("1900-01-01"),
naz > Date32("1900-01-01"),
nd > Date32("1900-01-01"),
ndz > Date32("1900-01-01"),
nt > Date32("1900-01-01"),
ntz > Date32("1900-01-01"),
wa > Date32("1900-01-01"),
wd > Date32("1900-01-01"),
wt > Date32("1900-01-01"),
waz > Date32("1900-01-01"),
wdz > Date32("1900-01-01"),
wtz > Date32("1900-01-01"),
na > Datetime64("1900-01-01T03:04:05Z"),
naz > Datetime64("1900-01-01T03:04:05Z"),
nd > Datetime64("1900-01-01T03:04:05Z"),
ndz > Datetime64("1900-01-01T03:04:05Z"),
nt > Datetime64("1900-01-01T03:04:05Z"),
ntz > Datetime64("1900-01-01T03:04:05Z"),
wa > Datetime64("1900-01-01T03:04:05Z"),
wd > Datetime64("1900-01-01T03:04:05Z"),
wt > Datetime64("1900-01-01T03:04:05Z"),
waz > Datetime64("1900-01-01T03:04:05Z"),
wdz > Datetime64("1900-01-01T03:04:05Z"),
wtz > Datetime64("1900-01-01T03:04:05Z"),
na > Timestamp64("1900-01-01T03:04:05.678912Z"),
naz > Timestamp64("1900-01-01T03:04:05.678912Z"),
nd > Timestamp64("1900-01-01T03:04:05.678912Z"),
ndz > Timestamp64("1900-01-01T03:04:05.678912Z"),
nt > Timestamp64("1900-01-01T03:04:05.678912Z"),
ntz > Timestamp64("1900-01-01T03:04:05.678912Z"),
wa > Timestamp64("1900-01-01T03:04:05.678912Z"),
wd > Timestamp64("1900-01-01T03:04:05.678912Z"),
wt > Timestamp64("1900-01-01T03:04:05.678912Z"),
waz > Timestamp64("1900-01-01T03:04:05.678912Z"),
wdz > Timestamp64("1900-01-01T03:04:05.678912Z"),
wtz > Timestamp64("1900-01-01T03:04:05.678912Z"),
na > TzDate32("1900-01-01,Europe/Moscow"),
naz > TzDate32("1900-01-01,Europe/Moscow"),
nd > TzDate32("1900-01-01,Europe/Moscow"),
ndz > TzDate32("1900-01-01,Europe/Moscow"),
nt > TzDate32("1900-01-01,Europe/Moscow"),
ntz > TzDate32("1900-01-01,Europe/Moscow"),
wa > TzDate32("1900-01-01,Europe/Moscow"),
wd > TzDate32("1900-01-01,Europe/Moscow"),
wt > TzDate32("1900-01-01,Europe/Moscow"),
waz > TzDate32("1900-01-01,Europe/Moscow"),
wdz > TzDate32("1900-01-01,Europe/Moscow"),
wtz > TzDate32("1900-01-01,Europe/Moscow"),
na > TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
naz > TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
nd > TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
ndz > TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
nt > TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
ntz > TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
wa > TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
wd > TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
wt > TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
waz > TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
wdz > TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
wtz > TzDatetime64("1900-01-01T03:04:05,Europe/Moscow"),
na > TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
naz > TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
nd > TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
ndz > TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
nt > TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
ntz > TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
wa > TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
wd > TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
wt > TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
waz > TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
wdz > TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
wtz > TzTimestamp64("1900-01-01T03:04:05.678912,Europe/Moscow"),
ni > Interval("P1D"),
wi > Interval("P1D"),
ni > Interval64("P1D"),
wi > Interval64("P1D"),
FROM Dates;
|
