[ 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=10108 27&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=10553 33&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=10553 33&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=10108 27&group_id=1000125

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc