From: Mayank Prasad Date: June 7 2011 10:23am Subject: bzr commit into mysql-trunk-wl5767 branch (mayank.prasad:3369) List-Archive: http://lists.mysql.com/commits/138751 Message-Id: <201106071024.p57AOKfa002237@acsmt356.oracle.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="===============0705677841==" --===============0705677841== MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Content-Disposition: inline #At file:///home/mayank/mysql-tree/my_WL/5767/ based on revid:mayank.prasad@stripped 3369 Mayank Prasad 2011-06-07 fix for failing test case ddl_esms_by_digest.test added: mysql-test/suite/perfschema/r/ddl_esms_by_digest.result modified: mysql-test/suite/perfschema/t/ddl_esms_by_digest.test === added file 'mysql-test/suite/perfschema/r/ddl_esms_by_digest.result' --- a/mysql-test/suite/perfschema/r/ddl_esms_by_digest.result 1970-01-01 00:00:00 +0000 +++ b/mysql-test/suite/perfschema/r/ddl_esms_by_digest.result 2011-06-07 10:23:30 +0000 @@ -0,0 +1,9 @@ +alter table performance_schema.events_statements_summary_by_digest +add column foo integer; +ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' +truncate table performance_schema.events_statements_summary_by_digest; +ALTER TABLE performance_schema.events_statements_summary_by_digest ADD INDEX test_index(DIGEST); +ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' +CREATE UNIQUE INDEX test_index +ON performance_schema.events_statements_summary_by_digest(DIGEST); +ERROR 42000: Access denied for user 'root'@'localhost' to database 'performance_schema' === modified file 'mysql-test/suite/perfschema/t/ddl_esms_by_digest.test' --- a/mysql-test/suite/perfschema/t/ddl_esms_by_digest.test 2011-05-16 11:20:58 +0000 +++ b/mysql-test/suite/perfschema/t/ddl_esms_by_digest.test 2011-06-07 10:23:30 +0000 @@ -15,4 +15,19 @@ # Tests for PERFORMANCE_SCHEMA -############################# TBD ################################# +--source include/not_embedded.inc +--source include/have_perfschema.inc + +-- error ER_DBACCESS_DENIED_ERROR +alter table performance_schema.events_statements_summary_by_digest + add column foo integer; + +truncate table performance_schema.events_statements_summary_by_digest; + +-- error ER_DBACCESS_DENIED_ERROR +ALTER TABLE performance_schema.events_statements_summary_by_digest ADD INDEX test_index(DIGEST); + +-- error ER_DBACCESS_DENIED_ERROR +CREATE UNIQUE INDEX test_index + ON performance_schema.events_statements_summary_by_digest(DIGEST); + --===============0705677841== 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\ # sjuta16neehnmira # target_branch: file:///home/mayank/mysql-tree/my_WL/5767/ # testament_sha1: d477be19c5006a2b5634a1f58c7592519f9d23ed # timestamp: 2011-06-07 15:54:12 +0530 # base_revision_id: mayank.prasad@stripped\ # hux1iev0a9u7kljy # # Begin bundle IyBCYXphYXIgcmV2aXNpb24gYnVuZGxlIHY0CiMKQlpoOTFBWSZTWcCW7+AAAjbfgAAQUOP//36n /kC//9/wUAW290DqLrXUgAUBhFQkNCGQ2UbSek0BiaA0aNAABKSGE0T0yU/UNE0AAaNAAANAZEk0 MjTEANAA0AAAAA5piYCNMCMIwAAABMIwEkgQ0CGmEJim0mE0mjJo2pp5Jmo0mmpdMsE9dUVKvWqv X9VpYxqaWriqdUFo99WdqBhhaU5lKxWI4g2nwZ1IQPoiDvzL7TbFswFpk1Hn5PCWLZeMYjHHzuID 6KTitv3XWq3m04UKz/nRKjQpYeWnxHD1AceusJgrbDVhgbhx1TchexdCSghBtDocIxphCPD5BvXR FfYNrqX3BwwHA7AmHKX2jgBYYjjghYILeaFUlsIEa5uVMRNpMB7u5/wTx5USV8pCB5JwwjAYBwMI ePEQ1jz7DLgEl/oReQg1Gw9xMsNpeJ7jm6k8LBEysA/BZ40CCIPhEUH9eGO22zYawp+ZM9bazC0V IDpFPyfz2aygwfkPfT0DUsxBSLcZ6RvAfUTLaUeI2h+LSb7axwEqlX5ymAFAsgRixxO5pI0MKYNB pAxox08zUpWkQeOHTpdfH2M5XUmWqRpqgXidUQus3BVmcLZg05XUMNDX5YX3ZdspICFzBHyWKney 1BSWOArFY68REcKYIPucUFtVY3YyF5lMVY+MQsLBQss2Haw5yh6wcqcpPYvIYEKrr4jhYYV1lU7F GUsyWyU4WKMjMdbmfA2BkbFRWOWVzObS1osjYyi4Gk0FQhuSmu+lhVC4jUahdRIVRMAUxbhmLCDk ERcDo0hS4xkzMfJfQiy8lAgeqgMvmHkFC9Sw9DyLPRVqJNWpBIJ7gwGhBKAWFBEiafkaEkkOtiJQ sYJItIicAeqUiZsPUeRCSkr18ReCTIDj70syuQxGxripIJAGRPMGBoOctBZAgdmUy9w88QgfmhL4 n1sQrveyFpz2TJRZFlq+tBtLdqRRkLReWYCYW+3JGdiTgSo+4o82rUbppKjAX2JptzzBn8TqVpN4 LJdMdBiuHo12zM0lRJTawsa8YKbmQnlR9ULCgjxLg3THZmL4bqqKH24XBUDZHWWyQyFqTH0n/H8j MR2m4vvgqrQ6LqSUkreGIdxoMHYMhSYb2sWnlCBv9gXnYcdx0N1tidWWI870jpbgn67uffboBvxa faRNQEsXeDWbXGoFvpAiu1YJFADg3qJHR2R1Ao8U7StLRV0BSMkMDmrkHaA5FgQRHM1jZNo52BB5 exx04vOKvXqdpSd0jqeLYkMQcz6z8nEV5WkszeLtyJwBSA6LzDUiUGuLo9SGcoZhvEGItUDDgMei JhbdA/vTZHMxRxA60Ne8nuIjwHhhmyE0i5HUGgUBQ4MUt5yCpCcSYzTNiGvv800Cuk8BKwFxSNoD LIOR7kw7dKZS4CF5kBO0CTFElrSokSRwHlBQCckeIEXHsrURLvAueojJmBDJVkZz+KHBQAWkzTkw EA+UbaRFzxdlutMMTHHJhgctyeBzlPT2oVO4yUg0cOXCQ9GKUEJmRy/NaFWVJU18rlWhXViW3Un1 5qQSkWDlYBgus2pSQEBKE0jP3E4hNajmxQYoYeBNdGpSeMIuTAEQGoQzgHWE2XJgkmNMje9BKLx4 fgLwIrMIIHEHRHgVF0qmBmB/iRnlaSU0TDcRcCMO8MDbaZVIHFI6w6FiYDmGYark5CYpOByIGpjM O4ciXYMfoMBQkniJaCpj0d/i7kinChIYEt38AA== --===============0705677841==--