P1-[4.0 bug hunting]-[Sequence]-can not create table when primary key has sequence as default value

[AndrewDi]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. What did you do?

create sequence seq;
create table test(a bigint not null default nextval(seq),b char(3),primary key (a))

2. What did you expect to see?

create table success

3. What did you see instead?

mysql> create table test(a bigint not null default nextval(seq),b char(3),primary key (a));
ERROR 1171 (42000): All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

4. What version of TiDB are you using? (tidb-server -V or run select tidb_version(); on TiDB)

master branch

[AilinKid]

thanks for reporting, Pan.

[ChenPeng2013]

/bug p1 n

[shuke987]

/bug P1