delete from loantradehist where ptrshistid in (select ptrshistid from pvtrshist where pvtrsid = ?);
pvtrshist 表中没有ptrshistid字段,索引它认为这个ptrshistid是从loantradehist中选出来的。
这样in条件就会一直满足,导致悲剧发生了
delete from loantradehist where ptrshistid in (select ptrshistid from pvtrshist where pvtrsid = ?);
pvtrshist 表中没有ptrshistid字段,索引它认为这个ptrshistid是从loantradehist中选出来的。
这样in条件就会一直满足,导致悲剧发生了