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/f323c750-9c60-3cf8-c120-ecd74b6b18e1%40gmail.com.
