From: | John Kew <jkew(at)tableau(dot)com> |
---|---|
To: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp> |
Cc: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: Re: 9.0.5 issue - duplicate rows returned when using SQL_ATTR_ROW_ARRAY_SIZE attribute |
Date: | 2016-01-22 16:40:17 |
Message-ID: | CY1PR0301MB19789503BA20C2E1D15BDE19CCC40@CY1PR0301MB1978.namprd03.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
We would be happy to.
-John
________________________________
From: Inoue, Hiroshi <h-inoue(at)dream(dot)email(dot)ne(dot)jp>
Sent: Friday, January 22, 2016 4:08 AM
To: John Kew
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] 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
From | Date | Subject | |
---|---|---|---|
Next Message | Inoue, Hiroshi | 2016-01-23 12:43:09 | Re: Re: 9.0.5 issue - duplicate rows returned when using SQL_ATTR_ROW_ARRAY_SIZE attribute |
Previous Message | Inoue, Hiroshi | 2016-01-22 12:08:07 | Re: Re: 9.0.5 issue - duplicate rows returned when using SQL_ATTR_ROW_ARRAY_SIZE attribute |