error info not compatible with MySQL for set generated columns default value

[aytrack]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

 create table t1 (a int, b int as (a + 1) default 10);

2. What did you expect to see? (Required)

1221, 'Incorrect usage of DEFAULT and generated column'

3. What did you see instead (Required)

syntax error and "invalid column definition"

1064, 'You have an error in your SQL syntax; check the manual that corresponds to your TiDB version for the right syntax to use line 1 column 59 near ")"Invalid column definition '

4. What is your TiDB version? (Required)

| Release Version: v4.0.10
Edition: Community
Git Commit Hash: dbade8cda4c5a329037746e171449e0a1dfdb8b3
Git Branch: heads/refs/tags/v4.0.10
UTC Build Time: 2021-01-15 02:59:27
GoVersion: go1.13\nRace Enabled: false
TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306
Check Table Before Drop: false |