polardbxengine/mysql-test/suite/xengine_perfschema/t/ddl_session_status.test

21 lines
563 B
Plaintext

# Tests for PERFORMANCE_SCHEMA
-- error ER_DBACCESS_DENIED_ERROR
alter table performance_schema.session_status
add column foo integer;
-- error ER_TABLEACCESS_DENIED_ERROR
truncate table performance_schema.session_status;
-- error ER_DBACCESS_DENIED_ERROR
ALTER TABLE performance_schema.session_status
ADD INDEX test_index(VARIABLE_NAME);
-- error ER_DBACCESS_DENIED_ERROR
CREATE UNIQUE INDEX test_index
ON performance_schema.session_status(VARIABLE_NAME);
-- error ER_DBACCESS_DENIED_ERROR
DROP INDEX `PRIMARY`
ON performance_schema.session_status;