blob: cdd242269d33e25d0954005b741b07c68a049c56 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
pragma config.flags("OptimizerFlags", "EqualityFilterOverJoin");
$p = 1;
$simpleKey =
select * from as_table([<|Key:Just(1), Value:"qqq"|>, <|Key:Just(2), Value:"aaa"|>]);
$complexKey =
select * from as_table([<|Key:Just(2), Fk:2, Value:"zzz"|>, <|Key:Just(2), Fk:3, Value:"ttt"|>]);
SELECT l.Key, l.Fk, l.Value, r.Key, r.Value FROM $simpleKey AS r
INNER JOIN $complexKey AS l
ON l.Fk = r.Key
WHERE l.Key = 1 + $p and l.Key = l.Key
ORDER BY r.Value
|
