node ascending AR test case.

arel_node_ascending_test.rb

require 'cases/helper'

if current_adapter?(:PostgreSQLAdapter)
  class ArelNodeAscendingTest < ActiveRecord::TestCase
    self.use_transactional_fixtures = false

    class State < ActiveRecord::Base
      has_many :cities
      default_scope { includes(:cities) }
    end

    class City < ActiveRecord::Base
      belongs_to :state
    end

    def setup
      ActiveRecord::Schema.define do
        create_table :states do |t|
          t.string :name
        end
        create_table :cities do |t|
          t.string :name
          t.integer :state_id
        end
      end
    end

    def teardown
      ActiveRecord::Schema.define do
        drop_table :states
        drop_table :cities
      end
    end

    def test_bigserial_primary_key
      sc = State.create!(name: 'South Carolina')
      greenville_sc = sc.cities.create(name: 'Greenville')
      nc = State.create(name: 'North Carolina')
      greenville_nc = nc.cities.create(name: 'Greenville') 

      State.order(State.arel_table[:name].asc).joins(:cities).
        where(:cities => {:name => "Greenville"}).limit(25)
    end
  end
end