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
|
$date32_min = unwrap(cast(-53375809 as date32));
$date32_max = unwrap(cast(53375807 as date32));
$datetime64_min = unwrap(cast(-4611669897600 as datetime64));
$datetime64_max = unwrap(cast(4611669811199 as datetime64));
$timestamp64_min = unwrap(cast(-4611669897600000000 as timestamp64));
$timestamp64_max = unwrap(cast(4611669811199999999 as timestamp64));
$interval64_min = unwrap(cast(-9223339708799999999 as interval64));
$interval64_max = unwrap(cast(9223339708799999999 as interval64));
$interval64_plus1 = unwrap(cast(1 as interval64));
$interval64_minus1 = unwrap(cast(-1 as interval64));
$interval64_zero = unwrap(cast(0 as interval64));
$date_max_value = 49673l;
$date_max = unwrap(cast($date_max_value - 1 as date));
$datetime_max = unwrap(cast($date_max_value*86400 - 1 as datetime));
$timestamp_max = unwrap(cast($date_max_value*86400*1000000 - 1 as timestamp));
$interval_min = unwrap(cast(-$date_max_value*86400*1000000 + 1 as interval));
$interval_max = unwrap(cast($date_max_value*86400*1000000 - 1 as interval));
$interval_plus1 = unwrap(cast(1 as interval));
$interval_minus1 = unwrap(cast(-1 as interval));
$i64_max = 9223372036854775807l;
$ui64_max = 18446744073709551615ul;
select 1, $date32_min - $date32_max, $date32_max - $date32_min
, $date32_min - $datetime64_max, $date32_max - $datetime64_min
, $date32_min - $timestamp64_max, $date32_max - $timestamp64_min
, 2, $date32_min - $date_max
, $date32_min - $datetime_max
, $date32_min - $timestamp_max
, 3, $date32_min - $interval64_minus1, $date32_max - $interval64_minus1
, $date32_min - $interval64_plus1, $date32_max - $interval64_plus1
, $date32_min + $interval64_minus1, $date32_max + $interval64_minus1
, $date32_min + $interval64_plus1, $date32_max + $interval64_plus1
, 4, $date32_min - $interval_minus1, $date32_max - $interval_minus1
, $date32_min - $interval_plus1, $date32_max - $interval_plus1
, $date32_min + $interval_minus1, $date32_max + $interval_minus1
, $date32_min + $interval_plus1, $date32_max + $interval_plus1;
select 1, $datetime64_min - $date32_max, $datetime64_max - $date32_min
, $datetime64_min - $datetime64_max, $datetime64_max - $datetime64_min
, $datetime64_min - $timestamp64_max, $datetime64_max - $timestamp64_min
, 2, $datetime64_min - $date_max
, $datetime64_min - $datetime_max
, $datetime64_min - $timestamp_max
, 3, $datetime64_min - $interval64_minus1, $datetime64_max - $interval64_minus1
, $datetime64_min - $interval64_plus1, $datetime64_max - $interval64_plus1
, $datetime64_min + $interval64_minus1, $datetime64_max + $interval64_minus1
, $datetime64_min + $interval64_plus1, $datetime64_max + $interval64_plus1
, 4, $datetime64_min - $interval_minus1, $datetime64_max - $interval_minus1
, $datetime64_min - $interval_plus1, $datetime64_max - $interval_plus1
, $datetime64_min + $interval_minus1, $datetime64_max + $interval_minus1
, $datetime64_min + $interval_plus1, $datetime64_max + $interval_plus1;
select 1, $timestamp64_min - $date32_max, $timestamp64_max - $date32_min
, $timestamp64_min - $datetime64_max, $timestamp64_max - $datetime64_min
, $timestamp64_min - $timestamp64_max, $timestamp64_max - $timestamp64_min
, 2, $timestamp64_min - $date_max
, $timestamp64_min - $datetime_max
, $timestamp64_min - $timestamp_max
, 3, $timestamp64_min - $interval64_minus1, $timestamp64_max - $interval64_minus1
, $timestamp64_min - $interval64_plus1, $timestamp64_max - $interval64_plus1
, $timestamp64_min + $interval64_minus1, $timestamp64_max + $interval64_minus1
, $timestamp64_min + $interval64_plus1, $timestamp64_max + $interval64_plus1
, 4, $timestamp64_min - $interval_minus1, $timestamp64_max - $interval_minus1
, $timestamp64_min - $interval_plus1, $timestamp64_max - $interval_plus1
, $timestamp64_min + $interval_minus1, $timestamp64_max + $interval_minus1
, $timestamp64_min + $interval_plus1, $timestamp64_max + $interval_plus1;
select 1, $date_max - $date32_min, $date_max - $datetime64_min, $date_max - $timestamp64_min
, $date_max - $date32_max, $date_max - $datetime64_max, $date_max - $timestamp64_max
, $date_max - $interval64_minus1, $date_max + $interval64_minus1
, $date_max - $interval64_plus1, $date_max + $interval64_plus1
, 2, $datetime_max - $date32_min, $datetime_max - $datetime64_min, $datetime_max - $timestamp64_min
, $datetime_max - $date32_max, $datetime_max - $datetime64_max, $datetime_max - $timestamp64_max
, $datetime_max - $interval64_minus1, $datetime_max + $interval64_minus1
, $datetime_max - $interval64_plus1, $datetime_max + $interval64_plus1
, 3, $timestamp_max - $date32_min, $timestamp_max - $datetime64_min, $timestamp_max - $timestamp64_min
, $timestamp_max - $date32_max, $timestamp_max - $datetime64_max, $timestamp_max - $timestamp64_max
, $timestamp_max - $interval64_minus1, $timestamp_max + $interval64_minus1
, $timestamp_max - $interval64_plus1, $timestamp_max + $interval64_plus1;
select 1, $interval_min - $interval64_min, $interval_min + $interval64_min
, $interval_min - $interval64_max, $interval_min + $interval64_max
, $interval_max - $interval64_max, $interval_max + $interval64_max
, $interval_max - $interval64_min, $interval_max + $interval64_min
, 2, $interval64_max - $interval64_min, $interval64_min - $interval64_max
, $interval64_max + $interval64_min, $interval64_max + $interval64_max
, $interval64_min - $interval64_min, $interval64_max - $interval64_max;
select 0, -$interval64_max, -$interval64_min, -$interval64_zero
, 1, $interval64_max*0, 0*$interval64_max
, 2, $interval64_max*1, 1*$interval64_max, $interval64_max*(-1), (-1)*$interval64_max
, 3, $interval64_min*1, 1*$interval64_min, $interval64_min*(-1), (-1)*$interval64_min
, 4, $interval64_plus1*cast($interval64_max as int64), $interval64_minus1*cast($interval64_min as int64)
, 5, $interval64_max*$ui64_max, $i64_max*$interval64_max, $interval64_min*$ui64_max, $i64_max*$interval64_min
, 6, $interval64_zero*$ui64_max, $ui64_max*$interval64_zero, $interval64_zero*$i64_max, $i64_max*$interval64_zero
, 7, $interval64_max/0, $interval64_min/0, $interval64_max/1, $interval64_min/1, $interval64_max/(-1), $interval64_min/(-1)
, 8, $interval64_zero/$ui64_max, $interval64_zero/$i64_max, $interval64_plus1/$ui64_max, $interval64_plus1/$i64_max, $interval64_minus1/$ui64_max, $interval64_minus1/$i64_max
, 9, $interval64_max/cast($interval64_max as int64), $interval64_min/cast($interval64_min as int64)
, 10, abs($interval64_max), abs($interval64_min), abs($interval64_zero)
, 11, cast(4294967296l as interval64) * 4294967296l, 4294967296ul * cast(4294967296l as interval64)
;
|
