1. 19 3月, 2019 1 次提交
    • J
      Remove roflscaling · 22d82b66
      Jeremy Evans 提交于
      roflscaling (using frozen string constants instead of literal
      strings) was added in 2012, before frozen string literals were
      added in Ruby 2.3.  Now that Rails no longer supports Ruby <2.3,
      and all of these files use frozen string literals, there is
      no reason to keep the roflscaling.
      
      This does not delete or deprecate the related constants. Such
      a change can be made in a later commit.
      22d82b66
  2. 16 3月, 2019 1 次提交
    • R
      Support Optimizer Hints · 97347d8c
      Ryuta Kamizono 提交于
      We as Arm Treasure Data are using Optimizer Hints with a monkey patch
      (https://gist.github.com/kamipo/4c8539f0ce4acf85075cf5a6b0d9712e),
      especially in order to use `MAX_EXECUTION_TIME` (refer #31129).
      
      Example:
      
      ```ruby
      class Job < ApplicationRecord
        default_scope { optimizer_hints("MAX_EXECUTION_TIME(50000) NO_INDEX_MERGE(jobs)") }
      end
      ```
      
      Optimizer Hints is supported not only for MySQL but also for most
      databases (PostgreSQL on RDS, Oracle, SQL Server, etc), it is really
      helpful to turn heavy queries for large scale applications.
      97347d8c
  3. 16 11月, 2018 1 次提交
    • D
      Arel: Implemented DB-aware NULL-safe comparison (#34451) · b5302d5a
      Dmytro Shteflyuk 提交于
      * Arel: Implemented DB-aware NULL-safe comparison
      
      * Fixed where clause inversion for NULL-safe comparison
      
      * Renaming "null_safe_eq" to "is_not_distinct_from", "null_safe_not_eq" to "is_distinct_from"
      
      [Dmytro Shteflyuk + Rafael Mendonça França]
      b5302d5a
  4. 25 9月, 2018 1 次提交
    • V
      Abandon TOP support. · 41b92914
      Vladimir Kochnev 提交于
      Initially, `TOP` was introduced to support `limit` for MSSQL database.
      Unlike PostgreSQL/MySQL/SQLite, MSSQL does not have native `LIMIT`/`OFFSET` support.
      The commit adding `TOP` is 1a246f71.
      
      However, it figured out that `TOP` implementation was weak and it's not sufficient
      to also support `OFFSET`, then `TOP` was substituted with
      `ROW_NUMBER()` subquery in be48ed30.
      This is a well known trick in MSSQL -
      https://stackoverflow.com/questions/2135418/equivalent-of-limit-and-offset-for-sql-server.
      
      So now we don't need this `visit_Arel_Nodes_Top` at all.
      It does nothing useful but also adds an extra space after `SELECT` when `LIMIT` is being
      used for **any** database.
      41b92914
  5. 24 2月, 2018 2 次提交