activerecord/test/cases/column_alias_test.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

require "cases/helper"
require "models/topic"

class TestColumnAlias < ActiveRecord::TestCase
  fixtures :topics

  QUERY = if "Oracle" == ActiveRecord::Base.connection.adapter_name
    "SELECT id AS pk FROM topics WHERE ROWNUM < 2"
          else
            "SELECT id AS pk FROM topics"
          end

  def test_column_alias
    records = Topic.connection.select_all(QUERY)
    assert_equal "pk", records[0].keys[0]
  end
end