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/393cef62-3bcc-6982-b9a5-912d5fefe7ed%40gmail.com.

Reply via email to