MariaDB [test]> create table test1 (id int not null primary key,value char(1)

    -> )engine=innodb with system versioning;

Query OK, 0 rows affected (0.109 sec)

MariaDB [test]> insert into test1 values (1,'a'),(2,'b');

Query OK, 2 rows affected (0.006 sec)

Records: 2  Duplicates: 0  Warnings: 0

MariaDB [test]> create table test2 (

    -> parent int not null,

    -> foreign key ( parent ) references test1 ( id ) on update cascade on delete cascade

    -> )engine=innodb;

Query OK, 0 rows affected (0.048 sec)

MariaDB [test]> insert into test2 values (1),(2);

Query OK, 2 rows affected (0.011 sec)

Records: 2  Duplicates: 0  Warnings: 0

MariaDB [test]> select * from test2 left join test1 on test2.parent = test1.id;

+--------+------+-------+

| parent | id   | value |

+--------+------+-------+

|      1 |    1 | a     |

|      2 |    2 | b     |

+--------+------+-------+

2 rows in set (0.018 sec)

MariaDB [test]> delete test1.* from test1 where id = 1;

Query OK, 1 row affected (0.008 sec)

MariaDB [test]> select * from test2 left join test1 on test2.parent = test1.id;

+--------+------+-------+

| parent | id   | value |

+--------+------+-------+

|      1 | NULL | NULL  |

|      2 |    2 | b     |

+--------+------+-------+

2 rows in set (0.004 sec)

MariaDB [test]> alter table test1 drop system versioning;

Query OK, 0 rows affected (0.073 sec)

Records: 0  Duplicates: 0  Warnings: 0

MariaDB [test]> delete test1.* from test1 where id = 2;

Query OK, 1 row affected (0.004 sec)

MariaDB [test]> select * from test2 left join test1 on test2.parent = test1.id;

+--------+------+-------+

| parent | id   | value |

+--------+------+-------+

|      1 | NULL | NULL  |

+--------+------+-------+

1 row in set (0.001 sec)