Ayuda con relaciones

[huesos52]

Código mysql:

mysql> create table relaciones(id integer primary key);
Query OK, 0 rows affected (0.00 sec)
 
mysql> create table relaciones1(id integer, foreign key (id) references relaciones(id) on delete cascade on update cascade);
Query OK, 0 rows affected (0.00 sec)
 
mysql> create table relaciones2(id integer, foreign key (id) references relaciones1(id) on delete cascade on update cascade);
Query OK, 0 rows affected (0.02 sec)
 
mysql> insert into relaciones values(1);
Query OK, 1 row affected (0.00 sec)
 
mysql> insert into relaciones values(2);
Query OK, 1 row affected (0.00 sec)
 
mysql> insert into relaciones values(3);
Query OK, 1 row affected (0.00 sec)
 
mysql> insert into relaciones1 values(2);
Query OK, 1 row affected (0.00 sec)
 
 mysql> insert into relaciones2 values(2);
Query OK, 1 row affected (0.00 sec)
 
mysql> start transaction;
Query OK, 0 rows affected (0.00 sec)
 
mysql> delete from relaciones;
Query OK, 3 rows affected (0.00 sec)
 
mysql> select *from relaciones1;
Empty set (0.00 sec)
 
mysql> select *from relaciones2;
Empty set (0.00 sec)
 
mysql> rollback;
Query OK, 0 rows affected (0.00 sec)
 
mysql> select *from relaciones2;
+------+
| id   |
+------+
|    2 |
+------+
1 row in set (0.00 sec)
 
mysql> select *from relaciones1;
+------+
| id   |
+------+
|    2 |
+------+
1 row in set (0.00 sec)
 
mysql> select *from relaciones;
+----+
| id |
+----+
|  1 |
|  2 |
|  3 |
+----+
3 rows in set (0.00 sec)
 
mysql>
 

Que raro. Acabo de probar y no presenta error.
Puedes describir mas detalladamente tu problema?