Bug #84536 Generalize variable-length sort key code
Submitted: 17 Jan 2017 13:46 Modified: 26 Jan 2017 15:01
Reporter: Steinar Gunderson Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Optimizer Severity:S3 (Non-critical)
Version:8.0.1 OS:Any
Assigned to: CPU Architecture:Any

[17 Jan 2017 13:46] Steinar Gunderson
Currently, only JSON fields can be variable-length in sort keys, and a number of details about this format are hard-coded to JSON and encoded in the JSON sort keys function. We should make this more general, so that we can also sort e.g. VARCHAR fields without padding them to the maximum length. (This is especially important with utf8mb4 as default, where key lengths explode.)

How to repeat:

Suggested fix:
[26 Jan 2017 15:01] Paul DuBois
Posted by developer:
Fixed in 8.0.1.

Code cleanup. No changelog entry needed.