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