client v2 query result get by reader.next() error

[YoKv]

in my case (BI)，column is not certain

error result

query by reader.next() data repeat
list data id is 5,4,5,4,5

Expected behaviour

list data id is 1,2,3,4,5

Code example

        List<Map<String, Object>> list = new ArrayList<>();
        var response = client.query("select id,timestamp_column from `ods_table_datetime_table` limit 0,10", querySettings).get();
        var reader = new RowBinaryWithNamesAndTypesFormatReader(response.getInputStream(), response.getSettings(), new BinaryStreamReader.DefaultByteBufferAllocator());
        while (reader.hasNext()) {
            final Map<String, Object> next = reader.next();
            list.add(next);
            System.out.println(next);
            System.out.println(reader.getString("id"));
        }

Error log

Configuration

Environment

• Client version: 0.7.2
• Language version: java 17

[chernser]

Good day, @YoKv!

The 'next()will return a reference to a map that stores current record. I will add a warning about it to javadoc of this method. After getting map fromnext()you need to copy values to another map. You can achieve this by callingcom.clickhouse.client.api.data_formats.internal.AbstractBinaryFormatReader#readRecord` which accepts user created map.