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
|
USE plato;
$strings = [
<|key:Just(Just("foo")), subkey:Just("bar"), value:1|>,
<|key:Just(Nothing(String?)), subkey:Just("two"), value:2|>,
<|key:Nothing(String??), subkey:Just("three"), value:3|>,
<|key:Nothing(String??), subkey:Nothing(String?), value:4|>,
];
$tuples = [
<|key:Just(Just(AsTuple(1, 2))), subkey:Just(AsTuple(3, 4)), value:1|>,
<|key:Just(Nothing(Tuple<Int, Int>?)), subkey:Just(AsTuple(4, 5)), value:2|>,
<|key:Nothing(Tuple<Int, Int>??), subkey:Just(AsTuple(5, 6)), value:3|>,
<|key:Nothing(Tuple<Int, Int>??), subkey:Nothing(Tuple<Int, Int>?), value:4|>,
];
insert into @strings
select * from as_table($strings);
insert into @tuples
select * from as_table($tuples);
commit;
select
value,
key ?? subkey,
subkey ?? "xxx",
from @strings
order by value;
select
value,
key ?? subkey,
subkey ?? AsTuple(100, 500),
from @tuples
order by value;
|
