This project is archived and is in readonly mode.

#6069 ✓committed
James Abley

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.

[1] https://github.com/jabley/arel/compare/master...mssql

Comments and changes to this ticket

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>

Referenced by

Pages