yql/essentials/tests/sql/suites/action/insert_after_eval.sql


1
2
3
4
5
6
7
8
9

/* syntax version 1 */
/* postgres can not */
/* multirun can not */
USE plato;

$s1 = (select count(*) from Output);
$s2 = (select max(key) from Output);
insert into Output with truncate
select EvaluateExpr($s1) as a, EvaluateExpr($s2) as b;