You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
32 lines
581 B
32 lines
581 B
5 months ago
|
--source include/have_ndb.inc
|
||
|
|
|
||
|
|
#
|
||
|
|
# Test TRUNCATE TABLE
|
||
|
|
# - the table should have no rows after the truncate
|
||
|
|
#
|
||
|
|
CREATE TABLE t1 (
|
||
|
|
a int PRIMARY KEY,
|
||
|
|
b varchar(255)
|
||
|
|
) ENGINE = NDB;
|
||
|
|
|
||
|
|
INSERT INTO t1 (a, b) VALUES
|
||
|
|
(1, "Row 1"),
|
||
|
|
(11, "Row 2"),
|
||
|
|
(12, "The third row"),
|
||
|
|
(37, "And of course number 37");
|
||
|
|
SELECT COUNT(*) FROM t1;
|
||
|
|
|
||
|
|
TRUNCATE TABLE t1;
|
||
|
|
|
||
|
|
# Check that truncated table contains no rows
|
||
|
|
if (`SELECT count(*) from t1`)
|
||
|
|
{
|
||
|
|
die The truncated table contained rows;
|
||
|
|
}
|
||
|
|
SELECT COUNT(*) FROM t1;
|
||
|
|
DROP TABLE t1;
|
||
|
|
|
||
|
|
#
|
||
|
|
# NOTE! Don't add any more tests here, this is the basic test
|
||
|
|
#
|