[ psqlodbc-Bugs-1010827 ] ODBC driver not parsing comment correctly

Bugs item #1010827, was opened at 2010-05-20 14:04
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010827&group_id=1000125

Category: None
Group: None
Status: Open
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 07:11

Message:
Passes my testing. Thanks.

----------------------------------------------------------------------

Comment By: Hiroshi Inoue (hinoue)
Date: 2010-05-23 23:43

Message:
Hmm line comment.
OK please retry the drivers.

----------------------------------------------------------------------

Comment By: Farid Zidan (faridz)
Date: 2010-05-22 21: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-22 20:18

Message:
I see.

I changed a suspicious place.
Could you please retry the drivers?

----------------------------------------------------------------------

Comment By: Farid Zidan (faridz)
Date: 2010-05-21 08: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-20 23: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