Re: Re: 9.0.5 issue - duplicate rows returned when using SQL_ATTR_ROW_ARRAY_SIZE attribute

Hi John,

Thanks for the test case.

On 2016/01/20 5:46, John Kew wrote:
>
> Folks,
>
>
> As promised here is a repro of the issue we are seeing using some
> generated data in a temp table. The first query returns the correct
> results for both 9.0.3 and 9.0.5; whereas the second returns the wrong
> results with 9.0.5 only.
>
>
>

The result seems to be right here.

SELECT "postgres_test"."dim1" AS "dim1", "postgres_test"."dim2" AS
"dim2", "postgres_test"."dim3" AS "dim3", "postgres_test"."dim4" AS
"dim4", "postgres_test"."
dim5" AS "dim5", SUM("postgres_test"."meas1") AS "sum:meas1:ok",
"postgres_test"."dim6" AS "dim6" FROM "postgres_test" "postgres_test"
GROUP BY 1, 2, 3, 4, 5, 7

with rowArraySize 1, number of rows returned by query is 120
rows returned by query with rowArraySize=84:
fetchIdx=1, fetched rows=84, total rows=84
fetchIdx=2, fetched rows=36, total rows=120

regards,
Hiroshi Inoue