sql-tests/inputs/tablesample-negative.sql

0001 -- Negative testcases for tablesample
0002 CREATE DATABASE mydb1;
0003 USE mydb1;
0004 CREATE TABLE t1 USING parquet AS SELECT 1 AS i1;
0005
0006 -- Negative tests: negative percentage
0007 SELECT mydb1.t1 FROM t1 TABLESAMPLE (-1 PERCENT);
0008
0009 -- Negative tests:  percentage over 100
0010 -- The TABLESAMPLE clause samples without replacement, so the value of PERCENT must not exceed 100
0011 SELECT mydb1.t1 FROM t1 TABLESAMPLE (101 PERCENT);
0012
0013 -- reset
0014 DROP DATABASE mydb1 CASCADE;