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

Hi John,

I can reproduce the case now and have a trial patch.
Could you test it?

regards,
Hiroshi Inoue

On 2016/01/20 21:24, Inoue, Hiroshi wrote:
> Oops I'm sorry.
> I was testing other drivers.
>
> regards,
> Hiroshi Inoue
>
> On 2016/01/20 20:03, Inoue, Hiroshi wrote:
>> 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
>>
>> このメッセージにウイ ルス は検出されませんでした。
>> AVG によってチェックされました - www.avg.com <http://www.avg.com>
>> バージョン： 2015.0.6176 / ウイルスデータベース：4522/11441 - リリー
>> ス日：2016/01/19
>>
>
> このメッセージにウイルス は検出されませんでした。
> AVG によってチェックされました - www.avg.com <http://www.avg.com>
> バージョン： 2015.0.6176 / ウイルスデータベース：4522/11442 - リリース
> 日：2016/01/20
>