aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/schema/mysql_specific_schema.rb
diff options
context:
space:
mode:
authorSean Griffin <sean@seantheprogrammer.com>2015-10-20 14:02:23 -0600
committerSean Griffin <sean@seantheprogrammer.com>2015-10-20 14:02:23 -0600
commit72fba7db413561cf293178d5df0708c9380356fb (patch)
tree8a38fef3f866800edbe9a110d460410ca3ed9c77 /activerecord/test/schema/mysql_specific_schema.rb
parentee865eb244c8db11dcfbadbce0994d3c6488e7ec (diff)
parentd39b6f77fc75790b1b2b3c5201bb037645d01483 (diff)
downloadrails-72fba7db413561cf293178d5df0708c9380356fb.tar.gz
rails-72fba7db413561cf293178d5df0708c9380356fb.tar.bz2
rails-72fba7db413561cf293178d5df0708c9380356fb.zip
Merge pull request #21932 from kamipo/add_stored_procedure_test_in_mysql2
Add stored procedure test in mysql2
Diffstat (limited to 'activerecord/test/schema/mysql_specific_schema.rb')
-rw-r--r--activerecord/test/schema/mysql_specific_schema.rb4
1 files changed, 2 insertions, 2 deletions
diff --git a/activerecord/test/schema/mysql_specific_schema.rb b/activerecord/test/schema/mysql_specific_schema.rb
index 1dd20b585d..553cb56103 100644
--- a/activerecord/test/schema/mysql_specific_schema.rb
+++ b/activerecord/test/schema/mysql_specific_schema.rb
@@ -45,9 +45,9 @@ DROP PROCEDURE IF EXISTS topics;
SQL
ActiveRecord::Base.connection.execute <<-SQL
-CREATE PROCEDURE topics() SQL SECURITY INVOKER
+CREATE PROCEDURE topics(IN num INT) SQL SECURITY INVOKER
BEGIN
- select * from topics limit 1;
+ select * from topics limit num;
END
SQL