[MDEV-8630] Datetime value dropped in "INSERT ... SELECT ... ON DUPLICATE KEY" - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Fixed
Affects Version/s: 5.5.41, 10.0.17, 5.5(EOL), 10.0(EOL), 10.1(EOL)
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'

Attachments

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

test.query.sql
2 kB
2015-08-19 02:28
test.sql.gz
3.14 MB
2015-08-19 02:25
test.variables.txt
61 kB
2015-08-19 02:27

Activity

People

Assignee:: Alexander Barkov

Reporter:: Raymond Xu

Votes:: 0 Vote for this issue

Watchers:: 4 Start watching this issue

Dates

Created:: 2015-08-17 01:42

Updated:: 2015-12-03 19:04

Resolved:: 2015-12-03 19:04

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.