diff options
Diffstat (limited to 'mysql-test/suite/sql_sequence/read_only.result')
-rw-r--r-- | mysql-test/suite/sql_sequence/read_only.result | 25 |
1 files changed, 25 insertions, 0 deletions
diff --git a/mysql-test/suite/sql_sequence/read_only.result b/mysql-test/suite/sql_sequence/read_only.result new file mode 100644 index 00000000000..3f6a95610dd --- /dev/null +++ b/mysql-test/suite/sql_sequence/read_only.result @@ -0,0 +1,25 @@ +create sequence s1 cache 2 engine=innodb; +connection default; +show global variables like 'innodb_read_only'; +Variable_name Value +innodb_read_only ON +use test; +set session binlog_format= row; +########################################### +read_only create error. +########################################### +show global variables like 'innodb_read_only'; +Variable_name Value +innodb_read_only ON +use test; +create sequence s2 cache 5 engine=innodb; +ERROR HY000: Can't create table `test`.`s2` (errno: 165 "Table is read only") +########################################### +read_only query error. +########################################### +select next value for s1; +ERROR HY000: Table 's1' is read only +select next value for s1; +ERROR HY000: Table 's1' is read only +select next value for s1; +ERROR HY000: Table 's1' is read only |