|
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'
|