This issue is now fixed for jOOQ 3.6.0 and will also be merged to 3.5.2. Thanks again for reporting this
Lukas 2014-11-19 8:43 GMT+01:00 Lukas Eder <[email protected]>: > Unfortunately, this cannot be fixed for 3.5.0 any more. There are more > bugs, related to the code generator that doesn't generate the right types > when an enum type exists with the same name in two schemas. Example: > > CREATE TYPE schema_a.u_country AS ENUM ('Brazil', 'England', 'Germany'); > CREATE TYPE schema_b.u_country AS ENUM ('Brazil', 'England', 'Germany'); > CREATE TYPE schema_a.u_address_type AS ( > street VARCHAR(50), > zip VARCHAR(50), > city VARCHAR(50), > country schema_a.u_country > ) > > In our integration tests, the above will generate schema_b.u_country as > the type referenced by schema_a.u_address_type. We'll fix these things > thoroughly in 3.5.1 and the downstream maintenance releases. > > Cheers, > Lukas > > 2014-11-19 8:18 GMT+01:00 Lukas Eder <[email protected]>: > >> Hello, >> >> This is not a regression but a different, similar bug. We simply didn't >> have integration tests for enum array bind variables of cross-schema enum >> references. I've registered an issue for this: >> https://github.com/jOOQ/jOOQ/issues/3778 >> >> I'll see if this can still be fixed in 3.5.0. It'll certainly be merged >> to 3.4, 3.3, and 3.2 >> >> 2014-11-19 6:55 GMT+01:00 Lukas Eder <[email protected]>: >> >>> Hmm, interesting. This might be a regression of >>> https://github.com/jOOQ/jOOQ/issues/2135. I'll investigate, thanks for >>> letting us know. >>> >>> Cheers, >>> Lukas >>> >>> 2014-11-18 19:48 GMT+01:00 Andrej <[email protected]>: >>> >>>> I've ran into the same problem as mentioned above. >>>> I've updated my project to jOOQ 3.4.4, but there is another problem: >>>> SQL [insert into "data"."select_groups" ("group_type", "group_label") >>>> values (?::group_type[], ?) returning "data"."select_groups"."id"]; ERROR: >>>> type "group_type[]" does not exist >>>> >>>> I've tested the sql-code in pgAdmin, the solution was to prefix the >>>> type name with the schema name: ::group_type[] --> ::data.group_type[] >>>> Is there a way, to add this functionality to jOOQ? >>>> >>>> Currently, one workaround is to update the search path: >>>> context.fetch("SET search_path TO data, public;"); >>>> >>>> Best regards, >>>> Andrej >>>> >>>> Am Montag, 28. April 2014 14:34:43 UTC+2 schrieb Lukas Eder: >>>>> >>>>> >>>>> >>>>> >>>>> 2014-04-28 14:08 GMT+02:00 Lukas Eder <[email protected]>: >>>>> >>>>>> Thanks for reporting. Yes, this is a bug. I have registered #3214 for >>>>>> this. >>>>>> https://github.com/jOOQ/jOOQ/issues/3214 >>>>>> >>>>> >>>>> This issue is now fixed on GitHub master and will be released in jOOQ >>>>> 3.4.0, 3.3.2, 3.2.5. >>>>> >>>>> Thanks again for reporting, >>>>> Lukas >>>>> >>>> -- >>>> 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]. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >> > -- 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]. For more options, visit https://groups.google.com/d/optout.
