MySQL + CREATE PROCEDURE At first ( When No Cached ) TRANSACTION ( BEGIN to ROLLBACK ) does not work well

[YumaInaura]

Example

    ActiveRecord::Base.transaction do
      upsert = Upsert.new Pet.connection, Pet.table_name
      upsert.row({:name => rand(999999)}, :breed => 'beagle', :created_at => Time.now)
      raise ActiveRecord::Rollback
    end

First time

Pet.count # => 1

Second Time

Pet.count # => 1

Cause

is maybe BEGIN and ROLLBACK order?

First time

BEGIN

CREATE PROCEDURE
(many lines)

CALL PROCEDURE

ROLLBACK

Second time ( created PROCEDURE cached )

BEGIN

CALL PROCEDURE

ROLLBACK