From: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp> |
---|---|
To: | Huong Dangminh <huo-dangminh(at)ys(dot)jp(dot)nec(dot)com>, Heikki Linnakangas <hlinnaka(at)iki(dot)fi> |
Cc: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>, Hiroshi Yanagisawa <hir-yanagisawa(at)ut(dot)jp(dot)nec(dot)com> |
Subject: | Re: [psqlODBC 09.05.0100] could not insert SQLINTEGER to bytea column |
Date: | 2016-04-25 23:24:22 |
Message-ID: | 571EA726.9000101@dream.email.ne.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi Huong,
Unfortunately I don't know details about commits referenced.
However I'm suspicious if calling sqltype_to_bind_pgtype() is rather
dangerous.
regards,
Hiroshi Inoue
On 2016/04/25 15:50, Huong Dangminh wrote:
> Hi,
>
> First of all, many thanks for releasing version of 09.05.021
> Which does not necessary to install VC++ 2013 runtime environment.
>
> So, we are trying to use version of 09.05.021 now, but have faced
> with another problem, could you confirm the belows for me?
>
> [problem]
> In 09.03.0400 we have no problem when insert into PostgreSQL bytea column with SQLINTEGER data type.
> But in 09.05.0210 it was returned with below error:
>
> ERROR: column "id" is of type bytea but expression is of type integer;
>
> [confirmation]
> (1) It is seem come from the below release, is that right?
>
> ---psqlODBC 09.05.0100 Release---
> 10. Fix quoting bugs in sending integer query parameters to server
> The drivers used to assume that if a parameter's SQL type is SQL_INTEGER or SQL_SMALLINT,
> the value does not require quoting when its send to the server. For example, "SELECT ?",
> with parameter 123 was translated to "SELECT 123", when UseServerSidePrepare was not enabled.
> However, there was no check that the query parameter in fact contained a valid integer,
> when replacing the parameter markers with their values. Also, in a query like "SELECT 0-?",
> a negative value needs to have parens around it, as in "SELECT 0-(-123)".
> ---
>
> (2) Does the above release was made for below commit?
>
> http://git.postgresql.org/gitweb/?p=psqlodbc.git;a=commitdiff;h=1ccd04c70b8037b268eefcaae09ce131c8c33b59
>
> (3) But we found exactly the below commit made obove ERROR.
> As the release note, does this commit completely did the thing which not yet done in commit in (2) sir?
>
> http://git.postgresql.org/gitweb/?p=psqlodbc.git;a=commitdiff;h=085e9324eb5a592f3b73f594311819cbf8dc5f2d
>
> Thanks and best regards,
> Dang Minh Huong
> NEC Solution Innovators, Ltd.
> http://www.nec-solutioninnovators.co.jp/en/
From | Date | Subject | |
---|---|---|---|
Next Message | durga prasad | 2016-04-25 23:35:31 | Installing and configuring postgreSQL ODBC on Solaris10 |
Previous Message | Huong Dangminh | 2016-04-25 06:50:56 | [psqlODBC 09.05.0100] could not insert SQLINTEGER to bytea column |