yql/essentials/tests/sql/suites/insert_monotonic/truncate_fail.sql


1
2
3
4
5
6

/* custom error:"monotonic_keys" setting can not be used with TRUNCATE mode*/
USE plato;

INSERT INTO Output WITH (MONOTONIC_KEYS, TRUNCATE)
SELECT * FROM Input
ORDER BY key, subkey;