Defect #935
when bulk editing, setting "Assigned to" to "nobody" causes an sql error
| Status: | Closed | Start date: | 2008-03-26 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: | - | % Done: | 0% | |
| Category: | Issues | |||
| Target version: | 0.7 | |||
| Resolution: | Fixed | Affected version: |
Description
at least under postgres:
ActiveRecord::StatementInvalid (PGError: ERROR: invalid input syntax for integer: "none" : SELECT * FROM users WHERE (users."id" = 'none') LIMIT 1):
I've included a patch which fixes this problem, and as a bonus, allows setting the version to "none" as well, using a similar pattern to assigned_to.
none.diff 
(2.7 KB)
Associated revisions
Fixed: when bulk editing, setting "Assigned to" to "nobody" causes an sql error with Postgresql (#935).
History
#1
Updated by Jean-Philippe Lang over 10 years ago
- Category set to Issues
- Status changed from New to Closed
- Target version set to 0.7
- Resolution set to Fixed
Thanks, patch applied in r1294 with the ability to set the category to 'none' as well.