Possible compilation errors in generated code when column names contain double quotes

[lukaseder]

A table like this:

create table fields (
  "ID" bigint,
  "X""" bigint,
  primary key ("ID")
);

Can produce compilation errors in generated code, because currently, we're not escaping column names in generated code. We're escaping identifiers almost everywhere else though.

The issue has already been fixed in jOOQ 3.19.0 as part of:

• Enhance API to provide access to UDT members #228

See:

• 896d995#diff-e4e540ae36541b656b055ae8e2064243e0366dab891f27aa7676ee10ccdf2413R6467

This issue is to track backports to the currently maintained minor releases.

[lukaseder]

Fixed in versions:

• 3.19.0
• 3.18.8 (Possible compilation errors in generated code when column names contain double quotes - Merge [#15714] #15715)
• 3.17.17 (Possible compilation errors in generated code when column names contain double quotes - Merge [#15714] #15716)
• 3.16.23 (Possible compilation errors in generated code when column names contain double quotes - Merge [#15714] #15717)

[lukaseder]

ScalaGenerator and KotlinGenerator are also affected in all versions

[lukaseder]

Related problem:

• KotlinGenerator produces compilation error for table named """" #15718