diff options
| author | unknown <osku@127.(none)> | 2005-08-19 11:34:04 +0300 |
|---|---|---|
| committer | unknown <osku@127.(none)> | 2005-08-19 11:34:04 +0300 |
| commit | 4f16ca27eff5780842ba4ec33d629bc1adfeee2f (patch) | |
| tree | f276313543b59c8280712cf9693f68a7c1333f8c /mysql-test/r/innodb.result | |
| parent | dd16ad4e894db1f8b61f50309da80f495500e41a (diff) | |
| parent | 7d423fed1527c498b59cbf2cb7b090b36bf7d0ac (diff) | |
| download | mariadb-git-4f16ca27eff5780842ba4ec33d629bc1adfeee2f.tar.gz | |
Merge osalerma@bk-internal.mysql.com:/home/bk/mysql-5.0
into 127.(none):/home/osku/mysql-5.0
mysql-test/r/innodb.result:
Auto merged
mysql-test/t/innodb.test:
Auto merged
Diffstat (limited to 'mysql-test/r/innodb.result')
| -rw-r--r-- | mysql-test/r/innodb.result | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/r/innodb.result b/mysql-test/r/innodb.result index 91d72045169..bb88c1541ac 100644 --- a/mysql-test/r/innodb.result +++ b/mysql-test/r/innodb.result @@ -2483,3 +2483,26 @@ delete t1 from t1,t2 where f1=f3 and f4='cc'; select * from t1; f1 f2 drop table t1,t2; +CREATE TABLE t1 ( +id INTEGER NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) +) ENGINE=InnoDB; +CREATE TABLE t2 ( +id INTEGER NOT NULL, +FOREIGN KEY (id) REFERENCES t1 (id) +) ENGINE=InnoDB; +INSERT INTO t1 (id) VALUES (NULL); +SELECT * FROM t1; +id +1 +TRUNCATE t1; +INSERT INTO t1 (id) VALUES (NULL); +SELECT * FROM t1; +id +1 +DELETE FROM t1; +TRUNCATE t1; +INSERT INTO t1 (id) VALUES (NULL); +SELECT * FROM t1; +id +1 +DROP TABLE t2, t1; |