MDEV-29959 has changed UUID storage format in 10.11.5. The server auto-detects the correct UUID storage format automatically based on the version of the server that has created the table, so upgrades work seamlessly.
But REPAIR TABLE (and CHECK TABLE ?) updates the server version in the frm without rewriting the data, that is, it creates a new frm for old UUIDs. After that MariaDB can no longer read UUIDs correctly.
The fix could be to make the server aware of the UUID format change. Some type handler method used in ha_check_for_upgrade() or likely in check_old_types() that tells the server to rebuild the table. Ideally it could do VARCHAR and DECIMAL (and timestamps in MDEV-32188) upgrade checks too.
@@ -16,6 +16,7 @@ let $datadir= `select @@datadir`;
select * from t2 order by b;
select * from t2 order by a;
show create table t2;
+repair table t2;
explain select * from t1 left join t2 on (t1.a=t2.a);
--sorted_result
Sergei Golubchik
added a comment - Test case:
--- a/plugin/type_uuid/mysql-test/type_uuid/order.test
+++ b/plugin/type_uuid/mysql-test/type_uuid/order.test
@@ -16,6 +16,7 @@ let $datadir= `select @@datadir`;
select * from t2 order by b;
select * from t2 order by a;
show create table t2;
+repair table t2;
explain select * from t1 left join t2 on (t1.a=t2.a);
--sorted_result
Alexander Barkov
added a comment - This MTR test demonstrates the problem:
source include/have_sequence.inc;
let $datadir= ` select @@datadir`;
--copy_file $MTR_SUITE_DIR/std_data/mdev-29959.frm $datadir/test/t2.frm
--copy_file $MTR_SUITE_DIR/std_data/mdev-29959.MYI $datadir/test/t2.MYI
--copy_file $MTR_SUITE_DIR/std_data/mdev-29959.MYD $datadir/test/t2.MYD
select * from t2 order by b limit 3;
select * from t2 order by b desc limit 3;
repair table t2;
select * from t2 order by b limit 3;
select * from t2 order by b desc limit 3;
drop table t2;
select * from t2 order by b limit 3;
a b
00001234-5566-0777-0888-99aabbccddee 0
10101234-5566-0777-8888-99aabbccddee 1
00201234-5566-0777-c888-99aabbccddee 2
select * from t2 order by b desc limit 3;
a b
16301234-5566-f777-e888-99aabbccddee 63
06201234-5566-f777-c888-99aabbccddee 62
16101234-5566-f777-8888-99aabbccddee 61
repair table t2;
Table Op Msg_type Msg_text
test.t2 repair status OK
select * from t2 order by b limit 3;
a b
99aabbcc-ddee-0888-0777-556600001234 0
10101234-5566-0777-8888-99aabbccddee 1
00201234-5566-0777-c888-99aabbccddee 2
select * from t2 order by b desc limit 3;
a b
99aabbcc-ddee-e888-f777-556616301234 63
99aabbcc-ddee-c888-f777-556606201234 62
99aabbcc-ddee-8888-f777-556616101234 61
drop table t2;
The data after REPAIR is broken.
MDEV-29959 has changed UUID storage format in 10.11.3. The server auto-detects the correct UUID storage format automatically based on the version of the server that has created the table, so upgrades work seamlessly.
But {{REPAIR TABLE}} (and {{CHECK TABLE}} ?) updates the server version in the frm without rewriting the data, that is, it creates a *new* frm for *old* UUIDs. After that MariaDB can no longer read UUIDs correctly.
The fix could be to make the server aware of the UUID format change. Some type handler method used in {{ha_check_for_upgrade()}} or likely in {{check_old_types()}} that tells the server to rebuild the table. Ideally it could do VARCHAR and DECIMAL (and timestamps in MDEV-32188) upgrade checks too.
MDEV-29959 has changed UUID storage format in 10.11.5. The server auto-detects the correct UUID storage format automatically based on the version of the server that has created the table, so upgrades work seamlessly.
But {{REPAIR TABLE}} (and {{CHECK TABLE}} ?) updates the server version in the frm without rewriting the data, that is, it creates a *new* frm for *old* UUIDs. After that MariaDB can no longer read UUIDs correctly.
The fix could be to make the server aware of the UUID format change. Some type handler method used in {{ha_check_for_upgrade()}} or likely in {{check_old_types()}} that tells the server to rebuild the table. Ideally it could do VARCHAR and DECIMAL (and timestamps in MDEV-32188) upgrade checks too.
Alexander Barkov
added a comment - serg , please review a patch:
https://github.com/MariaDB/server/commit/f22662c36b14ce0fb4c7343b1950fd34a29a99f6
Thanks.
I've just experienced a very weird error in production, and don't know how we ended up in this state.
We noticed our rowbased replication stopped, and reported it couldn't update a row, because the row didn't exist on that mariadb instance, which it 100% do :smile:
It looks like our primary key of the type UUID has ended up in some very weird state.
Do you guys think my issues are related to this issue?
MariaDB [game-configuration]> SELECT * FROM providers;
Mads Jon Nielsen
added a comment - - edited I've just experienced a very weird error in production, and don't know how we ended up in this state.
We noticed our rowbased replication stopped, and reported it couldn't update a row, because the row didn't exist on that mariadb instance, which it 100% do :smile:
It looks like our primary key of the type UUID has ended up in some very weird state.
Do you guys think my issues are related to this issue?
MariaDB [game-configuration]> SELECT * FROM providers;
+--------------------------------------+----------------------------+----------------------------+-----------+-----------+-----------+
| id | created_at | updated_at | name | slug | is_active |
+--------------------------------------+----------------------------+----------------------------+-----------+-----------+-----------+
| 1ee24792-8647-6f3e-8061-0242ac12006b | 2023-07-17 08:08:48.240570 | 2023-07-17 08:08:48.240570 | <masked> | <masked> | 1 |
| 1ee24792-8699-6424-b01e-0242ac12006b | 2023-07-17 08:08:48.271552 | 2023-07-17 08:08:48.271552 | <masked> | <masked> | 1 |
| 1ee24792-86be-6418-91c8-0242ac12006b | 2023-07-17 08:08:48.286671 | 2023-07-17 11:10:12.266117 | <masked> | <masked> | 1 |
+--------------------------------------+----------------------------+----------------------------+-----------+-----------+-----------+
3 rows in set (0.003 sec)
MariaDB [game-configuration]> SELECT * FROM providers WHERE id = '1ee24792-86be-6418-91c8-0242ac12006b';
Empty set (0.000 sec)
MariaDB [game-configuration]> CHECK TABLE providers EXTENDED;
+------------------------------+-------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+------------------------------+-------+----------+----------+
| game-configuration.providers | check | status | OK |
+------------------------------+-------+----------+----------+
1 row in set (0.000 sec)
MariaDB [game-configuration]> ALTER TABLE providers CHANGE COLUMN id id CHAR(36);
Query OK, 3 rows affected (0.012 sec)
Records: 3 Duplicates: 0 Warnings: 0
MariaDB [game-configuration]> SELECT * FROM providers WHERE id = '1ee24792-86be-6418-91c8-0242ac12006b';
+--------------------------------------+----------------------------+----------------------------+----------+----------+-----------+
| id | created_at | updated_at | name | slug | is_active |
+--------------------------------------+----------------------------+----------------------------+----------+----------+-----------+
| 1ee24792-86be-6418-91c8-0242ac12006b | 2023-07-17 08:08:48.286671 | 2023-07-17 11:10:12.266117 | <masked> | <masked> | 1 |
+--------------------------------------+----------------------------+----------------------------+----------+----------+-----------+
1 row in set (0.000 sec)
MariaDB [game-configuration]> ALTER TABLE providers CHANGE COLUMN id id UUID;
Query OK, 3 rows affected (0.011 sec)
Records: 3 Duplicates: 0 Warnings: 0
MariaDB [game-configuration]> SELECT * FROM providers WHERE id = '1ee24792-86be-6418-91c8-0242ac12006b';
+--------------------------------------+----------------------------+----------------------------+----------+----------+-----------+
| id | created_at | updated_at | name | slug | is_active |
+--------------------------------------+----------------------------+----------------------------+----------+----------+-----------+
| 1ee24792-86be-6418-91c8-0242ac12006b | 2023-07-17 08:08:48.286671 | 2023-07-17 11:10:12.266117 | <masked> | <masked> | 1 |
+--------------------------------------+----------------------------+----------------------------+----------+----------+-----------+
1 row in set (0.000 sec)
People
Alexander Barkov
Sergei Golubchik
Votes:
0Vote for this issue
Watchers:
4Start watching this issue
Dates
Created:
Updated:
Resolved:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":940.7999997138977,"ttfb":327.2999997138977,"pageVisibility":"visible","entityId":127866,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"84b9a2b0-bb62-4f78-8a61-3ae7c1c07e98","navigationType":0,"readyForUser":1015.5999999046326,"redirectCount":0,"resourceLoadedEnd":1028.6999998092651,"resourceLoadedStart":333.19999980926514,"resourceTiming":[{"duration":34,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":333.19999980926514,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":333.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":367.19999980926514,"responseStart":0,"secureConnectionStart":0},{"duration":34.10000038146973,"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":333.3999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":333.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":367.5,"responseStart":0,"secureConnectionStart":0},{"duration":92,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":333.59999990463257,"connectEnd":333.59999990463257,"connectStart":333.59999990463257,"domainLookupEnd":333.59999990463257,"domainLookupStart":333.59999990463257,"fetchStart":333.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":333.59999990463257,"responseEnd":425.59999990463257,"responseStart":425.59999990463257,"secureConnectionStart":333.59999990463257},{"duration":152,"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":333.8999996185303,"connectEnd":333.8999996185303,"connectStart":333.8999996185303,"domainLookupEnd":333.8999996185303,"domainLookupStart":333.8999996185303,"fetchStart":333.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":333.8999996185303,"responseEnd":485.8999996185303,"responseStart":485.8999996185303,"secureConnectionStart":333.8999996185303},{"duration":155.7999997138977,"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":334,"connectEnd":334,"connectStart":334,"domainLookupEnd":334,"domainLookupStart":334,"fetchStart":334,"redirectEnd":0,"redirectStart":0,"requestStart":334,"responseEnd":489.7999997138977,"responseStart":489.7999997138977,"secureConnectionStart":334},{"duration":156.59999990463257,"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":334.2999997138977,"connectEnd":334.2999997138977,"connectStart":334.2999997138977,"domainLookupEnd":334.2999997138977,"domainLookupStart":334.2999997138977,"fetchStart":334.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":334.2999997138977,"responseEnd":490.8999996185303,"responseStart":490.8999996185303,"secureConnectionStart":334.2999997138977},{"duration":157.5,"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":334.3999996185303,"connectEnd":334.3999996185303,"connectStart":334.3999996185303,"domainLookupEnd":334.3999996185303,"domainLookupStart":334.3999996185303,"fetchStart":334.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":334.3999996185303,"responseEnd":491.8999996185303,"responseStart":491.8999996185303,"secureConnectionStart":334.3999996185303},{"duration":235,"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":334.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":334.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":569.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":158.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":334.69999980926514,"connectEnd":334.69999980926514,"connectStart":334.69999980926514,"domainLookupEnd":334.69999980926514,"domainLookupStart":334.69999980926514,"fetchStart":334.69999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":334.69999980926514,"responseEnd":493.09999990463257,"responseStart":493.09999990463257,"secureConnectionStart":334.69999980926514},{"duration":234.80000019073486,"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":334.8999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":334.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":569.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":159.2999997138977,"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":335.09999990463257,"connectEnd":335.09999990463257,"connectStart":335.09999990463257,"domainLookupEnd":335.09999990463257,"domainLookupStart":335.09999990463257,"fetchStart":335.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":335.09999990463257,"responseEnd":494.3999996185303,"responseStart":494.3999996185303,"secureConnectionStart":335.09999990463257},{"duration":447.09999990463257,"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":341.19999980926514,"connectEnd":341.19999980926514,"connectStart":341.19999980926514,"domainLookupEnd":341.19999980926514,"domainLookupStart":341.19999980926514,"fetchStart":341.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":341.19999980926514,"responseEnd":788.2999997138977,"responseStart":788.2999997138977,"secureConnectionStart":341.19999980926514},{"duration":526.2999997138977,"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":351.5,"connectEnd":351.5,"connectStart":351.5,"domainLookupEnd":351.5,"domainLookupStart":351.5,"fetchStart":351.5,"redirectEnd":0,"redirectStart":0,"requestStart":351.5,"responseEnd":877.7999997138977,"responseStart":877.7999997138977,"secureConnectionStart":351.5},{"duration":207.69999980926514,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":581.1999998092651,"connectEnd":581.1999998092651,"connectStart":581.1999998092651,"domainLookupEnd":581.1999998092651,"domainLookupStart":581.1999998092651,"fetchStart":581.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":581.1999998092651,"responseEnd":788.8999996185303,"responseStart":788.8999996185303,"secureConnectionStart":581.1999998092651},{"duration":53.69999980926514,"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":842.0999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":842.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":895.7999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":53.30000019073486,"initiatorType":"link","name":"https://jira.mariadb.org/s/50bc9be5bfead1a25e72c1a9338c94f6-CDN/lu2bv2/820016/12ta74/e108c7645258ccb43280ed3404e3e949/_/download/contextbatch/css/com.atlassian.jira.plugins.jira-development-integration-plugin:0,-_super,-jira.view.issue,-jira.global,-jira.general,-jira.browse.project,-project.issue.navigator,-atl.general/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":842.6999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":842.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":896,"responseStart":0,"secureConnectionStart":0},{"duration":169.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":843.5999999046326,"connectEnd":843.5999999046326,"connectStart":843.5999999046326,"domainLookupEnd":843.5999999046326,"domainLookupStart":843.5999999046326,"fetchStart":843.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":843.5999999046326,"responseEnd":1013.5,"responseStart":1013.5,"secureConnectionStart":843.5999999046326},{"duration":183.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/53a43b6764f587426c7bb9a150184c00-CDN/lu2bv2/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/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.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":844,"connectEnd":844,"connectStart":844,"domainLookupEnd":844,"domainLookupStart":844,"fetchStart":844,"redirectEnd":0,"redirectStart":0,"requestStart":844,"responseEnd":1027.0999999046326,"responseStart":1027.0999999046326,"secureConnectionStart":844},{"duration":184.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/630dda803a823fdd5771c4338338e018-CDN/lu2bv2/820016/12ta74/e108c7645258ccb43280ed3404e3e949/_/download/contextbatch/js/com.atlassian.jira.plugins.jira-development-integration-plugin:0,-_super,-jira.view.issue,-jira.global,-jira.general,-jira.browse.project,-project.issue.navigator,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":844.2999997138977,"connectEnd":844.2999997138977,"connectStart":844.2999997138977,"domainLookupEnd":844.2999997138977,"domainLookupStart":844.2999997138977,"fetchStart":844.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":844.2999997138977,"responseEnd":1028.6999998092651,"responseStart":1028.6999998092651,"secureConnectionStart":844.2999997138977},{"duration":114.2999997138977,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":934,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":934,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1048.2999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":132.60000038146973,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":955.3999996185303,"connectEnd":955.3999996185303,"connectStart":955.3999996185303,"domainLookupEnd":955.3999996185303,"domainLookupStart":955.3999996185303,"fetchStart":955.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":955.3999996185303,"responseEnd":1088,"responseStart":1088,"secureConnectionStart":955.3999996185303}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":118,"responseStart":327,"responseEnd":351,"domLoading":330,"domInteractive":1114,"domContentLoadedEventStart":1114,"domContentLoadedEventEnd":1171,"domComplete":1336,"loadEventStart":1336,"loadEventEnd":1337,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1052.2999997138977},{"name":"bigPipe.sidebar-id.end","time":1053.0999999046326},{"name":"bigPipe.activity-panel-pipe-id.start","time":1053.2999997138977},{"name":"bigPipe.activity-panel-pipe-id.end","time":1059.7999997138977},{"name":"activityTabFullyLoaded","time":1195.8999996185303}],"measures":[],"correlationId":"27815fa60f178b","effectiveType":"4g","downlink":9.9,"rtt":0,"serverDuration":138,"dbReadsTimeInMs":21,"dbConnsTimeInMs":29,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Test case:
--- a/plugin/type_uuid/mysql-test/type_uuid/order.test
+++ b/plugin/type_uuid/mysql-test/type_uuid/order.test
@@ -16,6 +16,7 @@ let $datadir= `select @@datadir`;
select * from t2 order by b;
select * from t2 order by a;
show create table t2;
+repair table t2;
explain select * from t1 left join t2 on (t1.a=t2.a);