summaryrefslogtreecommitdiff
path: root/mysql-test/r/ndb_truncate.result
diff options
context:
space:
mode:
authorunknown <magnus@neptunus.(none)>2004-08-04 11:28:36 +0200
committerunknown <magnus@neptunus.(none)>2004-08-04 11:28:36 +0200
commit94a1e48232184a25837e49fc01120228e5ff7860 (patch)
tree39130a79f04ed16342a5921f116d38f1145628ed /mysql-test/r/ndb_truncate.result
parent92498f81dbc94cd9327b431f4456e17fc8dddb8f (diff)
downloadmariadb-git-94a1e48232184a25837e49fc01120228e5ff7860.tar.gz
BUG#4892 TRUNCATE TABLE returns error 156
Added NDBCLUSTER to table types which does not support generate. Added test case for truncate. sql/handler.h: Add NDBCLUSTER to table types that does not support generate.
Diffstat (limited to 'mysql-test/r/ndb_truncate.result')
-rw-r--r--mysql-test/r/ndb_truncate.result14
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/ndb_truncate.result b/mysql-test/r/ndb_truncate.result
new file mode 100644
index 00000000000..38f3a78029c
--- /dev/null
+++ b/mysql-test/r/ndb_truncate.result
@@ -0,0 +1,14 @@
+DROP TABLE IF EXISTS t2;
+CREATE TABLE t2 (
+a bigint unsigned NOT NULL PRIMARY KEY,
+b int unsigned not null,
+c int unsigned
+) engine=ndbcluster;
+select count(*) from t2;
+count(*)
+5000
+truncate table t2;
+select count(*) from t2;
+count(*)
+0
+drop table t2;