Type:
Priority:
Resolution:
Fixed
Component/s:
None
storage_engine tests and upstream engines/* suites went out of sync with current MariaDB code. Reasons:
as of 5.5.27, YEAR(2) is deprecated, hence the new warning;
MDEV-533 INSERT IGNORE now produces a warning if a duplicate key was encountered (change pushed along with MDEV-533
Result files need to be updated. For MDEV-533
relates to
MDEV-3942
FROM_DAYS(<timestamp column>) returns different result in MariaDB comparing to MySQL: NULL vs 0000-00-00
Closed
made changes -
2012-12-28 15:55
Field
Original Value
New Value
Link
This issue relates to TODO-60
[ TODO-60
]
made changes -
2012-12-28 15:55
Link
This issue relates to TODO-224
[ TODO-224
]
made changes -
2012-12-28 16:03
Assignee
Elena Stepanova
[ elenst
]
Sergei Golubchik
[ serg
]
made changes -
2012-12-29 11:06
Description
storage_engine tests and upstream engines/* suites went out of sync with current MariaDB code. Reasons:MDEV-553 - different error code/message on out-of-range auto-increment;MDEV-553 ).
storage_engine tests and upstream engines/* suites went out of sync with current MariaDB code. Reasons:MDEV-533 MDEV-533 MDEV-533
made changes -
2012-12-29 11:21
Assignee
Sergei Golubchik
[ serg
]
Michael Widenius
[ monty
]
made changes -
2012-12-29 11:23
Link
This issue relates to TODO-359
[ TODO-359
]
made changes -
2012-12-30 23:05
Assignee
Michael Widenius
[ monty
]
Elena Stepanova
[ elenst
]
made changes -
2012-12-30 23:51
Status
Open
[ 1
]
In Progress
[ 3
]
made changes -
2013-01-13 15:11
Assignee
Elena Stepanova
[ elenst
]
Sergei Golubchik
[ serg
]
made changes -
2013-01-13 18:42
Assignee
Sergei Golubchik
[ serg
]
Elena Stepanova
[ elenst
]
made changes -
2013-01-16 14:59
Status
In Progress
[ 3
]
Open
[ 1
]
made changes -
2013-01-16 14:59
Resolution
Fixed
[ 1
]
Status
Open
[ 1
]
Closed
[ 6
]
made changes -
2014-06-13 15:06
Workflow
defaullt
[ 25756
]
MariaDB v2
[ 45346
]
made changes -
2021-12-06 21:22
Workflow
MariaDB v3
[ 66009
]
MariaDB v4
[ 132047
]
{"report":{"fcp":1433.2000000476837,"ttfb":518.2000000476837,"pageVisibility":"visible","entityId":22456,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0.5,"journeyId":"d2811555-e6e5-4267-a8b9-b553e2783a62","navigationType":0,"readyForUser":1521.3000000715256,"redirectCount":0,"resourceLoadedEnd":1899.1000000238419,"resourceLoadedStart":523.5,"resourceTiming":[{"duration":404,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":523.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":523.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":927.5,"responseStart":0,"secureConnectionStart":0},{"duration":404.09999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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","startTime":523.8000000715256,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":523.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":927.8999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":412.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":524,"connectEnd":524,"connectStart":524,"domainLookupEnd":524,"domainLookupStart":524,"fetchStart":524,"redirectEnd":0,"redirectStart":0,"requestStart":524,"responseEnd":936.3999999761581,"responseStart":936.3999999761581,"secureConnectionStart":524},{"duration":452.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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","startTime":524.2000000476837,"connectEnd":524.2000000476837,"connectStart":524.2000000476837,"domainLookupEnd":524.2000000476837,"domainLookupStart":524.2000000476837,"fetchStart":524.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":524.2000000476837,"responseEnd":976.8000000715256,"responseStart":976.8000000715256,"secureConnectionStart":524.2000000476837},{"duration":456,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":524.3999999761581,"connectEnd":524.3999999761581,"connectStart":524.3999999761581,"domainLookupEnd":524.3999999761581,"domainLookupStart":524.3999999761581,"fetchStart":524.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":524.3999999761581,"responseEnd":980.3999999761581,"responseStart":980.3999999761581,"secureConnectionStart":524.3999999761581},{"duration":456.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":524.6000000238419,"connectEnd":524.6000000238419,"connectStart":524.6000000238419,"domainLookupEnd":524.6000000238419,"domainLookupStart":524.6000000238419,"fetchStart":524.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":524.6000000238419,"responseEnd":980.8000000715256,"responseStart":980.8000000715256,"secureConnectionStart":524.6000000238419},{"duration":456.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":524.7000000476837,"connectEnd":524.7000000476837,"connectStart":524.7000000476837,"domainLookupEnd":524.7000000476837,"domainLookupStart":524.7000000476837,"fetchStart":524.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":524.7000000476837,"responseEnd":981.2000000476837,"responseStart":981.2000000476837,"secureConnectionStart":524.7000000476837},{"duration":585.1000000238419,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":524.8999999761581,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":524.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1110,"responseStart":0,"secureConnectionStart":0},{"duration":456.7000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":525,"connectEnd":525,"connectStart":525,"domainLookupEnd":525,"domainLookupStart":525,"fetchStart":525,"redirectEnd":0,"redirectStart":0,"requestStart":525,"responseEnd":981.7000000476837,"responseStart":981.7000000476837,"secureConnectionStart":525},{"duration":585.1000000238419,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/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":525.1000000238419,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":525.1000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1110.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":457,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/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":525.3000000715256,"connectEnd":525.3000000715256,"connectStart":525.3000000715256,"domainLookupEnd":525.3000000715256,"domainLookupStart":525.3000000715256,"fetchStart":525.3000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":525.3000000715256,"responseEnd":982.3000000715256,"responseStart":982.3000000715256,"secureConnectionStart":525.3000000715256},{"duration":1037.1000000238419,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":538.8999999761581,"connectEnd":538.8999999761581,"connectStart":538.8999999761581,"domainLookupEnd":538.8999999761581,"domainLookupStart":538.8999999761581,"fetchStart":538.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":538.8999999761581,"responseEnd":1576,"responseStart":1576,"secureConnectionStart":538.8999999761581},{"duration":1360.2000000476837,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":538.8999999761581,"connectEnd":538.8999999761581,"connectStart":538.8999999761581,"domainLookupEnd":538.8999999761581,"domainLookupStart":538.8999999761581,"fetchStart":538.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":538.8999999761581,"responseEnd":1899.1000000238419,"responseStart":1899.1000000238419,"secureConnectionStart":538.8999999761581},{"duration":508.89999997615814,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1141,"connectEnd":1141,"connectStart":1141,"domainLookupEnd":1141,"domainLookupStart":1141,"fetchStart":1141,"redirectEnd":0,"redirectStart":0,"requestStart":1141,"responseEnd":1649.8999999761581,"responseStart":1649.8999999761581,"secureConnectionStart":1141},{"duration":476.89999997615814,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1426.7000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1426.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1903.6000000238419,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":321,"responseStart":518,"responseEnd":523,"domLoading":521,"domInteractive":1957,"domContentLoadedEventStart":1957,"domContentLoadedEventEnd":2010,"domComplete":2595,"loadEventStart":2595,"loadEventEnd":2596,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1906.1000000238419},{"name":"bigPipe.sidebar-id.end","time":1907.1000000238419},{"name":"bigPipe.activity-panel-pipe-id.start","time":1907.2000000476837},{"name":"bigPipe.activity-panel-pipe-id.end","time":1910.8000000715256},{"name":"activityTabFullyLoaded","time":2029.6000000238419}],"measures":[],"correlationId":"575b23c90ed7d8","effectiveType":"4g","downlink":9.3,"rtt":0,"serverDuration":139,"dbReadsTimeInMs":29,"dbConnsTimeInMs":38,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Task
Minor
MDEV-3942 FROM_DAYS(<timestamp column>) returns different result in MariaDB comparing to MySQL: NULL vs 0000-00-00
