logo       
Google Custom Search
    AddThis Social Bookmark Button
-->

Single '%' in query bug: msg#00014

Subject: Single '%' in query bug
I think I have tracked down a bug that was being triggered by
Zope3's database adapter.

>>> import psycopg
>>> con = psycopg.connect('')
>>> cur = con.cursor()
>>> cur.execute("create table foo (bar text)")
>>> cur.execute("insert into foo values ('100%')", {})
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
TypeError: unindexable object
>>> cur.execute("insert into foo values ('100%%')", {})
>>> cur.execute("select * from foo")
>>> print cur.fetchall()
[('100%%',)]

How a single quote triggers the problem, yet a double %%
gets passed through fine, confuses me :-)

-- Stuart Bishop <stuart-4lSSOvFEPszcGevYNGnvVw@xxxxxxxxxxxxxxxx>
http://www.stuartbishop.net/

Attachment: PGP.sig
Description: This is a digitally signed message part

_______________________________________________
Psycopg mailing list
Psycopg-IAPFreCvJWPBWskQ1e/+sw@xxxxxxxxxxxxxxxx
http://lists.initd.org/mailman/listinfo/psycopg
<Prev in Thread] Current Thread [Next in Thread>