From 7ce1539934b67e536446f7323c7848fdd6ba68e3 Mon Sep 17 00:00:00 2001 From: Jeff Lawson Date: Sun, 1 Aug 2010 11:41:03 +0100 Subject: Bug Fix -- clean up connection after stored procedure [#3151 state:resolved] --- activerecord/test/schema/mysql_specific_schema.rb | 11 +++++++++++ 1 file changed, 11 insertions(+) (limited to 'activerecord/test/schema/mysql_specific_schema.rb') diff --git a/activerecord/test/schema/mysql_specific_schema.rb b/activerecord/test/schema/mysql_specific_schema.rb index c78d99f4af..30e1c5a167 100644 --- a/activerecord/test/schema/mysql_specific_schema.rb +++ b/activerecord/test/schema/mysql_specific_schema.rb @@ -19,6 +19,17 @@ CREATE PROCEDURE ten() SQL SECURITY INVOKER BEGIN select 10; END +SQL + + ActiveRecord::Base.connection.execute <<-SQL +DROP PROCEDURE IF EXISTS topics; +SQL + + ActiveRecord::Base.connection.execute <<-SQL +CREATE PROCEDURE topics() SQL SECURITY INVOKER +BEGIN + select * from topics limit 1; +END SQL end -- cgit v1.2.3