Method: Sequel::MySQL::DatasetMethods#supports_cte?

Defined in:
lib/sequel/adapters/shared/mysql.rb

#supports_cte?(type = :select) ⇒ Boolean

MariaDB 10.2+ and MySQL 8+ support CTEs

Returns:

  • (Boolean) 


870
871
872
873
874
875
876
877
878
879
 
# File 'lib/sequel/adapters/shared/mysql.rb', line 870

def supports_cte?(type=:select)
  if db.mariadb?
    type == :select && db.server_version >= 100200
  else
    case type
    when :select, :update, :delete
      db.server_version >= 80000
    end
  end
end