ddl_accounts.test

# Tests for PERFORMANCE_SCHEMA

-- error ER_DBACCESS_DENIED_ERROR
alter table performance_schema.accounts
  add column foo integer;

truncate table performance_schema.accounts;

-- error ER_DBACCESS_DENIED_ERROR
ALTER TABLE performance_schema.accounts ADD INDEX test_index(CURRENT_CONNECTIONS);

-- error ER_DBACCESS_DENIED_ERROR
CREATE UNIQUE INDEX test_index ON performance_schema.accounts(CURRENT_CONNECTIONS);

-- error ER_DBACCESS_DENIED_ERROR
DROP INDEX `PRIMARY` ON performance_schema.accounts;

-- error ER_DBACCESS_DENIED_ERROR
DROP INDEX `ACCOUNT`
  ON performance_schema.accounts;

CREATE TABLE test.create_select
  AS SELECT * from performance_schema.accounts;

DROP TABLE test.create_select;