|
HQL: select priceCatalogue from PriceCatalogue priceCatalogue where priceCatalogue.status = ?1 and locate(?2,concat(concat(?3,priceCatalogue.businessTypes),?4))-1 >= ?5
TransToSql: ....where pricecatal4_.status = ? and instr(?||pricecatal4_.business_types||?,?) -1 >= ?
paramSet:
query.setParameter(1, Boolean.TRUE);
query.setParameter(2, ",B401,");
query.setParameter(3, ",");
query.setParameter(4, ",");
query.setParameter(5, 0);
and result is incorrect.
Data:['10,11', '11,12', 'B401,B402'], just want to find 'B401,B402'
|
