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

[ psqlodbc-Bugs-1000605 ] Escaped single-quotes mistreated by PGAPI_NumParams

From: <noreply(at)pgfoundry(dot)org>
To: noreply(at)pgfoundry(dot)org
Subject: [ psqlodbc-Bugs-1000605 ] Escaped single-quotes mistreated by PGAPI_NumParams
Date: 2006-04-04 15:20:31
Message-ID: 20060404152031.2DBE0103383D@pgfoundry.org (view raw or flat)
Thread:
Lists: pgsql-odbc
Bugs item #1000605, was opened at 2006-04-04 10:52
You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000605&group_id=1000125

Category: None
Group: None
Status: Open
Resolution: None
Priority: 3
Submitted By: Lasse Haataja (lhaataja)
Assigned to: Nobody (None)
Summary: Escaped single-quotes mistreated by PGAPI_NumParams

Initial Comment:
Note: The error seems to only occur with 8.01.0200, although the actual code in PGAPI_NumParams is identical in earlier versions; probably called with different args in .0200.

The body of PGAPI_NumParams seems to fail to take into account
single quotes escaped by backslashes, instead treating them in the same manner
as literal single quotes, causing queries containing escaped single quotes
and question marks in correct sequence (such as SELECT '\'?') to fail with
the error "The # of binded parameters < the # of parameter markers".

This can luckily be worked around (in a standard-compliant manner, no less) by
escaping single quotes with a single quote instead of a backslash, but a fix,
at least in the documentation, would be welcome.

To reproduce, do a SELECT '\'?' via psqlodbc 8.01.0200.






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

>Comment By: Hiroshi Inoue (hinoue)
Date: 2006-04-04 15:20

Message:
Please dowmload the Experimental Enhanced Branch (7.03.0260) from this project home page. Install
the driver and replace the dll by the one at
 http://www.geocities.jp/inocchichichi/index.html
and try it.

regards,
Hiroshi Inoue

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

You can respond by visiting: 
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000605&group_id=1000125

pgsql-odbc by date

Next:From: noreplyDate: 2006-04-05 09:31:53
Subject: [ psqlodbc-Bugs-1000605 ] Escaped single-quotes mistreated by PGAPI_NumParams
Previous:From: Hiroshi InoueDate: 2006-04-04 14:54:03
Subject: Re: Unicode is not UTF-8. was :psqlODBC-Driver Test / text

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