Đây là lỗi e gặp phải
Caused by: java.sql.SQLException: Operand should contain 1 column(s)
Đây là code của em
@Query(nativeQuery = true, value = "SELECT COUNT(DISTINCT vesseltypemaster.vesseltypedesc) FROM vesselmaster " +
"INNER JOIN vesseltypemaster ON vesseltypemaster.vesseltypecode=vesselmaster.vesseltypecode " +
"INNER JOIN fleetmapping ON fleetmapping.vslcode=vesselmaster.vesselcode " +
"WHERE 1 = 1 " +
"AND (:search IS NULL OR vesseltypemaster.vesseltypedesc LIKE %:search%) " +
"AND (:fleetCodeList IS NULL OR fleetmapping.fleetcode IN :fleetCodeList) " +
"AND (:vesselMasterList IS NULL OR vesselmaster.vesselcode IN :vesselMasterList) " +
"AND vesselmaster.active_status='a' and fleetmapping.active_status='a'")
int countVesselTypeMastersForChecklist(
@Param("search") String search,
@Param("fleetCodeList") List<String> fleetCodeList,
@Param("vesselMasterList") List<String> vesselMasterList
);