You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Executing query "create table `user` (`idx` int (11) not null auto_increment, `name` varchar (256) not null, `role` varchar (20) not null, `created_date` datetime (6) not null default 'CURRENT_TIMESTAMP(6)', `last_modified_date` datetime (6) not null default 'CURRENT_TIMESTAMP(6)', `enabled` tinyint (1) not null default '1', primary key (`idx`)"
{"level":"error","msg":"failed to apply statements: Error 1067 (42000): Invalid default value for 'created_date'"}
The CURRENT_TIMESTAMP function, which should be applied as the default value in the field created_date, is considered a string, resulting in a bug that prevents DDL from running properly.
The text was updated successfully, but these errors were encountered:
kworkbee
changed the title
MySQL CURRENT_TIMESTAMP function is considered a string and is not processed normally
[Bug] MySQL CURRENT_TIMESTAMP function is considered a string and is not processed normally
Dec 28, 2023
In
Database
,Controller Logs:
The
CURRENT_TIMESTAMP
function, which should be applied as the default value in the fieldcreated_date
, is considered a string, resulting in a bug that prevents DDL from running properly.The text was updated successfully, but these errors were encountered: