Bug #38354 sql_select_limit documented incorrectly
Submitted: 24 Jul 2008 20:54 Modified: 24 Jul 2008 21:01
Reporter: Matthew Boehm Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.1.26 OS:Linux (RHEL 5.1)
Assigned to: CPU Architecture:Any
Tags: documentation

[24 Jul 2008 20:54] Matthew Boehm
Description:
This page: http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html
states that sql_select_limit can be included in the my.cnf options file.

However, when one does include it, server refuses to start:

080724 15:29:54 [ERROR] /usr/sbin/mysqld: unknown variable 'sql_select_limit=134217728'

How to repeat:
In your /etc/my.cnf, under the [mysqld] section, add the following:

sql_select_limit = <any non-zero, positive, integer>

attempt to start the server.

Suggested fix:
either correct the documentation to explain that it is not in fact a system startup option, or correct the mysqld code so that it does recognize it as startup option.
[24 Jul 2008 21:00] Paul DuBois
The documentation is incorrect.
[24 Jul 2008 21:01] Paul DuBois
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.