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;
|
