reorder bind indexes if joins produced bind values

1 files changed, 9 insertions, 0 deletions

diff --git a/activerecord/lib/active_record/relation/query_methods.rb b/activerecord/lib/active_record/relation/query_methods.rb
index 159ad1dbe3..ffcdcd1169 100644
--- a/activerecord/lib/active_record/relation/query_methods.rb
+++ b/activerecord/lib/active_record/relation/query_methods.rb
@@ -844,6 +844,15 @@ module ActiveRecord
       arel.from(build_from) if from_value
       arel.lock(lock_value) if lock_value
 
+      # Reorder bind indexes if joins produced bind values
+      if arel.bind_values.any?
+        bvs = arel.bind_values + bind_values
+        arel.ast.grep(Arel::Nodes::BindParam).each_with_index do |bp, i|
+          column = bvs[i].first
+          bp.replace connection.substitute_at(column, i)
+        end
+      end
+
       arel
     end