Let expression in <forcedType/> match PostgreSQL domains

[axelfontaine]

Currently a column defined as

create table mytab (
  mycol mydomain
);

has to be matched to the underlying type of the domain, say text, instead of the name of the domain, in this case mydomain.

[lukaseder]

Related idea: Match the content of CHECK constraints: #8843

[lukaseder]

Finally looking into this now. It seems it already works? There had been a few improvements related to supporting UDTs in the code generator, so unsurprisingly, this now works for domains, too, at least in PostgreSQL. Will add integration tests for at least these dialects, too:

• Firebird
• H2
• HSQLDB
• PostgreSQL
• SQL Server
• YugabyteDB

Note:

• Oracle 23c will also support domains, see Add SQLDialect.ORACLE23C #14011, but this probably won't fit in jOOQ 3.18 anymore.

[lukaseder]

Yep, it works out of the box in all dialects, probably since jOOQ 3.14, when DOMAIN type support was added in jOOQ: #681.

Closing as duplicate of #681