bzr commit into mysql-trunk-wl5767 branch (mayank.prasad:3369)

[Mayank Prasad]

#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);
+


Attachment: [text/bzr-bundle] bzr/[e-mail]