I have turned on the mysql logging of slow queries + full joins. One of the logged queries produces this “extra” message using EXPLAIN: “Impossible WHERE noticed after reading const tables”
This is the query:
SELECT * FROM setup where season = 2007;
“season” is the primary key. The point of this query is to determine if the data row even exists.
So my problem is: I don’t want this query logged in the slow-query log. Yes, I realize that you could write a query that NEVER succeeds (e.g. “WHERE 0”) but in this case it could.
Is there anything I can do to prevent this particular type of query of being logged? A log file full of legitimate queries doesn’t really help that much.