Debian Codegraph @

mysql-test/suite/sql_sequence/lock.result

raw
1 drop table if exists s1, t1, t2;
2 CREATE SEQUENCE s1;
3 create table t1 (a int);
4 create table t2 (a int);
5 LOCK TABLE s1 WRITE, t1 write;
6 create or replace sequence s1;
7 select * from s1;
8 next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count
9 1 1 9223372036854775806 1 1 1000 0 0
10 select * from t1;
11 a
12 select * from t2;
13 ERROR HY000: Table 't2' was not locked with LOCK TABLES
14 unlock tables;
15 select * from t1;
16 a
17 select * from t2;
18 a
19 drop tables s1, t1, t2;
20 CREATE SEQUENCE s1;
21 LOCK TABLE s1 READ;
22 SELECT NEXTVAL(s1);
23 ERROR HY000: Table 's1' was locked with a READ lock and can't be updated
24 SELECT NEXTVAL(s);
25 ERROR HY000: Table 's' was not locked with LOCK TABLES
26 DROP SEQUENCE s1;
27 ERROR HY000: Table 's1' was locked with a READ lock and can't be updated
28 unlock tables;
29 DROP SEQUENCE s1;
30 CREATE SEQUENCE seq1;
31 CREATE SEQUENCE seq2;
32 LOCK TABLE seq1 WRITE, seq2 WRITE;
33 INSERT INTO seq1 VALUES (1, 1, 100000, 1, 1, 100, 1, 1);
34 DROP SEQUENCE seq1, seq2;
35 CREATE OR REPLACE SEQUENCE s1 ENGINE=MyISAM;
36 LOCK TABLE s1 WRITE;
37 TRUNCATE TABLE s1;
38 ERROR HY000: Storage engine SEQUENCE of the table `test`.`s1` doesn't have this option
39 DROP SEQUENCE s1;