Bug #102328 Range of innodb_ft_sort_pll_degree error
Submitted: 21 Jan 8:58 Modified: 21 Jan 9:53
Reporter: libo jia Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: Options Severity:S3 (Non-critical)
Version:5.6, 5.7, 8.0, 5.7.33, 8.0.23 OS:Any
Assigned to: CPU Architecture:Any
Tags: innodb_ft_sort_pll_degree

[21 Jan 8:58] libo jia
In the document, range of innodb_ft_sort_pll_degree is 1 to 32.

I set parameter innodb_ft_sort_pll_degree in my.cnf to 25 or 11. after restart service, the value of innodb_ft_sort_pll_degree is 16 using 'show variables like `innodb_ft_sort_pll_degree `';

I tested other values and found that the value of innodb_ft_sort_pll_degree could only be set to 1,2,4,8,16 ,wheather in 5.6/5.7/8.0

How to repeat:
1. set the value of innodb_ft_sort_pll_degree to 25
2. restart the service
3. show variables like 'innodb_ft_sort_pll_degree '

Suggested fix:
The document should be consistent with the real value range
[21 Jan 9:53] MySQL Verification Team
Hello libo jia,

Thank you for the report and feedback.