Ticket #1481 (closed defect: invalid)

Opened 1 year ago

Last modified 3 months ago

Assigning None to SQLObject column generates SQL syntax error with Firebird2

Reported by: brolston Assigned to: 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

08/16/07 20:22:56 changed 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.

08/28/08 15:38:26 changed 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.