Cannot use select() without including state column about transitions

[troessner]

Hey

I'll take a look into that as soon as possible (the "assign" functionalit isn't working again, grrrr).

[alexhanh]

Any updates on this?

[troessner]

@alexhanh I won't have time to look into this until the weekend unfortunately....

[alexhanh]

Update?

[troessner]

@alexhanh

I can't reproduce your problem.

I did:

rails g scaffold game version:string state:string description:string

with the model being:

https://gist.github.com/1108357

Now look at this console session:

Game.create :version => '1', :description => 'first'
Game.create :version => '2', :description => 'second'

Game.select("DISTINCT(games.version)")
[ < Game version: "1" >, < Game version: "2" > ]

It seems like a problem with your application set up.

If not, you should provide me with an easy to reproduce example, then I'll take a look at it again.

[alexhanh]

rails new brake_transitions -d postgresql
rails g scaffold game version:string state:string description:string

gem 'transitions', :git => 'git://github.com/qoobaa/transitions.git', :require => ["transitions", "active_record/transitions"]

class Game < ActiveRecord::Base
  include ActiveRecord::Transitions
  state_machine do
    state :stopped
    state :started
  end

  validates_presence_of :version
end

bundle install
rake db:create
rake db:migrate

rails c

Game.create :version => '1', :description => 'first'
Game.create :version => '2', :description => 'second'

Game.select("DISTINCT(games.version)").order('games.version').first

ActiveModel::MissingAttributeError: missing attribute: state

[troessner]

Alright, now I can reproduce this. Interestingly, with sqlite the query above runs fine but not with MySql and PostgreSql.

I'll definitely gonna look into this, but I have no idea when since I am pretty loaded right now.

IF this a real problem for you you'll either have to fix it yourself or switch to state_machine.
If not, you'll just have to wait until I find the time.

[troessner]

@alexhanh thanks for the patch -> closed.