ActiveRecord Bug — Dropped Connection with two conditions

Using 3.2.2, doing:

  a = Model.where("created_at > '2011-10-01   00:00:00'").where("created_at < '2012-01-01   00:00:00'")

Always results in

  ActiveRecord::StatementInvalid (Mysql2::Error: Lost connection to   MySQL server during query: SELECT `models`.* FROM `models`   WHERE (created_at > '2011-10-01 00:00:00') AND (created_at <   '2012-01-01 00:00:00'))

If I leave off one of the conditions it works fine. The raw query via Mysql2::Client#query works fine, and returns within milliseconds, so it's not a timeout issue.

Any ideas? I'm stumped.

I don’t know what are trying to do, but why are you not using arel approach for 2 conditions statements, You could try this possibility

users.where(users[:name].eq('bob').and(users[:age].lt(25)))

if you have any misunderstand please try to look at arel documentation or github readme

https://github.com/rails/arel

regards

Maybe I could arel, but that's besides the point. This should work and it doesn't, and I'm very curious as to why. I submitted it as an issue. We'll see where that goes.