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

Поиск
Список
Период
Сортировка
От Inoue, Hiroshi
Тема Re: Re: 9.0.5 issue - duplicate rows returned when using SQL_ATTR_ROW_ARRAY_SIZE attribute
Дата
Msg-id 569F7C94.6010203@dream.email.ne.jp
обсуждение исходный текст
Ответ на Re: Re: 9.0.5 issue - duplicate rows returned when using SQL_ATTR_ROW_ARRAY_SIZE attribute  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
Ответы Re: Re: 9.0.5 issue - duplicate rows returned when using SQL_ATTR_ROW_ARRAY_SIZE attribute  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
Список pgsql-odbc
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
バージョン: 2015.0.6176 / ウイルスデータベース:4522/11441 - リリース日:2016/01/19


В списке pgsql-odbc по дате отправления:

Предыдущее
От: "Inoue, Hiroshi"
Дата:
Сообщение: Re: Re: 9.0.5 issue - duplicate rows returned when using SQL_ATTR_ROW_ARRAY_SIZE attribute
Следующее
От: Raiford@labware.com
Дата:
Сообщение: Re: [Raiford@labware.com: Re: float8 column size defined as 15 instead of 53?]