# Bug that eats sql

**URL:** <https://www.ruby-forum.com/t/bug-that-eats-sql/110869>\
**Category:** Ruby\
**Created:** [July 31, 2007, 5:30pm UTC](https://www.ruby-forum.com/t/bug-that-eats-sql/110869 "2007-07-31T17:30:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![linus](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/f4b2a3/32.png) [@linus](https://www.ruby-forum.com/u/linus)\
**Post date:** [July 31, 2007, 5:30pm UTC](https://www.ruby-forum.com/t/bug-that-eats-sql/110869/1 "2007-07-31T17:30:15Z")

</div>

Hi,  
I might have found bug that eats sql.

I can manualy execute this code on “Company$NCustomers” view:

UPDATE “Company$NCustomers” SET name = ‘test’ WHERE no\_ = ‘100087’

But then i do that in rails, the attribute is not set:

n = User.find\_by\_username(‘ncustomer2’).n\_customer; n.name = ‘test  
chagne’; n.save

ActiveRecord::StatementInvalid: DBI::DatabaseError: Execute  
OLE error code:80040E14 in Microsoft OLE DB Provider for SQL Server  
Incorrect syntax near the keyword ‘WHERE’.  
HRESULT error code:0x80020009  
WystÄ…piÅ‚ wyjÄ…tek.: UPDATE “Company$NCustomers” SET WHERE no\_ =  
‘100087’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active\_record/connection\_adapters/abstract\_adapter.rb:128:in  
`log' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/connection_adapters/sqlserver_adapter.rb:318:in`execute’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active\_record/connection\_adapters/sqlserver\_adapter.rb:301:in  
`update' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/base.rb:1797:in`update\_without\_lock’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active\_record/locking/optimistic.rb:60:in  
`update_without_callbacks' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/callbacks.rb:267:in`update\_without\_timestamps’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active\_record/timestamp.rb:48:in  
`update' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/base.rb:1790:in`create\_or\_update\_without\_callbacks’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active\_record/callbacks.rb:242:in  
`create_or_update' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/base.rb:1546:in`save\_without\_validation’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active\_record/validations.rb:752:in  
`save_without_transactions' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/transactions.rb:129:in`save’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active\_record/connection\_adapters/abstract/database\_statements.rb:59:in  
`transaction' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/transactions.rb:95:in`transaction’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active\_record/transactions.rb:121:in  
`transaction' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/transactions.rb:129:in`save’  
from  
c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active\_record/associations/association\_proxy.rb:123:in  
`send' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.15.2/lib/active_record/associations/association_proxy.rb:123:in`method\_missing’  
from (irb):3\>\>

Any ideas why it rails might produce wrong sql statement here?

---

<div class="post-metadata">

**Author:** ![linus](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/f4b2a3/32.png) [@linus](https://www.ruby-forum.com/u/linus)\
**Post date:** [August 1, 2007, 3:30am UTC](https://www.ruby-forum.com/t/bug-that-eats-sql/110869/2 "2007-08-01T03:30:04Z")

</div>

Tom Bak wrote:

> n = User.find\_by\_username(‘ncustomer2’).n\_customer; n.name = ‘test  
> chagne’; n.save

You’ll have better luck with your question in the Rails forum/mailing  
list. I don’t know the URL, but google can probably help with that.

Dan

---

<div class="post-metadata">

**Author:** ![linus](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/l/f4b2a3/32.png) [@linus](https://www.ruby-forum.com/u/linus)\
**Post date:** [August 1, 2007, 9:22am UTC](https://www.ruby-forum.com/t/bug-that-eats-sql/110869/3 "2007-08-01T09:22:44Z")

</div>

I submited it as bug [http://dev.rubyonrails.org/ticket/9158](http://dev.rubyonrails.org/ticket/9158)

Thanks,  
Tom