Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
10.11, 11.0(EOL), 11.1(EOL), 11.2(EOL)
-
None
Description
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.
Attachments
Issue Links
- is caused by
-
MDEV-29959 UUID Sorting
- Closed
- relates to
-
MDEV-32188 make TIMESTAMP use whole 32-bit unsigned range
- Closed
-
MDEV-4958 Adding datatype UUID
- Closed