Debian Codegraph @

mysql-test/suite/sql_sequence/aria.result

raw
1 set @@default_storage_engine="aria";
2 CREATE SEQUENCE t1 cache=10;
3 show create sequence t1;
4 Table Create Table
5 t1 CREATE SEQUENCE `t1` start with 1 minvalue 1 maxvalue 9223372036854775806 increment by 1 cache 10 nocycle ENGINE=Aria
6 select NEXT VALUE for t1,seq from seq_1_to_20;
7 NEXT VALUE for t1 seq
8 1 1
9 2 2
10 3 3
11 4 4
12 5 5
13 6 6
14 7 7
15 8 8
16 9 9
17 10 10
18 11 11
19 12 12
20 13 13
21 14 14
22 15 15
23 16 16
24 17 17
25 18 18
26 19 19
27 20 20
28 select * from t1;
29 next_not_cached_value minimum_value maximum_value start_value increment cache_size cycle_option cycle_count
30 21 1 9223372036854775806 1 1 10 0 0
31 drop sequence t1;
32 create sequence s1;
33 check table s1;
34 Table Op Msg_type Msg_text
35 test.s1 check note The storage engine for the table doesn't support check
36 select next value for s1;
37 next value for s1
38 1
39 flush tables;
40 check table s1;
41 Table Op Msg_type Msg_text
42 test.s1 check note The storage engine for the table doesn't support check
43 select next value for s1;
44 next value for s1
45 1001
46 flush tables;
47 repair table s1;
48 Table Op Msg_type Msg_text
49 test.s1 repair status OK
50 select next value for s1;
51 next value for s1
52 2001
53 drop sequence s1;
54 CREATE SEQUENCE t1;
55 alter sequence t1 minvalue=100;
56 ERROR HY000: Sequence 'test.t1' has out of range value for options
57 alter sequence t1 minvalue=100 start=100 restart=100;
58 rename table t1 to t2;
59 select next value for t2;
60 next value for t2
61 100
62 alter table t2 rename to t1;
63 select next value for t1;
64 next value for t1
65 1100
66 drop table t1;