That is why my query has the *or* condition. *(`content_management`.`edu_course_content`.`course_id` = ? or`content_management`.`edu_course_content`.`edu_custom_course_id` = ?)*
*And this is working just that my unit test is breaking when I add this mock data in txt file.* On Tuesday, June 22, 2021 at 11:00:23 AM UTC-7 [email protected] wrote: > On 6/22/21 11:50 AM, Debapriya Patra wrote: > > Here is my mock data file and the last one I have added for a new DAO > > function to test which is causing the error. > > > > #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 > edu_custom_course_id = null is never going to be true. > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/1f5f987c-5d44-47e0-b87a-bc7d83495e66n%40googlegroups.com.
