From: Mayank Prasad
Date: March 28 2011 10:42am
Subject: bzr commit into mysql-5.1 branch (mayank.prasad:3635) Bug#11751148
List-Archive: http://lists.mysql.com/commits/134024
X-Bug: 11751148
Message-Id: <201103281042.p2SAggmG030272@acsmt358.oracle.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="===============1231603094=="

--===============1231603094==
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

#At file:///home/mayank/testC_5.1/ based on revid:sergey.glukhov@stripped

 3635 Mayank Prasad	2011-03-28
      Bug#11751148 : show events shows events in other schema
      
      Issue:
      ======
      Test case Correction for bug#11751148.
     @ mysql-test/r/events_bugs.result
        Result file Correction for bug#11751148.
     @ mysql-test/t/events_bugs.test
        Test case Correction for bug#11751148.

    modified:
      mysql-test/r/events_bugs.result
      mysql-test/t/events_bugs.test
=== modified file 'mysql-test/r/events_bugs.result'
--- a/mysql-test/r/events_bugs.result	2011-03-21 16:02:47 +0000
+++ b/mysql-test/r/events_bugs.result	2011-03-28 10:42:17 +0000
@@ -747,15 +747,15 @@ event_name	originator
 ev1	4294967295
 DROP EVENT ev1;
 SET GLOBAL server_id = @old_server_id;
+CREATE DATABASE event_test12;
+USE event_test12;
+CREATE EVENT ev1 ON SCHEDULE EVERY 1 DAY DO SELECT 1;
 CREATE DATABASE event_test1;
 USE event_test1;
-CREATE EVENT ev1 ON SCHEDULE EVERY 1 DAY DO SELECT 1;
-CREATE DATABASE event_test2;
-USE event_test2;
 SHOW EVENTS;
 Db	Name	Definer	Time zone	Type	Execute at	Interval value	Interval field	Starts	Ends	Status	Originator	character_set_client	collation_connection	Database Collation
 DROP DATABASE event_test1;
-DROP DATABASE event_test2;
+DROP DATABASE event_test12;
 DROP DATABASE events_test;
 SET GLOBAL event_scheduler= 'ON';
 SET @@global.concurrent_insert= @concurrent_insert;

=== modified file 'mysql-test/t/events_bugs.test'
--- a/mysql-test/t/events_bugs.test	2011-03-21 16:02:47 +0000
+++ b/mysql-test/t/events_bugs.test	2011-03-28 10:42:17 +0000
@@ -1225,15 +1225,15 @@ SET GLOBAL server_id = @old_server_id;
 # Bug#11751148: show events shows events in other schema
 #
 
+CREATE DATABASE event_test12;
+USE event_test12;
+CREATE EVENT ev1 ON SCHEDULE EVERY 1 DAY DO SELECT 1;
 CREATE DATABASE event_test1;
 USE event_test1;
-CREATE EVENT ev1 ON SCHEDULE EVERY 1 DAY DO SELECT 1;
-CREATE DATABASE event_test2;
-USE event_test2;
 # Following show events should not show ev1
 SHOW EVENTS;
 DROP DATABASE event_test1;
-DROP DATABASE event_test2;
+DROP DATABASE event_test12;
 
 
 ###########################################################################


--===============1231603094==
MIME-Version: 1.0
Content-Type: text/bzr-bundle; charset="us-ascii";
	name="bzr/mayank.prasad@stripped"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

