~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to mysql-test/r/read_only_innodb.result

  • Committer: brian
  • Date: 2008-06-25 05:29:13 UTC
  • Revision ID: brian@localhost.localdomain-20080625052913-6upwo0jsrl4lnapl
clean slate

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
DROP TABLE IF EXISTS table_11733 ;
 
2
grant CREATE, SELECT, DROP on *.* to test@localhost;
 
3
set global read_only=0;
 
4
create table table_11733 (a int) engine=InnoDb;
 
5
BEGIN;
 
6
insert into table_11733 values(11733);
 
7
set global read_only=1;
 
8
select @@global.read_only;
 
9
@@global.read_only
 
10
1
 
11
select * from table_11733 ;
 
12
a
 
13
11733
 
14
COMMIT;
 
15
ERROR HY000: The MySQL server is running with the --read-only option so it cannot execute this statement
 
16
set global read_only=0;
 
17
drop table table_11733 ;
 
18
drop user test@localhost;