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

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=10006 05&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=10006 05&group_id=1000125

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings