Bug #23511 Admin Feature: Need to Be Able to Disable SET SQL_BIG_SELECTS
Submitted: 20 Oct 2006 17:44 Modified: 22 Oct 2006 12:39
Reporter: Bill Adams Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: General Severity:S4 (Feature request)
Version:5.0 OS:Linux (linux)
Assigned to: CPU Architecture:Any
Tags: admin, feature request
Triage: Triaged: D5 (Feature request)

[20 Oct 2006 17:44] Bill Adams
Description:
It would be just dandy if there was a way to disable (perhaps by user) the use of SET SQL_BIG_SELECTS=1. I use MySQL as a larg engineering database and need to be able to stop the non SQL savvy from getting around max_join_size when they write bad queries.

Along the same lines, a max_query_time variable (global/user) would be nice.

How to repeat:
N/A

Suggested fix:
Either a server configuration variable and/or another column in the user table.
[22 Oct 2006 12:39] Valeriy Kravchuk
Thank you for a reasonable feature request.