Meta should not produce precision 131089 for PostgreSQL numeric types without precision

[lukaseder]

The JDBC backed Meta implementation produces a precision of 131089 for a table like this:

create table t (implicit_precision text)

This is what the JDBC driver produces, too:

try (Statement s = connection.createStatement()) {
    try {
        s.executeUpdate("create table t (implicit_precision text)");
        try (ResultSet rs = connection.getMetaData().getColumns(null, "public", "t", "%")) {
            while (rs.next()) {
                System.out.println(rs.getInt(7));
            }
        }
    }
    finally {
        s.executeUpdate("drop table if exists t");
    }
}

See also:

• What's the meaning of the COLUMN_SIZE 131089 for NUMERIC types without precision? pgjdbc/pgjdbc#2187
• Numeric precision should not be 131089 pgjdbc/pgjdbc#2188

We should ignore that precision.

[lukaseder]

The current state of discussion is that pgjdbc seems to fix this. I'm postponing any action here for now. It won't go into 3.15.0. If this gets fixed, it will be backported to a 3.15.x release.

[lukaseder]

pgjdbc/pgjdbc#2188 was fixed by removing the "magic" COLUMN_SIZE value 131089 for NUMERIC column types, meaning I won't fix this issue in jOOQ.