method

subquery_for

v5.0.0.1 - Show latest stable - 0 notes - Class: ActiveRecord::ConnectionAdapters

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 (0)
5.1.7 (0)
5.2.3 (0)
6.0.0
6.1.3.1
6.1.7.7
7.0.0
7.1.3.2
What's this?

subquery_for(key, select) private

MySQL is too stupid to create a temporary table for use subquery, so we have to give it some prompting in the form of a subsubquery. Ugh!

Show source

# File activerecord/lib/active_record/connection_adapters/abstract_mysql_adapter.rb, line 810
      def subquery_for(key, select)
        subsubselect = select.clone
        subsubselect.projections = [key]

        # Materialize subquery by adding distinct
        # to work with MySQL 5.7.6 which sets optimizer_switch='derived_merge=on'
        subsubselect.distinct unless select.limit || select.offset || select.orders.any?

        subselect = Arel::SelectManager.new(select.engine)
        subselect.project Arel.sql(key.name)
        subselect.from subsubselect.as('__active_record_temp')
      end

subquery_for

Related methods

Flowdock - Team Inbox With Chat for Software Developers