Rails 3 ActiveRecord chaining

Question

I am new to Rails and I'm not sure why my chain is not working.

Job

my_model.select('name').where('status_id = 6').all 

Does not work

 my_model.select('name').where('status_id = 6').order('name') 

Why does the order chain after where fail the query? I tried adding .all after .order , but that didn't work either.

Answer 1

This seems to be a known bug in the jdbc adapter: http://kenai.com/jira/browse/ACTIVERECORD_JDBC-154

If you make these changes, it will fix it: https://github.com/ystael/activerecord-jdbc-adapter/commit/8815d2fe133afb6774ebe12cc27c3a977dbf7ad2