Warning: Can't synchronize with repository "(default)" (Unsupported version control system "svn": No module named svn). Look in the Trac log for more information.

Ticket #1481 (closed defect: invalid)

Opened 12 years ago

Last modified 11 years ago

Assigning None to SQLObject column generates SQL syntax error with Firebird2

Reported by: brolston Owned by: anonymous
Priority: normal Milestone:
Component: SQLObject Version: 1.0.3
Severity: normal Keywords: firebird sqlobject none null
Cc:

Description

This Python code...

row = Table.get(1)
row.column = None

generates this SQL query:

UPDATE table SET column = (NULL) WHERE table_id = (1)

The result I get when using firebird2:

Dynamic SQL Error. SQL error code = -104. 
Token unknown - line 1, char 28. NULL.

Firebird chokes because of the parens around NULL. The query works when they are removed:

UPDATE table SET column = NULL WHERE table_id = (1)

Change History

comment:1 Changed 12 years ago by brolston

  • Summary changed from Assigning None to SQLObject column generates SQL syntax error to Assigning None to SQLObject column generates SQL syntax error with Firebird2

comment:2 Changed 11 years ago by Chris Arndt

  • Status changed from new to closed
  • Resolution set to invalid

Sorry for the late answer, we neglected our ticket handling a bit in the past few months but we are now trying to get back on track.

If this is still an issue, please report it in the  SQLObject bug tracker.

Note: See TracTickets for help on using tickets.