Bug #85495 [ERROR] unknown variable 'sql_select_limit‘

• Submitted: 17 Mar 2017 6:08
• Modified: 17 Mar 2017 9:35
• Reporter: kfpanda kf
• Status: Duplicate
• Category: MySQL Server: Options
• Severity: S3 (Non-critical)
• Version: 5.7.17
• OS: Any
• CPU Architecture: Any

[17 Mar 2017 6:08] kfpanda kf

Description:
Hello,

first,i add "sql_select_limit=10" into my.cnf(section: mysqld)

then,,i restart mysql, error occurs in error log:
2017-03-17T06:04:32.833580Z 0 [ERROR] unknown variable 'sql_select_limit=10'
2017-03-17T06:04:32.833599Z 0 [ERROR] Aborting

How to repeat:
Hello,

first,i add "sql_select_limit=10" into my.cnf(section: mysqld)

then,,i restart mysql, error occurs in error log:
2017-03-17T06:04:32.833580Z 0 [ERROR] unknown variable 'sql_select_limit=10'
2017-03-17T06:04:32.833599Z 0 [ERROR] Aborting

Suggested fix:
I hope the variable sql_select_limit can be maintained in my.cnf.

[17 Mar 2017 7:02] MySQL Verification Team

Hello kfpanda kf,

Thank you for the report.
You can refer the list available to confirm which option/variables are available in conf, command line or  server system variable.

https://dev.mysql.com/doc/mysqld-version-reference/en/mysqld-version-reference-optvar.html

Above listing confirms that "sql_select_limit" is a server system variable and can be set using SET... statement.

Thanks,
Umesh

[17 Mar 2017 9:35] MySQL Verification Team

Marking this as duplicate of Bug #85501, just to aggregate them all (if they're all similar) into a single FR.