mysql adapter : "as" in the query

rubyonrails-talk
1

Migrating here from SQL Server to mysql; found something that "worked" under SQL Server (with freetds / odbc) but not mysql.

# cat db/migrate/005_create_noodles.rb class CreateNoodles < ActiveRecord::Migration   def self.up     create_table :noodles do |t|

      t.integer :girth     end   end

  def self.down     drop_table :noodles   end end

# rake db:migrate

# script/console>> Noodle.create(:girth => 4) => #<Noodle id: 1, girth: 4>

Noodle.find(:first, :select => 'girth as width').width

=> "4"

_.class

=> String

Under SQL Server would get "Fixnum" instead of String. Fixnum makes more sense.

I get the impression the Mysql::Result#each_hash method is responsible.

What should it be?

Stephan