ory/hydra

sql: deleting policies does not delete associated records with mysql driver

Closed this issue · 5 comments

In MySQL there are four tables for ladon policies. When deleting a policy, it is only deleted from "ladon_policy" table, but the data for this policy in three other ladon_policy_* tables are not removed.

This happens on MySQL

@johnwu96822 is this a critical issue for you?

@arekkas Yes we have deployed Hydra for testing. If this issue doesn't get fixed and we modify policies (Hydra currently modifies a policy by deleting and recreating it), we'll get a bunch of policy records in those tables and we wouldn't know which record we'd get.

resolved by #329