I can't reproduce such a problem with the latest versions of jOOQ. Can you confirm this still happens with jOOQ 3.14? If so, can you please provide more information on how to reproduce this? We have a template here to help create MCVEs (minimal complete verifiable examples): https://github.com/jOOQ/jOOQ-mcve
Thanks, Lukas On Fri, Oct 30, 2020 at 6:30 PM Lukas Eder <[email protected]> wrote: > Thanks, I'll try to reproduce this and your other issue early next week. > > Best Regards, > Lukas > > On Fri, Oct 30, 2020 at 6:05 PM Maurizio <[email protected]> > wrote: > >> The versions I'm using, as requested: >> >> jOOQ: 3.13.5 >> Java: compiling with jvm_target_version=1.8, and running with Java 11.0.8 >> Database: PostgreSQL server 10.9 >> OS: Ubuntu 20.04.1 LTS 64-bit >> JDBC driver: 'org.postgresql.Driver' >> >> Thanks, >> >> Maurizio. >> On Friday, 30 October 2020 at 17:26:50 UTC+1 [email protected] wrote: >> >>> Hi Maurizio, >>> >>> Thank you very much for your message. >>> >>> Can you please provide a few versions to help reproduce this: >>> >>> - jOOQ: >>> - Java: >>> - Database (include vendor): >>> - OS: >>> - JDBC Driver (include name if inofficial driver): >>> >>> Thanks, >>> Lukas >>> >>> On Fri, Oct 30, 2020 at 1:51 PM Maurizio <[email protected]> wrote: >>> >>>> Hello, once more. >>>> >>>> This is an issue that I had for some time, even if I could work around >>>> it. >>>> In my database, I have a UDT defined as >>>> >>>> >>>> >>>> >>>> >>>> *CREATE TYPE public.arrangement_track_bar_index AS( >>>> arrangement_track_id uuid, bar_index integer);* >>>> >>>> It's used in a table defined as: >>>> >>>> >>>> >>>> >>>> >>>> *CREATE TABLE public.arrangement_version(arrangement_version_id uuid >>>> NOT NULL,name character varying(128) COLLATE pg_catalog."default" NOT >>>> NULL,-- HERE IT COMES:* >>>> >>>> >>>> >>>> >>>> *composition arrangement_track_bar_index[] NOT NULL,creator_user_id >>>> uuid NOT NULL,creation_timestamp timestamp with time zone NOT >>>> NULL,parent_arrangement_version_id uuid,-- etc...* >>>> *)* >>>> >>>> When I fetch a Record, the corresponding field (*composition*) is >>>> null. I have to create a view where the array is unnested and fetch the >>>> elements separately from there and then fix the Record manually. >>>> >>>> Could you help me to understand what is happening? >>>> >>>> I can successfully and correctly perform an insert in the same table >>>> without data loss. >>>> >>>> This issue is unrelated to the one described in my previous message. >>>> >>>> Thanks, >>>> >>>> Maurizio. >>>> >>>> -- >>>> 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/e68801b2-f6c7-4cb4-a9f7-f3fbb6a7b977n%40googlegroups.com >>>> <https://groups.google.com/d/msgid/jooq-user/e68801b2-f6c7-4cb4-a9f7-f3fbb6a7b977n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> -- >> 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/05a19f8c-2d10-4462-81a9-d2d13c4ea361n%40googlegroups.com >> <https://groups.google.com/d/msgid/jooq-user/05a19f8c-2d10-4462-81a9-d2d13c4ea361n%40googlegroups.com?utm_medium=email&utm_source=footer> >> . >> > -- 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/CAB4ELO6szFhmFPPL86_YjObfjnUwyM2j82jVVWkUJ7u0F3OHdQ%40mail.gmail.com.
