diff options
author | Justin Bailey <jgbailey@gmail.com> | 2009-09-14 17:53:04 -0700 |
---|---|---|
committer | Jeremy Kemper <jeremy@bitsweat.net> | 2009-09-17 10:57:03 -0700 |
commit | c9d3c48dc6389feb2001372cd76e96274e773c9b (patch) | |
tree | e5f03b9a8c32f96a45ee8b2f687a2942203d7eba /activerecord/test/schema | |
parent | 0d762646c4285437c12ddec9d0938c4ff1c3ef42 (diff) | |
download | rails-c9d3c48dc6389feb2001372cd76e96274e773c9b.tar.gz rails-c9d3c48dc6389feb2001372cd76e96274e773c9b.tar.bz2 rails-c9d3c48dc6389feb2001372cd76e96274e773c9b.zip |
Enable use of MySQL stored procedures by default.
[#3204 state:committed]
Signed-off-by: Jeremy Kemper <jeremy@bitsweat.net>
Diffstat (limited to 'activerecord/test/schema')
-rw-r--r-- | activerecord/test/schema/mysql_specific_schema.rb | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/activerecord/test/schema/mysql_specific_schema.rb b/activerecord/test/schema/mysql_specific_schema.rb index f44c33ae67..c78d99f4af 100644 --- a/activerecord/test/schema/mysql_specific_schema.rb +++ b/activerecord/test/schema/mysql_specific_schema.rb @@ -9,4 +9,16 @@ ActiveRecord::Schema.define do t.text :medium_text, :limit => 16777215 t.text :long_text, :limit => 2147483647 end + + ActiveRecord::Base.connection.execute <<-SQL +DROP PROCEDURE IF EXISTS ten; +SQL + + ActiveRecord::Base.connection.execute <<-SQL +CREATE PROCEDURE ten() SQL SECURITY INVOKER +BEGIN + select 10; +END +SQL + end |