blob: fce8866ddf8fa28818059d8c7da5f61062934be9 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
USE plato;
pragma DqEngine = "disable";
DEFINE SUBQUERY $sample($product_type) AS
SELECT *
FROM Input
WHERE subkey = $product_type
ORDER BY key
LIMIT 10;
END DEFINE;
$list = ["a", "b"];
$s = SubqueryUnionAllFor($list, $sample);
$concated = PROCESS $s();
INSERT INTO Output
SELECT *
FROM $concated
|
