[ 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=1000605&group_id=1000125

Category: None
Group: None
>Status: Closed
Resolution: None
Priority: 3
Submitted By: Lasse Haataja (lhaataja)
>Assigned to: Hiroshi Inoue (hinoue)
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: Lasse Haataja (lhaataja)
Date: 2006-04-05 07:29

Message:
07.03.0260 behaves correctly, thanks for the tip!

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

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