truncate_fail.sql 183 B

123456
  1. /* custom error:"monotonic_keys" setting can not be used with TRUNCATE mode*/
  2. USE plato;
  3. INSERT INTO Output WITH (MONOTONIC_KEYS, TRUNCATE)
  4. SELECT * FROM Input
  5. ORDER BY key, subkey;