Skip site navigation (1) Skip section navigation (2)

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

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1010827 ] ODBC driver not parsing comment correctly
Date: 2010-05-23 01:45:41
Message-ID: 20100523014541.88418107164F@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-odbc
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-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

pgsql-odbc by date

Next:From: noreplyDate: 2010-05-24 03:43:54
Subject: [ psqlodbc-Bugs-1010827 ] ODBC driver not parsing comment correctly
Previous:From: noreplyDate: 2010-05-23 00:18:13
Subject: [ psqlodbc-Bugs-1010827 ] ODBC driver not parsing comment correctly

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group