Deleting accessions
I'm trying to bulk remove Accession
records using accessionRepository.deleteInBatch()
and I'm seeing these delete statements in mysql:
delete from dataset_accessions where (accessionId) in (select id from accession where id=203658 or id=204020 or id=204021 or id=204040 or id=204082 or id=204218 or id=204219 or id=204466 or id=204467 or id=204469 or id=204471 or id=204472 or id=204473 or id=204474 or id=204683 or id=204825 or id=204867 or id=204892 or id=204965 or id=205334 or id=205339 or id=205345 or id=205346 or id=205347 or id=205348 or id=205349 or id=205350 or id=205351 or id=205353 or id=205454 or id=205455 or id=205466 or id=205470 or id=205486 or id=205495 or id=205496 or id=205498 or id=205528 or id=205600 or id=205601 or id=205607 or id=205635 or id=205642 or id=205648 or id=205660 or id=205743 or id=205895 or id=206069 or id=206161 or id=206171 or id=206258 or id=206266 or id=206325 or id=206349 or id=206889 or id=206965 or id=206967 or id=207492 or id=207584 or id=207758 or id=207861 or id=207863 or id=207865 or id=207873 or id=207874 or id=207875 or id=207876 or id=207878 or id=207882 or id=207883 or id=207884 or id=207986 or id=207987 or id=208066 or id=208067 or id=208088 or id=208177 or id=208197 or id=208234 or id=208235 or id=208359 or id=208362 or id=208363 or id=208388 or id=208408 or id=208416 or id=208417 or id=208486 or id=208647 or id=208734 or id=208822 or id=208845 or id=208856 or id=208872 or id=208904 or id=208912 or id=208913 or id=208923 or id=208924 or id=208925 or id=209013 or id=209015 or id=209025 or id=209146 or id=209176 or id=209178 or id=209186 or id=209317 or id=209331 or id=209379 or id=209456 or id=209457 or id=209458 or id=209459 or id=209469 or id=209470 or id=209471 or id=209564 or id=209669 or id=209670 or id=209692 or id=209807 or id=209808 or id=209809 or id=209884 or id=209885 or id=209886 or id=209891 or id=209892 or id=209938 or id=209978 or id=209979 or id=210051 or id=210052 or id=210053 or id=210054 or id=210125 or id=210151 or id=210273 or id=210285 or id=210286 or id=210287 or id=210290 or id=210332 or id=210515 or id=210527 or id=210681 or id=210685 or id=210749 or id=210753 or id=210758 or id=210807 ...)
Accession
doesn't declare any cascade on private List<Dataset> datasets
. Why would this be executed?
Calling accessionRepository.deleteAll(list)
does not show this behavior.
I guess I need to avoid *InBatch()
.