diff options
Diffstat (limited to 'mysql-test/suite/sql_sequence/read_only.result')
-rw-r--r-- | mysql-test/suite/sql_sequence/read_only.result | 38 |
1 files changed, 38 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..38edcc0894b --- /dev/null +++ b/mysql-test/suite/sql_sequence/read_only.result @@ -0,0 +1,38 @@ +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 +select * from s1; +next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count +1 1 9223372036854775806 1 1 2 0 0 +select * from s1; +next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count +1 1 9223372036854775806 1 1 2 0 0 +select next value for s1; +next value for s1 +1 +select * from s1; +next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count +3 1 9223372036854775806 1 1 2 0 0 +drop sequence s1; |