We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Please answer these questions before submitting your issue. Thanks!
drop table if exists t1; create table t1 (da date default '1962-03-03 23:33:34', dt datetime default '1962-03-03'); show create table t1;
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | t1 | CREATE TABLE `t1` ( `da` date DEFAULT '1962-03-03', `dt` datetime DEFAULT '1962-03-03 00:00:00' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | +-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | t1 | CREATE TABLE `t1` ( `da` date DEFAULT '1962-03-03 23:33:34', `dt` datetime DEFAULT '1962-03-03 00:00:00' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin |
| Release Version: v5.4.0-alpha-264-g6efa36df6 Edition: Community Git Commit Hash: 6efa36df6cff325106f67ecfe3d79816ba37ca6a Git Branch: master UTC Build Time: 2021-11-29 16:57:51 GoVersion: go1.17.2 Race Enabled: false TiKV Min Version: v3.0.0-60965b006877ca7234adaced7890d7b029ed1306 Check Table Before Drop: false |
The text was updated successfully, but these errors were encountered:
DDL: Wrong Date type column default value
730e63c
close #30358
DDL: Wrong Date type colunm's default value
4531b47
close pingcap#30358
DDL: Wrong Date type colunm's default value (#33571)
5fa3da7
ref #30358
Benjamin2037
Successfully merging a pull request may close this issue.
Bug Report
Please answer these questions before submitting your issue. Thanks!
1. Minimal reproduce step (Required)
2. What did you expect to see? (Required)
3. What did you see instead (Required)
4. What is your TiDB version? (Required)
The text was updated successfully, but these errors were encountered: