First of all, the delete statement for the Person table seems to be executed twice.
That sounds like a bug. You can recode your Pull Request to prove that and open a Jira issue.
Second, which benefit does the HT_ table provide, why not just executing this:
Because this is also used for JOINED inheritance where if you delete by a baseclass column, you won;t be ale to run that condition against the subclass tables. Hence, the same strategy is used for TALE_PER_CLASS, which, in terms of performance, is the worst inheritance strategy to use anyway.
Btw. with H2 an error occurs:
Please open a Jira issue for that too with a Pull Request that proves it.
Thanks.