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
|
/* syntax version 1 */
/* postgres can not */
/* yt can not */
pragma warning("disable", "4510");
$type = Struct<x:Int32, y:Int32, z:Int32>;
$keys = AsTuple(AsAtom("x"), AsAtom("y"), AsAtom("z"));
$range_for = ($pred) -> (YQL::RangeComputeFor($type, $pred, $keys));
$pred1 = ($row) -> (($row.x, $row.y, $row.z) >= (11, 22, 33));
$pred2 = ($row) -> (($row.x, $row.y, $row.z) > (11, 22, 33));
$pred3 = ($row) -> (($row.x, $row.y, $row.z) < (11, 22, 33));
$pred4 = ($row) -> (($row.x, $row.y, $row.z) <= (11, 22, 33));
$pred5 = ($row) -> (($row.x, $row.y, $row.z) > (111, 222, 333) and ($row.x, $row.y, $row.z) <= (111, 333, 444));
$pred6 = ($row) -> (($row.x, $row.y, $row.z) >= (111, 222, 333) and ($row.x, $row.y, $row.z) < (111, 222, 333));
select
$range_for($pred1),
$range_for($pred2),
$range_for($pred3),
$range_for($pred4),
$range_for($pred5),
$range_for($pred6),
;
$pred1 = ($row) -> (($row.x, $row.y) >= (11, 22));
$pred2 = ($row) -> (($row.x, $row.y) > (11, 22));
$pred3 = ($row) -> (($row.x, $row.y) < (11, 22));
$pred4 = ($row) -> (($row.x, $row.y) <= (11, 22));
$pred5 = ($row) -> (($row.x, $row.y) > (111, 222) and ($row.x, $row.y) <= (111, 333));
$pred6 = ($row) -> (($row.x, $row.y) >= (111, 222) and ($row.x, $row.y) < (111, 222));
select
$range_for($pred1),
$range_for($pred2),
$range_for($pred3),
$range_for($pred4),
$range_for($pred5),
$range_for($pred6),
;
|