#5598 Arel needs to convert symbols passed to .order() into double quoted strings for PostgreSQL - 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.

#5598 ✓stale

Arel needs to convert symbols passed to .order() into double quoted strings for PostgreSQL

Reported by Ray | September 9th, 2010 @ 10:20 PM

This works:

Business.order('name')

This fails:

Business.order(:name)

The error is:

ActiveRecord::StatementInvalid: PGError: ERROR: non-integer constant in ORDER BY
LINE 1: SELECT "businesses".* FROM "businesses" ORDER BY 'name'

Aaron Patterson September 23rd, 2010 @ 12:27 AM
- State changed from “new” to “needs-more-info”
- Importance changed from “” to “Low”
Hey Ray! I tried reproducing this bug. I guess I need more info. Can you provide anything else like a failing test or something? Thanks.
David Trasbo September 25th, 2010 @ 06:42 PM
I too was unable to reproduce this.
Aaron Patterson October 30th, 2010 @ 10:53 PM
- State changed from “needs-more-info” to “stale”
Closing as I couldn't reproduce and this ticket is pretty old.

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »

<h2 style="font-size: 14px">Tickets have moved to Github</h2>

The new ticket tracker is available at <a href="https://github.com/rails/rails/issues">https://github.com/rails/rails/issues</a>