This project is archived and is in readonly mode.
Support MS SQL Server in Arel
Reported by James Abley | November 26th, 2010 @ 11:23 AM
Arel has problems with MS SQL Server; in particular specifying :limit generates invalid SQL.
I think MS SQL Server should be supported; it's a reasonably mainstream DB.
A possible solution has been created here [1].
The other solution considered was to override visit_Arel_Nodes_SelectCore and visit_Arel_Nodes_SelectStatement in the new Arel::Visitors::MSSQL class.
I can provide a suitable patch if I get guidance as to which approach is preferred.
Comments and changes to this ticket
-
Deleted User December 28th, 2010 @ 10:50 AM
It looks like MSSQL is not widely used with RoR. But I had a chance to face to requirements for my app those led me to this ticket. James Abley done a great work, but it related to Arel 2.0.4. Since current version of Arel is 2.0.6 I ported provided patch into it and created a fork for Arel, here it is: https://github.com/pentagon/arel-2.0.6.
I'll appreciate if these changes would go to master source tree.
Special thanks to James Abley.
-
Aaron Patterson January 3rd, 2011 @ 11:21 PM
- State changed from “new” to “committed”
- Importance changed from “” to “Low”
Thanks, I've applied this.
-
Create your profile
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>
People watching this ticket
Aaron Patterson
James Abley
Jeremy Kemper
Piotr Sarnacki
Referenced by
-
6054
DateTime in to_xml returns GMT from 3.0.2
I think this is a dup of #6069, but I need more informati...