yes, when the courseId is passed it might be a match with course_id column value or edu_custom_course_id column value and returns that row. Regarding the fake UUID, yes, the same is being passed to the unit test case to match the data.
Thanks, Deba On Tuesday, June 22, 2021 at 1:12:06 PM UTC-7 [email protected] wrote: > From the original post > > 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 > ('a32ba478-90d9-4c7c-85e9-2899bddab41f', > 'a32ba478-90d9-4c7c-85e9-2899bddab42f') and > (`content_management`.`edu_course_content`.`course_id` = ' > *132ba478-90d9-4c7c-85e9-2899bddab41f*' or > `content_management`.`edu_course_content`.`edu_custom_course_id` = ' > *132ba478-90d9-4c7c-85e9-2899bddab41f*')) > > is it expected that the first course_id value will be used twice from the > input data? > > > 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 > > Looks like your faking UUIDs! This can lead to confusion. > -- 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/a2014024-b2fd-4489-9e3e-b3c1ab0699e5n%40googlegroups.com.