# Bazaar merge directive format 2 (Bazaar 0.90)
# revision_id: mayank.prasad@stripped\
#   uit9eh8nd7xi2bs0
# target_branch: file:///home/mayank/testC_5.1/
# testament_sha1: 7abeeb301d2568e3b61891e9059a539b97a20bc8
# timestamp: 2011-03-28 16:12:35 +0530
# base_revision_id: sergey.glukhov@stripped\
#   n4zdn28mgq0ec1dv
# 
# Begin bundle
IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWV3z8YwAAp/fgFAQWGP//35n
3yC////wUAWN7LXeju1keqnojS61wkkUwmSbBU/0jRomDSnqA0aeoyYgeo0BKSaI09MCp4p6h6ja
mmjQAAAAGgJISajR5RDKbNKemhMBMIzRMBAGmEVEBHpNTyieZR6pmmKNqNB6gYgyAAJJCaDQnqYo
jyaJ6jJiPUPFNAYgMT1O27spr0mgZjy6WwGzZlfNihicYxxVU8ciNkzC6iaSGNGn41s00zGswDDM
DMvXxR+5T7Rn2GMTO1eweIpWPzwc1CnB0Wb66lvNhcXjgcd+8+J/FiYFIv74wtLVN/aJLiKdyG2Y
nhdDbr6i92dZHYIeyD7hy0yi6IWQ/An1tDYr1lHL85uhMBnqwoMU4k6RaEi4RWY8041D5DUkqhHE
yM8E5i6YuczOQo0u506gTxMSQtH6cCqUTvK+rJIo6mXi3+qJUqqsl/iS1broVwGHmNHVerkKYWp5
uCNL1BKMMsbOMV8bjaHglZINMGLQnM8QITh215arZ6K1MsIDCA5Mkwkn1FsoQhJoexQtqGahpIOk
CucGtYF9QGVaJgmaylEIkQMDTrE6NLNuKOULfdF1KlwnJIItNq/OdaheIqe6ZscY4sdOQMd2jKkn
a5Qi4tR6moCkOEakJErTEChhMYDEZWW0VlFRBG3poS5Jkvs01SkFIdsAoguyppm/nHuNplQvmY1L
21fCpbfINSdTjJaZh5pFiD9ernqsxK+QvWTPTKVJnv4LUtBO4qAiq548bUWlMKrhgKQqyVsMc/Is
NRHqM2EoF8S3gRgGVhRgyfikUkSig0SWEY8VhHCFeL+W1GoCZAvLRZceCwxBjicqRhnnloAxXTrg
WQauGIbEUsadjqSZTnKQWDyhPCiV5F5xohmRrVvTSygzG+ZUWFOntIGxMg3Bxh+g3gxVJmGYb8hD
X5EAeTzpDx5YHgRF5BY88CBwCsPEs4Ei7tHEykuIDqggUEYEyoYcRO4eBRZUMVBYUFPWImaMRyTP
4uSPFwn7uB7t/qXfzEpCQZIn4HYPUSO2gof3AvhJJ4LaYDxgv4OSOjdsK+/aWrsXtKTsKDJFy8Tf
nAwXcIiWtcEi/PqWsbrHOY0TDWrnCzr2ZI3MJfQSxtTxrOQnU+GRgTaFRLPoHXg1dMggBWSOjRKk
PLiY54m2K1Zcyx99aprqZkg8PlCqcsiIRs7VrhoqNxRGsHUBjRxmU8OKYll9Gpz5KW7gNWx8bmhf
G3Q5kSARt47OTEMspPwKVYw9Ek3CdvU9sYsZ0Ro0KW4XA4FpYxtOJdgbnm4xMpSCs8zD0jDycNo5
DyZXh9ZlayGXJYLdBZlpxiOOk5LAB+8VLouSpURkglFK3gB5Ksto9iTR7BXiHFxlRkj877J6m9L0
0gatzOafXY63CL4sYKXsmbri6kyCyRnCxmSGEz/Ji92Om8LRYDO9PM4bC9eIlqcao7Ebud4Nx5jz
sCPRcVzPGb3XPRQ78GJ0ldLCBzNzOnr1FcQkA0GKIAs4J7ADLXie9ZdC5UlEDbOUv9F5Ui+94TN9
3Pg2pjuApxgQGZqza+tSiPK2Z84TVuGHV0RcihQ2/niUwcy3Jd5ORkmiTfHO9QYP3QTEXgdKekcX
NmBZKV1sDMlrzFBzIcddA+XEXNa7vxhRf9kghGNxPsrHI5RmTKvzwwBlMCl9A3uBnCZ1Tp8gZEhX
RIZA6w0s2qJ1J8k0M0EaIBaFDU6qtvZ40bgODa76lzYkmTEbkwKn2ORsVirWyvpGqu2gVoxGTXgt
CmuUMFBlvVKtWSaz/i7kinChILvn4xg=


--===============1231603094==--