diff options
| author | mskold@mysql.com <> | 2006-06-02 07:26:45 +0200 |
|---|---|---|
| committer | mskold@mysql.com <> | 2006-06-02 07:26:45 +0200 |
| commit | 39b50ce0d2592d066534311697e8b6309567951f (patch) | |
| tree | 7ca1918d7c36ccdf31d0128f0777f63896bce3a5 /mysql-test/r | |
| parent | 48a568cef62c3ed64300c8c8563d61f777078eff (diff) | |
| download | mariadb-git-39b50ce0d2592d066534311697e8b6309567951f.tar.gz | |
Bug #18864 TRUNCATE TABLE doesn't reset AUTO_INCREMENT value on ndb table
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/ndb_truncate.result | 23 |
1 files changed, 16 insertions, 7 deletions
diff --git a/mysql-test/r/ndb_truncate.result b/mysql-test/r/ndb_truncate.result index 38f3a78029c..811e5e3afeb 100644 --- a/mysql-test/r/ndb_truncate.result +++ b/mysql-test/r/ndb_truncate.result @@ -1,14 +1,23 @@ -DROP TABLE IF EXISTS t2; -CREATE TABLE t2 ( -a bigint unsigned NOT NULL PRIMARY KEY, +DROP TABLE IF EXISTS t1, t2; +CREATE TABLE t1 ( +a bigint unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY, b int unsigned not null, c int unsigned ) engine=ndbcluster; -select count(*) from t2; +select count(*) from t1; count(*) 5000 -truncate table t2; -select count(*) from t2; +select * from t1 order by a limit 2; +a b c +1 509 2500 +2 510 7 +truncate table t1; +select count(*) from t1; count(*) 0 -drop table t2; +insert into t1 values(NULL,1,1),(NULL,2,2); +select * from t1 order by a; +a b c +1 1 1 +2 2 2 +drop table t1; |