--source suite/xengine/include/have_xengine.inc

#
# TRUNCATE TABLE
#

########################################
# TODO:
# A part of the test is disabled because
# HANDLER is not supported. If it ever
# changes, the test will complain about
# NOT producing ER_ILLEGAL_HA
########################################

--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings

CREATE TABLE t1 (a INT PRIMARY KEY, b CHAR(8)) ENGINE=xengine;
TRUNCATE TABLE t1;
INSERT INTO t1 (a,b) VALUES (1,'a'), (2,'b'), (3,'c');
TRUNCATE TABLE t1;
SELECT a,b FROM t1;
DROP TABLE t1;

# Truncate resets auto-increment value on the table

CREATE TABLE t1 (a INT KEY AUTO_INCREMENT, c CHAR(8)) ENGINE=xengine;

#--replace_column 2 # 3 # 4 # 5 # 6 # 7 # 8 # 9 # 10 # 12 # 13 # 14 # 15 # 16 # 17 # 18 #
--replace_column 5 # 6 # 7 # 12 # 13 # 14 #
SHOW TABLE STATUS LIKE 't1';

INSERT INTO t1 (c) VALUES ('a'),('b'),('c');
#--replace_column 2 # 3 # 4 # 5 # 6 # 7 # 8 # 9 # 10 # 12 # 13 # 14 # 15 # 16 # 17 # 18 #
--replace_column 5 # 6 # 7 # 12 # 13 # 14 #
SHOW TABLE STATUS LIKE 't1';

TRUNCATE TABLE t1;
#--replace_column 2 # 3 # 4 # 5 # 6 # 7 # 8 # 9 # 10 # 12 # 13 # 14 # 15 # 16 # 17 # 18 #
--replace_column 5 # 6 # 7 # 12 # 13 # 14 #
SHOW TABLE STATUS LIKE 't1';

INSERT INTO t1 (c) VALUES ('d');
#--replace_column 2 # 3 # 4 # 5 # 6 # 7 # 8 # 9 # 10 # 12 # 13 # 14 # 15 # 16 # 17 # 18 #
--replace_column 5 # 6 # 7 # 12 # 13 # 14 #
SHOW TABLE STATUS LIKE 't1';

--sorted_result
SELECT a,c FROM t1;
DROP TABLE t1;

# Truncate closes handlers

CREATE TABLE t1 (a INT PRIMARY KEY, b CHAR(8)) ENGINE=xengine;
INSERT INTO t1 (a,b) VALUES (1,'a'),(2,'b'),(3,'c');

--error ER_ILLEGAL_HA
HANDLER t1 OPEN AS h1;

--disable_testcase BUG#0

HANDLER h1 READ FIRST;
TRUNCATE TABLE t1;
--error ER_UNKNOWN_TABLE
HANDLER h1 READ NEXT;
HANDLER t1 OPEN AS h2;
HANDLER h2 READ FIRST;

--enable_testcase

DROP TABLE t1;

--source suite/xengine/include/check_xengine_log_error.inc