-
Bug
-
-
Major
-
Resolution:
Fixed
-
None
-
-
-
They fail like this
rocksdb.type_binary_indexes [ fail ]
|
Test ended at 2016-11-20 22:55:50
|
|
CURRENT_TEST: rocksdb.type_binary_indexes
|
--- /home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/mysql-test/rocksdb/r/type_binary_indexes.result 2016-10-06 17:30:25.595958776 +0000
|
+++ /home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/mysql-test/rocksdb/r/type_binary_indexes.reject 2016-11-20 22:55:49.679353957 +0000
|
@@ -39,7 +39,7 @@
|
SHOW INDEX IN t1;
|
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
|
t1 0 PRIMARY 1 pk A 1000 NULL NULL LSMTREE
|
-t1 1 v16 1 v16 A 500 10 NULL YES LSMTREE
|
+t1 1 v16 1 v16 A 1000 10 NULL YES LSMTREE
|
INSERT INTO t1 (b,b20,v16,v128,pk) VALUES ('a','char1','varchar1a','varchar1b',1),('a','char2','varchar2a','varchar2b',2),('b','char3','varchar1a','varchar1b',3),('c','char4','varchar3a','varchar3b',4),('d','char5','varchar4a','varchar3b',5),('e','char6','varchar2a','varchar3b',6);
|
INSERT INTO t1 (b,b20,v16,v128,pk) SELECT b,b20,v16,v128,pk+100 FROM t1;
|
EXPLAIN SELECT HEX(SUBSTRING(v16,0,3)) FROM t1 WHERE v16 LIKE 'varchar%';
|
...
rocksdb.type_blob_indexes w2 [ fail ]
|
Test ended at 2016-11-18 22:41:49
|
|
CURRENT_TEST: rocksdb.type_blob_indexes
|
--- /home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/mysql-test/rocksdb/r/type_blob_indexes.result 2016-10-06 17:30:25.595958776 +0000
|
+++ /home/psergey/dev-git/10.2-mariarocks/storage/rocksdb/mysql-test/rocksdb/r/type_blob_indexes.reject 2016-11-18 22:41:49.527347338 +0000
|
@@ -105,7 +105,7 @@
|
SHOW INDEX IN t1;
|
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
|
t1 0 PRIMARY 1 pk A 1000 NULL NULL LSMTREE
|
-t1 1 m 1 m A 500 128 NULL YES LSMTREE
|
+t1 1 m 1 m A 1000 128 NULL YES LSMTREE
|
INSERT INTO t1 (b,t,m,l) VALUES
|
('','','',''),
|
('a','b','c','d'),
|
The difference in results doesn't look like a failure, but we need to investigate why it happens.
Sergei Petrunia
made changes -
Assignee
|
|
Sergei Petrunia
[ psergey
]
|
Sergei Petrunia
made changes -
Component/s
|
|
Storage Engine - RocksDB
[ 13901
]
|
Fix Version/s
|
|
N/A
[ 14700
]
|
Resolution
|
|
Fixed
[ 1
]
|
Status
|
Open
[ 1
]
|
Closed
[ 6
]
|
Sergei Golubchik
made changes -
Workflow
|
MariaDB v3
[ 78394
]
|
MariaDB v4
[ 151244
]
|
{"report":{"fcp":891.8999996185303,"ttfb":242.29999923706055,"pageVisibility":"visible","entityId":58994,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"adaaa1a1-680c-4707-9191-957522d0f0ec","navigationType":0,"readyForUser":967.6999998092651,"redirectCount":0,"resourceLoadedEnd":1024.1999998092651,"resourceLoadedStart":248,"resourceTiming":[{"duration":93.59999942779541,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":248,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":248,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":341.5999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":93.60000038146973,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":248.29999923706055,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":248.29999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":341.8999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":130.89999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":248.5,"connectEnd":248.5,"connectStart":248.5,"domainLookupEnd":248.5,"domainLookupStart":248.5,"fetchStart":248.5,"redirectEnd":0,"redirectStart":0,"requestStart":248.5,"responseEnd":379.3999996185303,"responseStart":379.3999996185303,"secureConnectionStart":248.5},{"duration":212.0999994277954,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":248.69999980926514,"connectEnd":248.69999980926514,"connectStart":248.69999980926514,"domainLookupEnd":248.69999980926514,"domainLookupStart":248.69999980926514,"fetchStart":248.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":248.69999980926514,"responseEnd":460.79999923706055,"responseStart":460.79999923706055,"secureConnectionStart":248.69999980926514},{"duration":215.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":249,"connectEnd":249,"connectStart":249,"domainLookupEnd":249,"domainLookupStart":249,"fetchStart":249,"redirectEnd":0,"redirectStart":0,"requestStart":249,"responseEnd":464.69999980926514,"responseStart":464.69999980926514,"secureConnectionStart":249},{"duration":216.0999994277954,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":249.19999980926514,"connectEnd":249.19999980926514,"connectStart":249.19999980926514,"domainLookupEnd":249.19999980926514,"domainLookupStart":249.19999980926514,"fetchStart":249.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":249.19999980926514,"responseEnd":465.29999923706055,"responseStart":465.19999980926514,"secureConnectionStart":249.19999980926514},{"duration":216.30000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":249.29999923706055,"connectEnd":249.29999923706055,"connectStart":249.29999923706055,"domainLookupEnd":249.29999923706055,"domainLookupStart":249.29999923706055,"fetchStart":249.29999923706055,"redirectEnd":0,"redirectStart":0,"requestStart":249.29999923706055,"responseEnd":465.5999994277954,"responseStart":465.5999994277954,"secureConnectionStart":249.29999923706055},{"duration":273.29999923706055,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":249.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":249.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":522.7999992370605,"responseStart":0,"secureConnectionStart":0},{"duration":273.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/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":249.69999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":249.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":523,"responseStart":0,"secureConnectionStart":0},{"duration":216.39999961853027,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":249.69999980926514,"connectEnd":249.69999980926514,"connectStart":249.69999980926514,"domainLookupEnd":249.69999980926514,"domainLookupStart":249.69999980926514,"fetchStart":249.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":249.69999980926514,"responseEnd":466.0999994277954,"responseStart":466.0999994277954,"secureConnectionStart":249.69999980926514},{"duration":216.5999994277954,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/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":250,"connectEnd":250,"connectStart":250,"domainLookupEnd":250,"domainLookupStart":250,"fetchStart":250,"redirectEnd":0,"redirectStart":0,"requestStart":250,"responseEnd":466.5999994277954,"responseStart":466.5999994277954,"secureConnectionStart":250},{"duration":413.69999980926514,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":251,"connectEnd":251,"connectStart":251,"domainLookupEnd":251,"domainLookupStart":251,"fetchStart":251,"redirectEnd":0,"redirectStart":0,"requestStart":251,"responseEnd":664.6999998092651,"responseStart":664.6999998092651,"secureConnectionStart":251},{"duration":758.1999998092651,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":251,"connectEnd":251,"connectStart":251,"domainLookupEnd":251,"domainLookupStart":251,"fetchStart":251,"redirectEnd":0,"redirectStart":0,"requestStart":251,"responseEnd":1009.1999998092651,"responseStart":1009.1999998092651,"secureConnectionStart":251},{"duration":130,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":535.0999994277954,"connectEnd":535.0999994277954,"connectStart":535.0999994277954,"domainLookupEnd":535.0999994277954,"domainLookupStart":535.0999994277954,"fetchStart":535.0999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":535.0999994277954,"responseEnd":665.0999994277954,"responseStart":665.0999994277954,"secureConnectionStart":535.0999994277954},{"duration":231.60000038146973,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bv2/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":792.5999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":792.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1024.1999998092651,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":72,"responseStart":242,"responseEnd":245,"domLoading":245,"domInteractive":1035,"domContentLoadedEventStart":1035,"domContentLoadedEventEnd":1084,"domComplete":1754,"loadEventStart":1754,"loadEventEnd":1754,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1010.8999996185303},{"name":"bigPipe.sidebar-id.end","time":1011.6999998092651},{"name":"bigPipe.activity-panel-pipe-id.start","time":1011.8999996185303},{"name":"bigPipe.activity-panel-pipe-id.end","time":1013.8999996185303},{"name":"activityTabFullyLoaded","time":1102.3999996185303}],"measures":[],"correlationId":"3119bbb99ae08b","effectiveType":"4g","downlink":9.9,"rtt":0,"serverDuration":107,"dbReadsTimeInMs":15,"dbConnsTimeInMs":22,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}