| 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; |