In MariaDB, when clearing a DATE field with the calendar tool, after a refresh, the field changes to 1-1-0001 in stead of null.
With a DATETIME field it works like expected and will change to null.
Steps for reproduction:
1. Launch Toad Data Point and connect to MariaDB
2. Execute below query:
CREATE TABLE `test_table` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date_insert` date DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
3. Then execute below query:
INSERT INTO test_table (date_insert)
VALUES
(CURDATE()),
(CURDATE() - INTERVAL 1 DAY),
(CURDATE() - INTERVAL 2 DAY);
4. SELECT id, date_insert FROM test_table;
5. When doing Clear table Date value with Calendar tool, after a refreshing, the field will change its value to 1-1-0001 instead of null.
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of Toad Data Point
