Type:
Priority:
Resolution:
Fixed
Affects Version/s:
10.2.17 , 10.3.8 , 5.5(EOL) , 10.0(EOL) , 10.1(EOL) , 10.2(EOL) , 10.3(EOL)
When having a DATE column on the master, a DATETIME column on the slave, and binlog_format=ROW, inserting into the table fails on the salve with:
Last_SQL_Error: Column 1 of table 'test.t1' cannot be converted from type 'date' to type 'datetime'
even with slave_type_conversions=ALL_NON_LOSSY, even though a conversion from a DATE to a DATETIME should be a lossles operation.
In the MySQL 5.6 manual this conversion is listed as "not supported before 5.5.3". In the 5.7 and 5.8 versions of the manual this paragraph has been removed, but still DATE and DATETIME are missing from the list of supported operations.
Our own documentation doesn't seem to mention supported conversion types at all.
https://dev.mysql.com/doc/refman/5.6/en/replication-features-differing-tables.html
made changes -
2018-08-29 23:38
Field
Original Value
New Value
Status
Open
[ 1
]
Confirmed
[ 10101
]
made changes -
2018-08-29 23:39
Component/s
Documentation
[ 10903
]
Fix Version/s
10.2
[ 14601
]
Fix Version/s
10.3
[ 22126
]
Affects Version/s
5.5
[ 15800
]
Affects Version/s
10.0
[ 16000
]
Affects Version/s
10.1
[ 16100
]
Affects Version/s
10.2
[ 14601
]
Affects Version/s
10.3
[ 22126
]
Assignee
Andrei Elkin
[ elkin
]
Labels
upstream
made changes -
2018-10-02 11:24
Status
Confirmed
[ 10101
]
In Progress
[ 3
]
made changes -
2018-10-04 18:29
Assignee
Andrei Elkin
[ elkin
]
Alexander Barkov
[ bar
]
Status
In Progress
[ 3
]
In Review
[ 10002
]
made changes -
2018-10-11 17:27
Assignee
Alexander Barkov
[ bar
]
Andrei Elkin
[ elkin
]
Status
In Review
[ 10002
]
Stalled
[ 10000
]
made changes -
2018-10-16 10:00
Fix Version/s
10.2.19
[ 23207
]
Fix Version/s
10.2
[ 14601
]
Fix Version/s
10.3
[ 22126
]
Resolution
Fixed
[ 1
]
Status
Stalled
[ 10000
]
Closed
[ 6
]
made changes -
2018-11-14 10:16
Link
This issue relates to TODO-1576
[ TODO-1576
]
made changes -
2021-12-06 21:48
Workflow
MariaDB v3
[ 89158
]
MariaDB v4
[ 154874
]
{"report":{"fcp":1189.4000000953674,"ttfb":335.7000002861023,"pageVisibility":"visible","entityId":69433,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"854f3300-b210-4059-8465-246e6f158521","navigationType":0,"readyForUser":1265.5,"redirectCount":0,"resourceLoadedEnd":1229.8000001907349,"resourceLoadedStart":341.30000019073486,"resourceTiming":[{"duration":294.69999980926514,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":341.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":341.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":636,"responseStart":0,"secureConnectionStart":0},{"duration":294.7000002861023,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true&whisper-enabled=true","startTime":341.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":341.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":636.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":303.7999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":341.7000002861023,"connectEnd":341.7000002861023,"connectStart":341.7000002861023,"domainLookupEnd":341.7000002861023,"domainLookupStart":341.7000002861023,"fetchStart":341.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":341.7000002861023,"responseEnd":645.5,"responseStart":645.5,"secureConnectionStart":341.7000002861023},{"duration":346.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true&whisper-enabled=true","startTime":342,"connectEnd":342,"connectStart":342,"domainLookupEnd":342,"domainLookupStart":342,"fetchStart":342,"redirectEnd":0,"redirectStart":0,"requestStart":342,"responseEnd":688.8000001907349,"responseStart":688.8000001907349,"secureConnectionStart":342},{"duration":350.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":342.2000002861023,"connectEnd":342.2000002861023,"connectStart":342.2000002861023,"domainLookupEnd":342.2000002861023,"domainLookupStart":342.2000002861023,"fetchStart":342.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":342.2000002861023,"responseEnd":692.9000000953674,"responseStart":692.9000000953674,"secureConnectionStart":342.2000002861023},{"duration":351,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":342.40000009536743,"connectEnd":342.40000009536743,"connectStart":342.40000009536743,"domainLookupEnd":342.40000009536743,"domainLookupStart":342.40000009536743,"fetchStart":342.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":342.40000009536743,"responseEnd":693.4000000953674,"responseStart":693.3000001907349,"secureConnectionStart":342.40000009536743},{"duration":351.2000002861023,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":342.5,"connectEnd":342.5,"connectStart":342.5,"domainLookupEnd":342.5,"domainLookupStart":342.5,"fetchStart":342.5,"redirectEnd":0,"redirectStart":0,"requestStart":342.5,"responseEnd":693.7000002861023,"responseStart":693.7000002861023,"secureConnectionStart":342.5},{"duration":450.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":342.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":342.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":792.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":351.2999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":342.80000019073486,"connectEnd":342.80000019073486,"connectStart":342.80000019073486,"domainLookupEnd":342.80000019073486,"domainLookupStart":342.80000019073486,"fetchStart":342.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":342.80000019073486,"responseEnd":694.0999999046326,"responseStart":694.0999999046326,"secureConnectionStart":342.80000019073486},{"duration":450,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":343,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":343,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":793,"responseStart":0,"secureConnectionStart":0},{"duration":351.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":343.2000002861023,"connectEnd":343.2000002861023,"connectStart":343.2000002861023,"domainLookupEnd":343.2000002861023,"domainLookupStart":343.2000002861023,"fetchStart":343.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":343.2000002861023,"responseEnd":694.7000002861023,"responseStart":694.7000002861023,"secureConnectionStart":343.2000002861023},{"duration":576.8999996185303,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":349.2000002861023,"connectEnd":349.2000002861023,"connectStart":349.2000002861023,"domainLookupEnd":349.2000002861023,"domainLookupStart":349.2000002861023,"fetchStart":349.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":349.2000002861023,"responseEnd":926.0999999046326,"responseStart":926.0999999046326,"secureConnectionStart":349.2000002861023},{"duration":880.5999999046326,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":349.2000002861023,"connectEnd":349.2000002861023,"connectStart":349.2000002861023,"domainLookupEnd":349.2000002861023,"domainLookupStart":349.2000002861023,"fetchStart":349.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":349.2000002861023,"responseEnd":1229.8000001907349,"responseStart":1229.8000001907349,"secureConnectionStart":349.2000002861023},{"duration":131.80000019073486,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":805.4000000953674,"connectEnd":805.4000000953674,"connectStart":805.4000000953674,"domainLookupEnd":805.4000000953674,"domainLookupStart":805.4000000953674,"fetchStart":805.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":805.4000000953674,"responseEnd":937.2000002861023,"responseStart":937.2000002861023,"secureConnectionStart":805.4000000953674}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":138,"responseStart":336,"responseEnd":342,"domLoading":339,"domInteractive":1343,"domContentLoadedEventStart":1343,"domContentLoadedEventEnd":1393,"domComplete":1664,"loadEventStart":1664,"loadEventEnd":1665,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1303.3000001907349},{"name":"bigPipe.sidebar-id.end","time":1304.0999999046326},{"name":"bigPipe.activity-panel-pipe-id.start","time":1304.3000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":1309.2000002861023},{"name":"activityTabFullyLoaded","time":1423.8000001907349}],"measures":[],"correlationId":"f476075ca15a6e","effectiveType":"4g","downlink":9.7,"rtt":0,"serverDuration":145,"dbReadsTimeInMs":26,"dbConnsTimeInMs":37,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Major
Reproducible easily, I'll leave it to Elkin to decide whether it needs to be fixed, or documented, or both.