Auto-increment column generates same values with global sequence

[actiontech-bot]

Raised by: @zhunina
Steps:

1. Create a table:
   create table sbtest1(id int,name varchar(8),p_id int primary key auto_increment);
2. Make 4 shardings, whose sharding column is id
3. Make a global sequence

GLOBAL.HISIDS=
GLOBAL.MINID=10001
GLOBAL.MAXID=20000
GLOBAL.CURID=10000

4. Query insert into sbtest1(id,name,p_id) values(1,'a',next value for MYCATSEQ_GLOBAL);
   returns (1,‘a’,10001)
5. Query insert into sbtest1(id,name,p_id) values(2,'a',next value for MYCATSEQ_GLOBAL),(3,'a',next value for MYCATSEQ_GLOBAL),(4,'a',next value for MYCATSEQ_GLOBAL);
   returns (2,'a',10002),(3,'a',10002),(4,'a',10002), which is not correct

Expectation:

Step 5 should give increment values of global sequence.

[zhunina]

Fixed
This type of sequence has been changed to timestamp