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
-
Bjørn Arild Mæland December 14th, 2007 @ 02:31 AM
- Milestone cleared.
- State changed from “new” to “open”
This also works for SQLite, which our spec-suite runs on. I'll get an mysql install up and running, to investigate further
-
Bjørn Arild Mæland December 14th, 2007 @ 04:34 AM
- State changed from “open” to “resolved”
Fixed in r605, each query now gets executed separately
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.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »
Bjørn Arild Mæland