[Biojava-dev] DeleteStyle in BioSQL using mysql

[Len Trigg]

Simon Foote wrote:
> The "using" syntax is valid as it pertains to cascading deletes. 
> The deletes function correctly with MySQL version 4.0.14 using InnoDb 
> tables in my test cases.

I put in the version checking, and both mysql and hsqldb fail on the
deletion statement with (hsqldb):

Caused by: java.sql.SQLException: Column not found: SEQFEATURE_ID in
statement [delete from location  where location.seqfeature_id =
seqfeature.seqfeature_id and    seqfeature.bioentry_id = 19]

or (mysql 3.23.56):

Caused by: java.sql.SQLException: General error,  message from server:
"Unknown table 'seqfeature' in where clause"
 

Does this mean that the DELETE_GENERIC implementation is going to have
to lookup the relevant seqfeature_id's and remove each location
separately?  My SQL knowledge is pretty basic, so I'm learning as I go
along... (A quick two line explanation of what the "on delete cascade"
stuff means also wouldn't go astray :-)).


Cheers,
Len.