Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 5.5.41, 10.0.17, 5.5, 10.0, 10.1
-
Fix Version/s: 5.5.47
-
Component/s: Character Sets, Data Manipulation - Update
-
Labels:None
-
Environment:Debian Squeeze x64
-
Sprint:5.5.47-1
Description
INSERT INTO ... |
SELECT ... |
GREATEST( COALESCE(`inspection`.`ts`, 0), COALESCE(`inspection_details`.`ts`, 0), COALESCE(`open_time_reason`.`ts`, 0) |
) AS `changed_at` |
ON DUPLICATE KEY UPDATE ... |
`changed_at` = VALUES(`changed_at`) |
In MySQL the changed_at will be the expected value from the greatest function, but in MariaDB it will be '0000-00-00 00:00:00'