Postgres Pro
Downloads
Home   >   mailing lists

Re: [ODBC] Postgre driver(9.06.04.00) connected to Amazon redshift, isreturning wrong count in SQLRowCount - Mailing list pgsql-odbc

From Asif Shaikh
Subject Re: [ODBC] Postgre driver(9.06.04.00) connected to Amazon redshift, isreturning wrong count in SQLRowCount
Date
Msg-id OF2EEE9C90.581E3981-ON00258183.00419910-65258183.00423B76@notes.na.collabserv.com
Whole thread Raw
In response to Re: [ODBC] Postgre driver(9.06.04.00) connected to Amazon redshift,is returning wrong count in SQLRowCount  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
List pgsql-odbc
Tree view
Hi Hiroshi Inoue,

PFA, my test run logs.



Thanks & Regards
Asif G. Shaikh



From:        "Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>
To:        Asif Shaikh <asif.shaikh@in.ibm.com>
Cc:        pgsql-odbc@postgresql.org
Date:        08/21/2017 02:20 PM
Subject:        Re: [ODBC] Postgre driver(9.06.04.00) connected to Amazon redshift, is returning wrong count in SQLRowCount



Hi,

On 2017/08/21 17:21, Asif Shaikh wrote:
Hi Hiroshi Inoue,

Can you please help me understand where can I find Mylog output for my test.
I could not go to office today as I am still not quite well. I will check with my team member tomorrow about how the old driver worked for him.

If you can edit connection strings, please add *;debug=1* to the connection string.
On Windows You can find mylog_xxxxxx.log under root directory after execution.

regards,
Hiroshi Inoue


Thanks & Regards
Asif G. Shaikh



From:        "Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>
To:        Asif Shaikh <asif.shaikh@in.ibm.com>
Cc:        pgsql-odbc@postgresql.org
Date:        08/18/2017 07:54 PM
Subject:        Re: [ODBC] Postgre driver(9.06.04.00) connected to Amazon redshift, is returning wrong count in SQLRowCount



On 2017/08/18 22:47, Asif Shaikh wrote:
Hi Hiroshi Inoue,

Thanks for the reply and I am sorry for replying late on this.
Actually I was on a sick leave today.

Your statement :-
I see the result * SQLRowCount=2 * here.
--> Yes, this looks to be correct count. In my case, the variable rowc doesn't get any value and still holds the initial value which is -1 in your test program.

One of my team member informed me that he tried the 8.02.05 driver with our application on RHEL and that actually worked whereas the driver 9.06.04 didn't work on the same setup.
So based on what I understood from his that the driver 9.06.04 is not working for him whereas the old driver 8.02.05 works.
Unfortunately, I could not get all the details on this. I will get all the details on this on Monday and will get back to you.

Meanwhile, is it possible for you to test your sample program with driver 9.06.04 to connect to Amazon redshift db and see if that reproduces the issue for you too?

Could take Mylog output of your test and send it to me directly?

regards,
Hiroshi Inoue

Thanks & Regards
Asif G. Shaikh



From:        "Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>
To:        Asif Shaikh <asif.shaikh@in.ibm.com>
Cc:        pgsql-odbc@postgresql.org
Date:        08/17/2017 06:53 PM
Subject:        Re: [ODBC] Postgre driver(9.06.04.00) connected to Amazon redshift, is returning wrong count in SQLRowCount





On 2017/08/17 21:30, Asif Shaikh wrote:
I just built your code on 32 bit and used the 32 bit postgre driver(8.02.05) but still it gave me same issue. :-(
When you tried, did you connect to Amazon redshift using the postgre driver?

I see the result * SQLRowCount=2 * here.
Isn't it an expected result?

Anyway I am testing with my local server
The server's response to the command *select .. into .. from ..* is *SELECT 2*.
If the response of Amazon redshift is different, the driver does nothing.

regards,
Hiroshi Inoue




From:        Asif Shaikh/India/IBM
To:        "Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>
Cc:        pgsql-odbc@postgresql.org
Date:        08/17/2017 05:48 PM
Subject:        Re: [ODBC] Postgre driver(9.06.04.00) connected to Amazon redshift, is returning wrong count in SQLRowCount


Hi Hiroshi Inoue,

I see the same error with the code you sent.
Did you build your application for 64 bit and used  64 bit  postgre driver(9.06.04.00) ?

Thanks & Regards
Asif G. Shaikh


Attachment

pgsql-odbc by date:

Previous
From: "Inoue, Hiroshi"
Date:
Subject: Re: [ODBC] Postgre driver(9.06.04.00) connected to Amazon redshift,is returning wrong count in SQLRowCount
Next
From: "Inoue, Hiroshi"
Date:
Subject: Re: [ODBC] Postgre driver(9.06.04.00) connected to Amazon redshift,is returning wrong count in SQLRowCount