diff options
| author | unknown <serg@serg.mylan> | 2004-07-20 00:53:24 +0200 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2004-07-20 00:53:24 +0200 |
| commit | eee5f15b92f71c74ce315932770a603e4deef477 (patch) | |
| tree | b39cfbb54d66b05cd075839aa58dc3215c8d4146 /mysql-test/t/innodb.test | |
| parent | d57d78ac10980e28344f285bdbc986fa3ee3496e (diff) | |
| parent | b940ae1012b00e74e2155c4e35ca7872bed278e3 (diff) | |
| download | mariadb-git-eee5f15b92f71c74ce315932770a603e4deef477.tar.gz | |
manual merged (blame me!)
Build-tools/Do-compile:
Auto merged
Docs/Makefile.am:
Auto merged
innobase/btr/btr0cur.c:
Auto merged
innobase/include/lock0lock.h:
Auto merged
innobase/include/row0mysql.h:
Auto merged
innobase/include/srv0srv.h:
Auto merged
innobase/include/sync0arr.h:
Auto merged
innobase/include/trx0trx.h:
Auto merged
innobase/lock/lock0lock.c:
Auto merged
innobase/srv/srv0srv.c:
Auto merged
innobase/srv/srv0start.c:
Auto merged
innobase/sync/sync0arr.c:
Auto merged
innobase/trx/trx0trx.c:
Auto merged
sql/ha_innodb.cc:
Auto merged
sql/sql_insert.cc:
Auto merged
mysql-test/r/innodb.result:
to be fixed after the merge
Diffstat (limited to 'mysql-test/t/innodb.test')
| -rw-r--r-- | mysql-test/t/innodb.test | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/t/innodb.test b/mysql-test/t/innodb.test index e0cc96ccb32..50ab3bdb8bd 100644 --- a/mysql-test/t/innodb.test +++ b/mysql-test/t/innodb.test @@ -960,6 +960,23 @@ update t3 set t3.id=7 where t1.id =1 and t2.id = t1.id and t3.id = t2.id; drop table t3,t2,t1; # +# test for recursion depth limit +# +create table t1( + id int primary key, + pid int, + index(pid), + foreign key(pid) references t1(id) on delete cascade) engine=innodb; +insert into t1 values(0,0),(1,0),(2,1),(3,2),(4,3),(5,4),(6,5),(7,6), + (8,7),(9,8),(10,9),(11,10),(12,11),(13,12),(14,13),(15,14); +-- error 1217 +delete from t1 where id=0; +delete from t1 where id=15; +delete from t1 where id=0; + +drop table t1; + +# # Test timestamps # |