blob: 3f4170a1a74b4ce7c5fd69ee908b826c105aee3d (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
|
USE plato;
$list = AsList(
AsStruct(CAST(1 AS Int32) as jk, AsStruct(CAST(1 AS Int32) as x, CAST(2 AS Int32) as y) as a)
);
$input = (select cast(key as Int32) ?? 0 as jk, value from Input);
$j = (select t.a as a, i.value as value from (select * from AS_TABLE($list)) as t join $input as i using(jk));
insert into Output
select value, a.x as ax from $j;
|
