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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/6abbefe7-59b3-4bba-9704-e32a8b407083n%40googlegroups.com.
