Limit expression generated with bind param but no value (works with 6.0.4/breaks with 7.1.4) about arel HOT 4 CLOSED

Arel 8.0.0/AR 5.14 exhibits the same behavior

from arel.

Yeah, this is expected behaviour: the Arel relation doesn't carry the bind parameter values (and we're progressively moving more things from SQL interpolation to use bind parameters -- in this case, LIMIT).

from arel.

@aselder Yes. When using Arel to build inner queries, this bites us.

To get around, we have had to build a sql literal:

Arel::Nodes::SqlLiteral.new("(#{arel.to_sql})")

The cause of this is over in Rails, where it builds its own BindParam values ( relation/query_methods.rb ?) instead of using Arel itself to build the sql (with the bind parameters). Not trying to say that is a trivial task, just trying to state the problem.

Would be nice if Arel could return an AST with bind variables that were more usable to Rails.
Sorry for not better details, I had researched this over a year ago.

@matthewd if you have specific instructions (or a whim) you can send me off on a wild goose chase on this one.

from arel.

Per #523, Arel development is moving to rails/rails.

If this issue is still relevant, please consider reopening it over there. (Note that the Rails repository does not accept feature request issues, and requires reproduction steps that rely on Active Record's documented API.)

from arel.