Re: [ODBC] Re: A possible bug candidate in the 9.6.0411 when usingthe ServerSidePrepare option - Mailing list pgsql-odbc

From Matej Mihelič
Subject Re: [ODBC] Re: A possible bug candidate in the 9.6.0411 when usingthe ServerSidePrepare option
Date
Msg-id 07023635bbd74b739bfa1a28e83aa698@neosys.si
Whole thread Raw
In response to Re: [ODBC] Re: A possible bug candidate in the 9.6.0411 when usingthe ServerSidePrepare option  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
List pgsql-odbc

Good morning.

 

I've made a quick test, and I am unable to trigger the error.

I've asked my colleagues to start using this version, and I'll get back to you if they encounter any issues during the day.

 

Thank you, Matej.

 

From: Inoue, Hiroshi [mailto:h-inoue@dream.email.ne.jp]
Sent: Friday, August 11, 2017 1:24 AM
To: Matej Mihelič <Matej.Mihelic@neosys.si>
Cc: pgsql-odbc@postgresql.org
Subject: Re: [ODBC] Re: A possible bug candidate in the 9.6.0411 when using the ServerSidePrepare option

 

Hi Matej,

On 2017/08/10 17:47, Inoue, Hiroshi wrote:

Hi Matej,

Thanks for your report.
I would examine the issue.


Could you please try the test drivers 9.6.0412 at
  http://www.ne.jp/asahi/inocchichichi/entrance/psqlodbc/
?

regards,
Hiroshi Inoue


regards,
Hiroshi Inoue

On 2017/08/10 15:11, Matej Mihelič wrote:

* A possible bug candidate in the 9.6.0411 when using the ServerSidePrepare option

Hi.

The statement bellow will trigger a false error. This error disappears if I disable the ServerSidePrepare option in the driver, or if I quote the table column names. I guess something is triggered by the presence of the dollar sign within the column name.

I was doing the tests using the 32-bit Unicode 9.6.0411 build.

[11.969]STATEMENT ERROR: func=build_libpq_bind_params, desc='', errnum=32, errmsg='Parameters exist but IPD isn't set. Please call SQLDescribeParam()'
[11.969]                 ------------------------------------------------------------
[11.969]                 hdbc=07198568, stmt=071647C0, result=00000000
[11.969]                 prepare=8, external=1
[11.969]                 bindings=00000000, bindings_allocated=0
[11.969]                 parameters=00000000, parameters_allocated=0
[11.969]                 statement_type=5, statement='create or replace view neo.vw_el_bn_dbvtlj as
   select
     D.T$SUNO as dbvtlj_id,
     D.T$NAMA as ime_1,
     D.T$NAMB as ime_2,
     D.T$NAMC as nslv_1,
     D.T$NAMD as nslv_2,
     D.T$NAME as mst_1,
     D.T$NAMF as mst_2,
     D.T$PSTC as pst_st,
     D.T$COMP as pdj,
     D.T$CBRN as djvnst,
     D.T$CBAN as bnk,
     D.T$FOVN as dvcn_st,
     D.T$CBAN as priv_rac,
     D.T$CCTY as drzava,
     D.T$TELP as telefon,
     D.T$TELX as telex,
     D.T$TEFX as faks,
     D.T$REFS as kontakt,
     D.T$CDEC as pogoj_dost,
     D.T$PAYM as met_plac,
     D.T$SUST as stat_dob,
     D.T$CCON as skrbnik_id,
     D.T$CPAY as plc_pgj_id,
     D.t$cfsg as cfsg,
     D.T$MAIL as email
     from neo.el_bn_dbvtlj as D
;
'
[11.969]                 stmt_with_params='(NULL)'
[11.969]                 data_at_exec=-1, current_exec_param=-1, put_data=0
[11.969]                 currTuple=-1, current_col=-1, lobj_fd=-1
[11.969]                 maxRows=0, rowset_size=1, keyset_size=0, cursor_type=0, scroll_concurrency=1
[11.969]                 cursor_name='SQL_CUR071647C0'
[11.969]                 ----------------QResult Info -------------------------------
[11.969]CONN ERROR: func=build_libpq_bind_params, desc='', errnum=0, errmsg='(NULL)'
[11.969]            ------------------------------------------------------------
[11.985]            henv=071D1088, conn=07198568, status=3, num_stmts=16
[11.985]            pqconn=0717ADA0, stmts=0715E4C0, lobj_type=-999

-- Regards, Matej.

pgsql-odbc by date:

Previous
From: "Inoue, Hiroshi"
Date:
Subject: Re: [ODBC] Re: A possible bug candidate in the 9.6.0411 when usingthe ServerSidePrepare option
Next
From: "Asif Shaikh"
Date:
Subject: [ODBC] Postgre driver(9.06.04.00) connected to Amazon redshift, is returning wrongcount in SQLRowCount