Bugs item #1010827, was opened at 2010-05-20 18:04
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010827&group_id=1000125
Category: None
Group: None
>Status: Closed
Resolution: None
Priority: 3
Submitted By: Farid Zidan (faridz)
Assigned to: Hiroshi Inoue (hinoue)
Summary: ODBC driver not parsing comment correctly
Initial Comment:
create table test_comment(col1 varchar(20));
/*http://forums.oracle.com/forums/thread.jspa?threadID=1055333&stqc=true*/
insert into test_comment values('abc');
I get the following error using ODBC driver executing the three lines above:
SQL Error. Native Code: 32, SQLState: 07002, Return Code: -1
The # of binded parameters < the # of parameter markers
Correctly, no error is generated if executing the insert using PgAdmin query.
----------------------------------------------------------------------
Comment By: Farid Zidan (faridz)
Date: 2010-05-24 11:11
Message:
Passes my testing. Thanks.
----------------------------------------------------------------------
Comment By: Hiroshi Inoue (hinoue)
Date: 2010-05-24 03:43
Message:
Hmm line comment.
OK please retry the drivers.
----------------------------------------------------------------------
Comment By: Farid Zidan (faridz)
Date: 2010-05-23 01:45
Message:
Thanks. Passes previous tests. However, it fails this new test:
create table test_comment(col1 varchar(20));
--http://forums.oracle.com/forums/thread.jspa?threadID=1055333&stqc=true
insert into test_comment values('abc');
----------------------------------------------------------------------
Comment By: Hiroshi Inoue (hinoue)
Date: 2010-05-23 00:18
Message:
I see.
I changed a suspicious place.
Could you please retry the drivers?
----------------------------------------------------------------------
Comment By: Farid Zidan (faridz)
Date: 2010-05-21 12:27
Message:
Re-tested with the given driver from link. It is now giving errors on what
previously did not generate errors. Example,
/*==============================================================*/
/* DBMS name: PostgreSQL 7.3 */
/* Created on: 5/20/2010 2:07:58 PM */
/*==============================================================*/
select 1
SQL Error. Native Code: 32, SQLState: 07002, Return Code: -1
The # of binded parameters < the # of parameter markers
----------------------------------------------------------------------
Comment By: Hiroshi Inoue (hinoue)
Date: 2010-05-21 03:20
Message:
I can reproduce the problem.
Could you please try the drivers on testing for 8.4.0201 at
http://www.geocities.jp/inocchichichi/psqlodbc/index.html
?
----------------------------------------------------------------------
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010827&group_id=1000125