Type:
Task
Priority:
Major
Resolution:
Unresolved
Fix Version/s:
None
Component/s:
None
Multi-columns Unique index behavior with NULL value should be same as Oracle db server when setting sql_mode=ORACLE
Init :
CREATE TABLE `test` (
`Col1` VARCHAR(50) NULL,
`Col2` VARCHAR(50) NULL,
UNIQUE INDEX `UX_COL1_COL2` (`Col1`, `Col2`)
)
ENGINE=InnoDB;
insert into TEST (Col1, Col2) values ('A','B'), (NULL,NULL), ('A',NULL), (NULL,'B');
Use cases :
insert into TEST (Col1, Col2) values (NULL,NULL);
=> accepted by Oracle (11.2) & MariaDB (10.2, 10.3) => OK
insert into TEST (Col1, Col2) values ('A',NULL);
=> rejected by Oracle (11.2) but accepted by MariaDB (10.2, 10.3) => Issue
insert into TEST (Col1, Col2) values (NULL,'B');
=> rejected by Oracle (11.2) but accepted by MariaDB (10.2, 10.3) => Issue
insert into TEST (Col1, Col2) values ('A','B');
=> rejected by Oracle (11.2) & MariaDB (10.2, 10.3) => OK
relates to
MDEV-10574
sql_mode=ORACLE: IS NULL and empty strings
Open
There are no comments yet on this issue.
{"report":{"fcp":784.4000000059605,"ttfb":172.5,"pageVisibility":"visible","entityId":61594,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":16,"apdex":1,"journeyId":"682f7d2e-cf5b-4ac8-b327-a788ed772208","navigationType":0,"readyForUser":849.5,"redirectCount":0,"resourceLoadedEnd":810.4000000059605,"resourceLoadedStart":180.10000000149012,"resourceTiming":[{"duration":57.30000000447035,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":180.10000000149012,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":180.10000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":237.40000000596046,"responseStart":0,"secureConnectionStart":0},{"duration":57.5,"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":180.40000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":180.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":237.90000000596046,"responseStart":0,"secureConnectionStart":0},{"duration":113.80000000447035,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":180.5,"connectEnd":180.5,"connectStart":180.5,"domainLookupEnd":180.5,"domainLookupStart":180.5,"fetchStart":180.5,"redirectEnd":0,"redirectStart":0,"requestStart":246.60000000149012,"responseEnd":294.30000000447035,"responseStart":258.5,"secureConnectionStart":180.5},{"duration":121.70000000298023,"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":180.60000000149012,"connectEnd":180.60000000149012,"connectStart":180.60000000149012,"domainLookupEnd":180.60000000149012,"domainLookupStart":180.60000000149012,"fetchStart":180.60000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":246.60000000149012,"responseEnd":302.30000000447035,"responseStart":259.20000000298023,"secureConnectionStart":180.60000000149012},{"duration":92.39999999850988,"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":180.80000000447035,"connectEnd":261,"connectStart":261,"domainLookupEnd":261,"domainLookupStart":261,"fetchStart":180.80000000447035,"redirectEnd":0,"redirectStart":0,"requestStart":261.6000000014901,"responseEnd":273.20000000298023,"responseStart":272.5,"secureConnectionStart":261},{"duration":94.59999999403954,"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":180.90000000596046,"connectEnd":180.90000000596046,"connectStart":180.90000000596046,"domainLookupEnd":180.90000000596046,"domainLookupStart":180.90000000596046,"fetchStart":180.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":261.90000000596046,"responseEnd":275.5,"responseStart":273.70000000298023,"secureConnectionStart":180.90000000596046},{"duration":95.80000000447035,"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":181,"connectEnd":181,"connectStart":181,"domainLookupEnd":181,"domainLookupStart":181,"fetchStart":181,"redirectEnd":0,"redirectStart":0,"requestStart":262.90000000596046,"responseEnd":276.80000000447035,"responseStart":276.1000000014901,"secureConnectionStart":181},{"duration":89,"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":181.20000000298023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":181.20000000298023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":270.20000000298023,"responseStart":0,"secureConnectionStart":0},{"duration":99.29999999701977,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":181.30000000447035,"connectEnd":181.30000000447035,"connectStart":181.30000000447035,"domainLookupEnd":181.30000000447035,"domainLookupStart":181.30000000447035,"fetchStart":181.30000000447035,"redirectEnd":0,"redirectStart":0,"requestStart":264.1000000014901,"responseEnd":280.6000000014901,"responseStart":279.90000000596046,"secureConnectionStart":181.30000000447035},{"duration":88.79999999701977,"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":181.40000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":181.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":270.20000000298023,"responseStart":0,"secureConnectionStart":0},{"duration":106.89999999850988,"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":181.60000000149012,"connectEnd":181.60000000149012,"connectStart":181.60000000149012,"domainLookupEnd":181.60000000149012,"domainLookupStart":181.60000000149012,"fetchStart":181.60000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":267.90000000596046,"responseEnd":288.5,"responseStart":286.5,"secureConnectionStart":181.60000000149012},{"duration":596,"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":213.10000000149012,"connectEnd":213.10000000149012,"connectStart":213.10000000149012,"domainLookupEnd":213.10000000149012,"domainLookupStart":213.10000000149012,"fetchStart":213.10000000149012,"redirectEnd":0,"redirectStart":0,"requestStart":797.8000000044703,"responseEnd":809.1000000014901,"responseStart":808.5,"secureConnectionStart":213.10000000149012},{"duration":597.1000000014901,"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":213.30000000447035,"connectEnd":213.30000000447035,"connectStart":213.30000000447035,"domainLookupEnd":213.30000000447035,"domainLookupStart":213.30000000447035,"fetchStart":213.30000000447035,"redirectEnd":0,"redirectStart":0,"requestStart":799.3000000044703,"responseEnd":810.4000000059605,"responseStart":809.7000000029802,"secureConnectionStart":213.30000000447035},{"duration":267.1000000014901,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":492.1000000014901,"connectEnd":492.1000000014901,"connectStart":492.1000000014901,"domainLookupEnd":492.1000000014901,"domainLookupStart":492.1000000014901,"fetchStart":492.1000000014901,"redirectEnd":0,"redirectStart":0,"requestStart":720.5,"responseEnd":759.2000000029802,"responseStart":758.3000000044703,"secureConnectionStart":492.1000000014901}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":30,"responseStart":172,"responseEnd":217,"domLoading":176,"domInteractive":904,"domContentLoadedEventStart":904,"domContentLoadedEventEnd":958,"domComplete":1608,"loadEventStart":1608,"loadEventEnd":1608,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":888.1000000014901},{"name":"bigPipe.sidebar-id.end","time":889.1000000014901},{"name":"bigPipe.activity-panel-pipe-id.start","time":889.2000000029802},{"name":"bigPipe.activity-panel-pipe-id.end","time":889.8000000044703},{"name":"activityTabFullyLoaded","time":964.7000000029802}],"measures":[],"correlationId":"a13b062c7a8f4a","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":78,"dbReadsTimeInMs":10,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}