Hi,
I have an error with mysql adapter when where is two statment in the
same sql execution.
I don''t have this error with postgres adapter.
If I perform, on the console, this "stupide" code :
> db = ctiveRecord::Base.connection
> db.execute(" db.execute("CREATE TABLE toto (id int); DROP TABLE
toto;")
I have the error :
//////////////////
ActiveRecord::StatementInvalid: Mysql::Error: 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 ''DROP TABLE toto'' at
line 1:
CREATE TABLE toto (id int); DROP TABLE toto;
from
/Library/WebServer/Documents/RubyTimeNetV2/vendor/plugins/rows_logger/init.rb:36:in
`log''
from
/Library/WebServer/Documents/RubyTimeNetV2/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:304:in
`execute_without_query_stats''
from
/Library/WebServer/Documents/RubyTimeNetV2/vendor/plugins/query_stats/lib/query_stats/recorder.rb:16:in
`execute''
from
/Library/WebServer/Documents/RubyTimeNetV2/vendor/rails/activesupport/lib/active_support/core_ext/benchmark.rb:8:in
`realtime''
from
/Library/WebServer/Documents/RubyTimeNetV2/vendor/plugins/query_stats/lib/query_stats/recorder.rb:15:in
`execute''
from (irb):116
////////////////
If I separate the two (stupids) statment, no error :
>> db.execute("CREATE TABLE toto (id int);")
=> nil>> db.execute("DROP table toto;")
=> nil
Thanks
Laurent
--
Posted via http://www.ruby-forum.com/.
--
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.