diff options
| author | unknown <osku@127.(none)> | 2005-08-24 09:25:32 +0300 |
|---|---|---|
| committer | unknown <osku@127.(none)> | 2005-08-24 09:25:32 +0300 |
| commit | 1d406fb9a23a982fbcb4090a6b98885974d01a2f (patch) | |
| tree | 63e04bee348736f17a291a4ee18f3bfa8fbd366b /mysql-test/r/innodb.result | |
| parent | 1c35bcb6aef55db72479b10146cdef00c516bf57 (diff) | |
| parent | ef2af68d30accebb3a8abb1b0ad78851c0bc124c (diff) | |
| download | mariadb-git-1d406fb9a23a982fbcb4090a6b98885974d01a2f.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 4b62e63c49b..9253c635cb0 100644 --- a/mysql-test/r/innodb.result +++ b/mysql-test/r/innodb.result @@ -2488,3 +2488,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; |