Method read

jOOQ/src/main/java/org/jooq/impl/ListHandler.java:81–131

(List<?> list)

    }

    final Result<R> read(List<?> list) throws SQLException {
        Result<R> result = new ResultImpl<>(dsl.configuration(), row);

        for (Object o : list)
            result.add(newRecord(true, dsl.configuration(), recordType, row).operate(r -> {
                Object[] attributes =
                    o instanceof ResultSet rs
                  ? read(rs)
                  : o instanceof Struct s
                  ? s.getAttributes()
                  : o instanceof List<?> l
                  ? l.toArray()
                  : null;

                if (attributes != null) {

                    // [#13400] Recurse for nested MULTISET or ROW types
                    for (int i = 0; i < attributes.length && i < row.size(); i++) {
                        DataType<?> t = row.field(i).getDataType();

                        // [#16839] t.getRow() is null for scalar arrays, e.g. ARRAY (SELECT 1)
                        if (t.isMultiset() || t.isArray() && t.getRow() != null) {
                            if (attributes[i] instanceof List<?> l) {

                                // [#18175] We may have already recursed into a ResultSet that produces nested MULTISET
                                if (!(l instanceof Result))
                                    attributes[i] = new ListHandler(dsl, ctx, (AbstractRow<?>) t.getRow(), t.getRecordType()).read(l);
                            }
                            else if (attributes[i] instanceof Array a)
                                attributes[i] = new ListHandler(dsl, ctx, (AbstractRow<?>) t.getRow(), t.getRecordType()).read(asList((Object[]) a.getArray()));

                            // [#18175] JSON or XML MULTISET content may be nested in a ROW expression.
                            else if (attributes[i] instanceof String s)
                                attributes[i] = readMultiset(s, t);
                            else if (attributes[i] instanceof byte[] b)
                                attributes[i] = readMultiset(new String(b), t);
                        }
                        else if (t.isRecord() && (attributes[i] instanceof Struct || attributes[i] instanceof ResultSet))
                            attributes[i] = new ListHandler(dsl, ctx, (AbstractRow<?>) t.getRow(), t.getRecordType()).read(asList(attributes[i])).get(0);
                    }

                    r.fromArray(attributes);
                    r.touched(false);
                    return r;
                }
                else
                    throw new UnsupportedOperationException("No support for reading value " + o);
            }));

        return result;
    }

    @SuppressWarnings("unchecked")
    private final Object readMultiset(String s, DataType<?> t) {