Description:
Update of a linked table fails with a date overflow message
How to repeat:
Try to update a row in this table:
CREATE TABLE `FTSAMP` (
`DOC` varchar(8) DEFAULT NULL,
`CLP` double DEFAULT NULL,
`LN` int(11) NOT NULL AUTO_INCREMENT,
`IN` varchar(8) NOT NULL,
`Inspector` varchar(50) DEFAULT NULL,
`BWT` double DEFAULT NULL,
`NOB` double DEFAULT NULL,
`TON` double DEFAULT NULL,
`TYP` varchar(15) DEFAULT NULL,
`BRN` varchar(50) DEFAULT NULL,
`GRA` varchar(11) DEFAULT NULL,
`SDA` datetime DEFAULT NULL,
`DSNT` datetime DEFAULT NULL,
`REG` bit(1) DEFAULT NULL,
`MNMBR` varchar(3) DEFAULT NULL,
`DEF` bit(1) DEFAULT NULL,
`MNA` varchar(30) DEFAULT NULL,
`MAD` varchar(50) DEFAULT NULL,
`MCITY` varchar(20) DEFAULT NULL,
`MST` varchar(2) DEFAULT NULL,
`MZIP` varchar(10) DEFAULT NULL,
`RES` bit(1) DEFAULT NULL,
`DRES` datetime DEFAULT NULL,
`Fwarn` bit(1) DEFAULT NULL,
`DFwarn` datetime DEFAULT NULL,
`PNL` double DEFAULT NULL,
`UNA` varchar(50) DEFAULT NULL,
`UAD` varchar(50) DEFAULT NULL,
`UCITY` varchar(30) DEFAULT NULL,
`UZIP` varchar(10) DEFAULT NULL,
`UST` varchar(2) DEFAULT NULL,
`NG` double DEFAULT NULL,
`NF` double DEFAULT NULL,
`ND` bit(1) DEFAULT NULL,
`PG` double DEFAULT NULL,
`PF` double DEFAULT NULL,
`PD` bit(1) DEFAULT NULL,
`KG` double DEFAULT NULL,
`KF` double DEFAULT NULL,
`KD` bit(1) DEFAULT NULL,
`ING` double DEFAULT NULL,
`INF` double DEFAULT NULL,
`ID` bit(1) DEFAULT NULL,
`NDXV` double DEFAULT NULL,
`NXD` bit(1) DEFAULT NULL,
`CLG` double DEFAULT NULL,
`CLF` double DEFAULT NULL,
`CLD` bit(1) DEFAULT NULL,
`CLDiff` double DEFAULT NULL,
`CLPen` double DEFAULT NULL,
`MGG` double DEFAULT NULL,
`MGF` double DEFAULT NULL,
`MGD` bit(1) DEFAULT NULL,
`SG` double DEFAULT NULL,
`SF` double DEFAULT NULL,
`SD` bit(1) DEFAULT NULL,
`BG` double DEFAULT NULL,
`BF` double DEFAULT NULL,
`BD` bit(1) DEFAULT NULL,
`CUG` double DEFAULT NULL,
`CUF` double DEFAULT NULL,
`CUD` bit(1) DEFAULT NULL,
`MANG` double DEFAULT NULL,
`MANF` double DEFAULT NULL,
`MAND` bit(1) DEFAULT NULL,
`ZNG` double DEFAULT NULL,
`ZNF` double DEFAULT NULL,
`ZND` bit(1) DEFAULT NULL,
`CAG` double DEFAULT NULL,
`CAF` double DEFAULT NULL,
`CAD` bit(1) DEFAULT NULL,
`FEF` double DEFAULT NULL,
`FEG` double DEFAULT NULL,
`FED` bit(1) DEFAULT NULL,
`SS` varchar(1) DEFAULT NULL,
`PYMT` bit(1) DEFAULT NULL,
`KMNT` varchar(60) DEFAULT NULL,
`SCU` bit(1) DEFAULT NULL,
`DateEntered` datetime DEFAULT NULL,
`LabFinished` datetime DEFAULT NULL,
`LabReady` bit(1) DEFAULT NULL,
`DEntryComments` mediumtext,
`LabComments` mediumtext,
`Final Comments` mediumtext,
`MarkedPending` bit(1) DEFAULT NULL,
`MarkedFinal` bit(1) DEFAULT NULL,
`MarkedDone` bit(1) DEFAULT NULL,
`Tobacco` bit(1) DEFAULT NULL,
`Research` bit(1) DEFAULT NULL,
`IDSAMP` varchar(50) DEFAULT NULL,
`EmailAddress` varchar(250) DEFAULT NULL,
`Complete` varchar(50) DEFAULT NULL,
`EntryDate` varchar(50) DEFAULT NULL,
`PDT` varchar(2) DEFAULT NULL,
`PB` varchar(2) DEFAULT NULL,
`PR` varchar(2) DEFAULT NULL,
`PST` varchar(2) DEFAULT NULL,
`PFT` varchar(2) DEFAULT NULL,
`PFLOOR` varchar(2) DEFAULT NULL,
`DW` varchar(2) DEFAULT NULL,
`DR` varchar(2) DEFAULT NULL,
`DST` varchar(2) DEFAULT NULL,
`DFT` varchar(2) DEFAULT NULL,
`FDT` varchar(2) DEFAULT NULL,
`FST` varchar(2) DEFAULT NULL,
`FT` varchar(2) DEFAULT NULL,
`NWI` varchar(2) DEFAULT NULL,
`NI` varchar(2) DEFAULT NULL,
`INDEXVAL` varchar(20) DEFAULT NULL,
`INVOICENO` varchar(50) DEFAULT NULL,
`CARNO` varchar(50) DEFAULT NULL,
`NOSAMPLES` varchar(50) DEFAULT NULL,
`CORESAMP` int(11) DEFAULT NULL,
`INSPNAME` varchar(200) DEFAULT NULL,
`VERIFIED` varchar(2) DEFAULT NULL,
`VERIFIEDDTE` datetime DEFAULT NULL,
`ResMetho` varchar(50) DEFAULT NULL,
`ConPhone` varchar(15) DEFAULT NULL,
`Void` bit(1) DEFAULT NULL,
`County` varchar(50) DEFAULT NULL,
`TimeStmp` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`LN`),
UNIQUE KEY `LN_UNIQUE` (`LN`),
UNIQUE KEY `IN_UNIQUE` (`IN`)
) ENGINE=InnoDB AUTO_INCREMENT=2035 DEFAULT CHARSET=utf8mb4;
Suggested fix:
Somehow get updating to work
