Context Navigation

Modify ↓

#6670 closed defect (duplicate)

Postgres will not automatically cast an integer to a text field. Consequently, the query in versioncontrol/cache.py:CachedChangeset

cursor = self.db.cursor()
        cursor.execute("SELECT time,author,message FROM revision "
                       "WHERE rev=%s", (rev,))

Will fail as rev needs to be stringified with str(rev). It is cast in other places in cache.py so it's just a syntax bug.

"WHERE rev=%s", (str(rev),)) works perfectly.

This is in Postgres 8.3beta4.

Isn't this a duplicate of #6274 ?

Sure, thanks for noticing.

Isn't this a duplicate of #6274 ?

Yes it is. I search up a storm but didn't find anything relating to this bug. Sorry.

Keywords:	postgresql added; postgres removed

Change Properties

Summary:
Description:	Postgres will not automatically cast an integer to a text field. Consequently, the query in versioncontrol/cache.py:CachedChangeset {{{ cursor = self.db.cursor() cursor.execute("SELECT time,author,message FROM revision " "WHERE rev=%s", (rev,)) }}} Will fail as rev needs to be stringified with str(rev). It is cast in other places in cache.py so it's just a syntax bug. {{{ "WHERE rev=%s", (str(rev),)) }}} works perfectly. This is in Postgres 8.3beta4. You may use WikiFormatting here.
Type:		Priority:
Milestone:		Component:
Version:		Severity:
Keywords:		Cc:	Set your email in Preferences
Branch:
Release Notes:
API Changes:
Internal Changes:

Action

leave as closed The owner will remain Christian Boos.

reopen The resolution will be deleted. Next status will be 'reopened'.

change ownership to The owner will be changed from Christian Boos to the specified user.

Your email or username:

E-mail address and name can be saved in the Preferences .

You may use WikiFormatting here.

Attachments ↑ Description ↑

Note: See TracTickets for help on using tickets.