{"issue":{"state":"open","pull_request":{"diff_url":null,"html_url":null,"patch_url":null},"user":{"avatar_url":"https://secure.gravatar.com/avatar/89316fb47af779e33e9d36d08a5eddd6?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"89316fb47af779e33e9d36d08a5eddd6","url":"https://api.github.com/users/rob99","login":"rob99","id":3505},"milestone":null,"labels":[],"updated_at":"2011-11-04T06:43:49Z","assignee":null,"comments":0,"closed_at":null,"url":"https://api.github.com/repos/griff/activerecord-jdbcsqlanywhere-adapter/issues/3","body":"I've found that if a proc does something else before executing a SELECT, then the adapter reports a row count as opposed to a subsequent result set.  \r\n\r\n```sql\r\ncreate procedure deleteme1\r\nas \r\n    select * from sysobjects\r\ngo\r\n\r\ncreate procedure deleteme2\r\nas\r\n    select * into #tmp from sysobjects\r\n    select * from #tmp\r\ngo\r\n```\r\n\r\n```ruby\r\n#...\r\nActiveRecord::Base.establish_connection CONFIG\r\nputs ActiveRecord::Base.connection.execute(\"exec deleteme1\").inspect\r\n#=> prints a result set\r\nputs ActiveRecord::Base.connection.execute(\"deleteme2\").inspect\r\n#=> prints a row count\r\n```\r\n\r\nI'm pretty sure this works with other adapters.  Will check....","html_url":"https://github.com/griff/activerecord-jdbcsqlanywhere-adapter/issues/3","number":3,"title":"exec stored proc returns row count, not result set","id":2141195,"created_at":"2011-11-04T06:43:49Z"},"action":"opened"}