yql/essentials/tests/sql/suites/insert/double_append_to_anonymous.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14

/* postgres can not */
use plato;

INSERT INTO @tmp
SELECT 1 as id, "qwer" as val;
COMMIT;

INSERT INTO @tmp
SELECT 2 as id, "asdf" as val;

COMMIT;

SELECT *
FROM @tmp;