method

build_subselect

v7.1.3.2 - Show latest stable - 0 notes - Class: MySQL

1.0.0
1.1.6
1.2.6
2.0.3
2.1.0
2.2.1
2.3.8
3.0.0
3.0.9
3.1.0
3.2.1
3.2.8
3.2.13
4.0.2
4.1.8
4.2.1
4.2.7
4.2.9
5.0.0.1
5.1.7
5.2.3
6.0.0 (0)
6.1.3.1 (0)
6.1.7.7 (0)
7.0.0 (38)
7.1.3.2 (0)
What's this?

build_subselect(key, o) private

MySQL doesn’t automatically create a temporary table for use subquery, so we have to give it some prompting in the form of a subsubquery.

Show source

# File activerecord/lib/arel/visitors/mysql.rb, line 88
        def build_subselect(key, o)
          subselect = super

          # Materialize subquery by adding distinct
          # to work with MySQL 5.7.6 which sets optimizer_switch='derived_merge=on'
          unless has_limit_or_offset_or_orders?(subselect)
            core = subselect.cores.last
            core.set_quantifier = Arel::Nodes::Distinct.new
          end

          Nodes::SelectStatement.new.tap do |stmt|
            core = stmt.cores.last
            core.froms = Nodes::Grouping.new(subselect).as("__active_record_temp")
            core.projections = [Arel.sql(quote_column_name(key.name))]
          end
        end

build_subselect

Related methods

Flowdock - Team Inbox With Chat