When Step 2: Create table WORKER_NODE, Invalid default value for 'CREATED' issures</

<a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/us

Invalid default value for 'CREATED' about uid-generator HOT 2 CLOSED

poppop0911 commented on July 24, 2024

Invalid default value for 'CREATED'

from uid-generator.

Comments (2)

baozhi commented on July 24, 2024

@poppop0911 Thank you for your feedback.

The column 'CREATED' is declared as TIMESTAMP. Please check the create table script:
https://github.com/baidu/uid-generator#step-2-create-table-worker_node
https://github.com/baidu/uid-generator/blob/master/src/main/scripts/WORKER_NODE.sql

If the script above still does not work, try the sql generated by show create table WORKER_NODE

CREATE TABLE `WORKER_NODE` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'auto increment id',
  `HOST_NAME` varchar(64) COLLATE utf8_bin NOT NULL COMMENT 'host name',
  `PORT` varchar(64) COLLATE utf8_bin NOT NULL COMMENT 'port',
  `TYPE` int(11) NOT NULL COMMENT 'node type: ACTUAL or CONTAINER',
  `LAUNCH_DATE` date NOT NULL COMMENT 'launch date',
  `MODIFIED` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'modified time',
  `CREATED` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'created time',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='DB WorkerID Assigner for UID Generator'

from uid-generator.

poppop0911 commented on July 24, 2024

The possible reason is that CREATED requires a default value
MYSQL server-system-variables --explicit_defaults_for_timestamp default Yes
By testing the following statement is ok

 CREATE TABLE `WORKER_NODE` (
  `ID` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'auto increment id',
  `HOST_NAME` varchar(64) NOT NULL COMMENT 'host name',
  `PORT` varchar(64) NOT NULL COMMENT 'port',
  `TYPE` int(11) NOT NULL COMMENT 'node type: ACTUAL or CONTAINER',
  `LAUNCH_DATE` date NOT NULL COMMENT 'launch date',
  `MODIFIED` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'modified time',
  `CREATED` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='DB WorkerID Assigner for UID Generator'