method

prepare_update_statement

v7.1.3.4 - Show latest stable - Class: Arel::Visitors::ToSql

prepare_update_statement(o)

private

The default strategy for an UPDATE with joins is to use a subquery. This doesn’t work on MySQL (even when aliasing the tables), but MySQL allows using JOIN directly in an UPDATE statement, so in the MySQL visitor we redefine this to do that.

# File activerecord/lib/arel/visitors/to_sql.rb, line 927
        def prepare_update_statement(o)
          if o.key && (has_limit_or_offset_or_orders?(o) || has_join_sources?(o))
            stmt = o.clone
            stmt.limit = nil
            stmt.offset = nil
            stmt.orders = []
            stmt.wheres = [Nodes::In.new(o.key, [build_subselect(o.key, o)])]
            stmt.relation = o.relation.left if has_join_sources?(o)
            stmt.groups = o.groups unless o.groups.empty?
            stmt.havings = o.havings unless o.havings.empty?
            stmt
          else
            o
          end
        end

prepare_update_statement

Related methods