So, in your test file... On Tue, Jun 22, 2021 at 7:50 PM Debapriya Patra <debapriya.pa...@gmail.com> wrote:
> > #testGetCourseContentsByContentIds > select `content_management`.`edu_course_content`.`course_id`, > `content_management`.`edu_course_content`.`edu_custom_course_id`, > `content_management`.`edu_course_content`.`edu_content_id` from > `content_management`.`edu_course_content` where > (`content_management`.`edu_course_content`.`edu_content_id` in (?, ?) and > (`content_management`.`edu_course_content`.`course_id` = ? or > `content_management`.`edu_course_content`.`edu_custom_course_id` = ?))]; > Invalid SQL: select `content_management`.`edu_course_content`.`course_id`, > `content_management`.`edu_course_content`.`edu_custom_course_id`, > `content_management`.`edu_course_content`.`edu_content_id` from > `content_management`.`edu_course_content` where > (`content_management`.`edu_course_content`.`edu_content_id` in (?, ?) and > (`content_management`.`edu_course_content`.`course_id` = ? or > `content_management`.`edu_course_content`.`edu_custom_course_id` = ?)); > > seq course_id edu_custom_course_id edu_content_id > > ----- ------------------------------------- ----------------------- > -------------------------------------- > > 1 132ba478-90d9-4c7c-85e9-2899bddab41f null > a32ba478-90d9-4c7c-85e9-2899bddab41f > > 2 132ba478-90d9-4c7c-85e9-2899bddab41e null > a32ba478-90d9-4c7c-85e9-2899bddab42f > @ rows: 2 > You put the error message in there "Invalid SQL ..." Meaning your original SQL query never matches any expected query in the test file. I mean, we can improve the error message and replace "Invalid SQL" by "SQL statement not matched by any statement in the MockFileDatabase", but the rest still remains. It's not possible to help you spot that particular mistake. The input simply doesn't match any content I hope this helps, Lukas -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO6KBR%3DPi5J6RQPX%2BfBKW33TaLdKmU%3DTiy5xNHDs%2BbSoyA%40mail.gmail.com.
