MySQL Bugs: #23511: Admin Feature: Need to Be Able to Disable SET SQL_BIG

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

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

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.

Thank you for a reasonable feature request.