Method patchRecord

jOOQ/src/main/java/org/jooq/impl/JSONReader.java:247–367

(
        DSLContext ctx,
        ConverterContext cc,
        boolean multiset,
        Fields result,
        List<Object> record
    )

    static final Pattern         P_NON_STRING_PREFIX   = Pattern.compile("^(?s:[\\[{\"0-9].*|true|false|null)$");

    private static final List<Object> patchRecord(
        DSLContext ctx,
        ConverterContext cc,
        boolean multiset,
        Fields result,
        List<Object> record
    ) {
        for (int i = 0; i < result.fields().length; i++) {
            Field<?> field = result.field(i);
            Object value = record.get(i);
            DataType<?> t = field.getDataType();

            // [#19606] String values need to be quoted
            if (t.isJSON() && value instanceof String s) {










                record.set(i, toJSONString(s));
            }

            // [#8829] LoaderImpl expects binary data to be encoded in base64,
            //         not according to org.jooq.tools.Convert
            else if (t.isBinary() && value instanceof String s) {
                if (multiset) {
                    Matcher m;

                    // [#12134] PostgreSQL encodes binary data as hex
                    // TODO [#13427] This doesn't work if bytea_output is set to escape
                    if (ENCODE_BINARY_AS_HEX.contains(ctx.dialect()))
                        if (s.startsWith("\\x"))
                            record.set(i, convertHexToBytes(s, 1, Integer.MAX_VALUE));
                        else
                            record.set(i, convertHexToBytes(s));

                    // [#12134] [#18955] MariaDB encodes binary data as text (?) but we
                    //                   encode it explicitly as base64 for MULTISET usage
                    // [#12134] [#18876] MySQL encodes binary data as prefixed base64
                    // - type15: VARBINARY
                    // - type16: BIT
                    // - type249: TINYBLOB
                    // - type250: MEDIUMBLOB and LONG VARBINARY
                    // - type251: LONGBLOB
                    // - type252: BLOB
                    // - type254: BINARY
                    else if (ctx.family().category() == SQLDialectCategory.MYSQL
                            && (m = P_MYSQL_BINARY_PREFIX.matcher(s)).matches())
                        record.set(i, Base64.getDecoder().decode(m.replaceFirst("$1")));
                    else
                        record.set(i, Base64.getDecoder().decode(s));
                }
                else