#96 ✓resolved
Jeffrey Gelens

bug: do_mysql query fails for multiple queries at once

Reported by Jeffrey Gelens | December 14th, 2007 @ 01:44 AM

When multiple queries are being executed in one command, the query is failing. It works fine with do_postgresql! Multiple queries are being executed when indexes are defined in the model.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; CREATE INDEX ......
/usr/lib/ruby/gems/1.8/gems/do_mysql-0.2.1/lib/do_mysql.rb:193:in `execute_non_query'
/usr/lib/ruby/gems/1.8/gems/datamapper-0.2.5/lib/data_mapper/adapters/sql/mappings/table.rb:122:in `create!'
/usr/lib/ruby/gems/1.8/gems/datamapper-0.2.5/lib/data_mapper/adapters/data_object_adapter.rb:77:in `connection'

Btw I'm using do_mysql version 0.2.1.

Comments and changes to this ticket

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »

People watching this ticket