ScheduleItem.count([“id = ?”, 204])
used to work as expected in Rails 1.1.6, i.e. returning the count of
rows where id = 204 …
In 2.1.1 I get the error:
"ActiveRecord::StatementInvalid: ActiveRecord::ActiveRecordError: 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 '?204) AS
count_id_204 FROM schedule_items’ at line 1: SELECT count(id = ?204)
AS count_id_204 FROM schedule_items "
Looks like [“id = ?”, id] is not evaluated/resolved correctly
resulting in ‘id = ?204’ instead of ‘id = 204’
Bug?
Thx
Clemens
