Add MySQL 8 error code for cascade delete

datajoint / datajoint-python

Relational data pipelines for the science lab

https://datajoint.com/docs

GNU Lesser General Public License v2.1

163 stars 83 forks source link

Add MySQL 8 error code for cascade delete #1112

Closed CBroz1 closed 7 months ago

CBroz1 commented 8 months ago

To address #1110, I've added this error code to the set of checks performed by translate_query_error.

To protect against potential issues for MySQL 5.7 users, I checked error code manuals for both 5.7 and 8.0, which indicated that theses error codes would be categorized as IntegrityError across both cases.

Are additional tests required for this change?

lfrank commented 7 months ago

@dimitri-yatsenko Just checking in on this, as it would be really helpful for us to have it merged. Thoughts on when that might be possible?