Hi All Please suggest what is going wrong here, we are running some query with where and IN clause using Jooq:
e.g : select snapshot_hour.hour_time from snapshot_hour where snapshot_hour.hour_time in ({ts '2023-09-24 02:00:00.0'}, {ts '2023-09-24 03:00:00.0'}, {ts '2023-09-24 04:00:00.0'}) final Set<LocalDateTime> setTime = transaction.select(toTable.snapshotTime()).from(toTable.snapshotTable()) .where(toTable.snapshotTime().in(snapTime.keySet())).fetchSet(toTable.snapshotTime()); I tried to debug the logs I found logger listener is printing: Fetched row(s) = 1 but if i run this generated query on table its return multiple records, Any pointer how can i debug or fix this issue? I will appreciate any response here. Thank you Mpanwar -- 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/6abbefe7-59b3-4bba-9704-e32a8b407083n%40googlegroups.com.