#3727 Arel gives invalid SQL for empty array - Ruby on Rails

Type	To find
responsible:me	tickets assigned to you
tagged:"@high"	tickets tagged @high
milestone:next	tickets in the upcoming milestone
state:invalid	tickets with the state invalid
created:"last week"	tickets created last week
sort:number, importance, updated	tickets sorted by #, importance or updated
Combine keywords for powerful searching.
Use advanced searching »

This project is archived and is in readonly mode.

#3727 ✓invalid

Arel gives invalid SQL for empty array

Reported by Troels Petersen | January 17th, 2010 @ 08:19 PM | in 3.0.2

ActiveRecord <= 2.3 accepts an empty array as a condition on an attribute, but Arel turns it into invalid SQL:

User.all( :conditions => { :id => [] } )

ActiveRecord::StatementInvalid: Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')))' at line 1: SELECT * FROM users WHERE ((users.id IN ()))

Comments and changes to this ticket

José Valim January 17th, 2010 @ 10:20 PM
- Assigned user set to “Pratik”
José Valim January 18th, 2010 @ 08:02 PM
- Milestone cleared.
Emilio Tagua March 12th, 2010 @ 07:34 PM
- State changed from “new” to “invalid”
This is fixed in master, feel to re-open it if you can reproduce the problem.
Jeremy Kemper October 15th, 2010 @ 11:01 PM
- Milestone set to “3.0.2”
- Importance changed from “” to “Low”
[bulk edit]