Mysql Table Partitioned and not not applying CURRENT_TIMESTAMP

46 Views Asked by At

I am wondering why my default time value has stopped working on my database when I partitioned it into months. MySQL 8.1

Is this normal behavior?

Is there a alternative solution of setting this default value inside MySQL?

Below is the table

CREATE TABLE `datalogvalues1` (
  `dlvID` int NOT NULL AUTO_INCREMENT,
  `dlvVarID` int NOT NULL,
  `dlvValue` decimal(16,3) NOT NULL DEFAULT '0.000',
  `dlvCreated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `dlvModfied` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`dlvID`,`dlvCreated`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
/*!50100 PARTITION BY RANGE (to_days(`dlvCreated`))
(PARTITION `start` VALUES LESS THAN (0) ENGINE = InnoDB,
 PARTITION from202211 VALUES LESS THAN (738855) ENGINE = InnoDB,
 PARTITION from202212 VALUES LESS THAN (738886) ENGINE = InnoDB,
 PARTITION from202301 VALUES LESS THAN (738917) ENGINE = InnoDB,
 PARTITION from202302 VALUES LESS THAN (738945) ENGINE = InnoDB,
 PARTITION from202303 VALUES LESS THAN (738976) ENGINE = InnoDB,
 PARTITION from202304 VALUES LESS THAN (739006) ENGINE = InnoDB,
 PARTITION from202305 VALUES LESS THAN (739037) ENGINE = InnoDB,
 PARTITION from202306 VALUES LESS THAN (739067) ENGINE = InnoDB,
 PARTITION from202307 VALUES LESS THAN (739098) ENGINE = InnoDB,
 PARTITION from202308 VALUES LESS THAN (739129) ENGINE = InnoDB,
 PARTITION from202309 VALUES LESS THAN (739159) ENGINE = InnoDB,
 PARTITION from202310 VALUES LESS THAN (739190) ENGINE = InnoDB,
 PARTITION from202311 VALUES LESS THAN (739220) ENGINE = InnoDB,
 PARTITION future VALUES LESS THAN MAXVALUE ENGINE = InnoDB) */;
0

There are 0 best solutions below