jOOQ

jOOQ copied to clipboard

Oracle + Boolean + null + union all = ORA-01790

4

### Overview In my project I do something like this: ```java dslContext.select(val(null, Boolean.class)) .from(DSL.table("TEST_TABLE")) .unionAll(dslContext .select(DSL.field("NUMBER_1_0_COLUMN")) .from("TEST_TABLE")) .fetch() ``` - but I get ORA-01790 error. SQL-query provided by Select::toString can...

unrealprox

There are numerous issues where compatibility among RDBMS is hard, in case a standard data type needs to be encoded in other RDBMS. This mostly evolves around: - [ ]...

lukaseder

The problem can be illustrated as follows: ```sql create function f(i int) returns int as $$ begin return i; end $$ language plpgsql; create function f(i bigint) returns int as...

lukaseder

Some Record.get(..., Converter) do not pass a ConverterContext to a ContextConverter

1

There are some methods in `AbstractRecord`, such as `AbstractRecord.get(int, Converter)`, which do not pass a `ConverterContext` to a `ContextConverter`, and as such, may produce unexpected results. Here's a correct implementation:...

lukaseder

Add new RecordMapperProvider SPI that also has a Configuration parameter

3

The current `RecordMapperProvider` SPI doesn't pass the `Configuration` parameter, which is useful for caching. If an implementation falls back to returning the `DefaultRecordMapper`, the latter currently cannot be instantiated with...

lukaseder

AbstractName::equals should not call Name::getName, which incurs a String[] allocation

1

There's a potentially expensive `String[]` allocation in `AbstractName::equals`: ```java @Override public boolean equals(Object that) { if (this == that) return true; // [#1626] [#11126] NameImpl equality can be decided without...

lukaseder