# Copyright (C) 2008-2009 Sun Microsystems, Inc # # This program is free software; you can redistribute it and/or modify # it under the terms of the GNU General Public License as published by # the Free Software Foundation; version 2 of the License. # # This program is distributed in the hope that it will be useful, # but WITHOUT ANY WARRANTY; without even the implied warranty of # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the # GNU General Public License for more details. # # You should have received a copy of the GNU General Public License # along with this program; if not, write to the Free Software # Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA # Tests for PERFORMANCE_SCHEMA --source include/not_embedded.inc --source include/have_perfschema.inc select * from performance_schema.SETUP_TIMERS; select * from performance_schema.SETUP_TIMERS where name='Wait'; select * from performance_schema.SETUP_TIMERS where timer_name='CYCLE'; --replace_result '\'setup_timers' '\'SETUP_TIMERS' --error ER_TABLEACCESS_DENIED_ERROR insert into performance_schema.SETUP_TIMERS set name='FOO', timer_name='CYCLE'; --replace_result '\'setup_timers' '\'SETUP_TIMERS' --error ER_WRONG_PERFSCHEMA_USAGE update performance_schema.SETUP_TIMERS set name='FOO'; update performance_schema.SETUP_TIMERS set timer_name='MILLISECOND'; select * from performance_schema.SETUP_TIMERS; update performance_schema.SETUP_TIMERS set timer_name='CYCLE'; --replace_result '\'setup_timers' '\'SETUP_TIMERS' --error ER_TABLEACCESS_DENIED_ERROR delete from performance_schema.SETUP_TIMERS; --replace_result '\'setup_timers' '\'SETUP_TIMERS' --error ER_TABLEACCESS_DENIED_ERROR delete from performance_schema.SETUP_TIMERS where name='Wait'; LOCK TABLES performance_schema.SETUP_TIMERS READ; UNLOCK TABLES; LOCK TABLES performance_schema.SETUP_TIMERS WRITE; UNLOCK TABLES;