[adminer-tracker] [ adminer-Bugs and Features-3535401 ] EXPLAIN could interpred user defined variables in statement

[SourceForge.net <no...@so...>]

Bugs and Features item #3535401, was opened at 2012-06-15 02:49
Message generated for change (Comment added) made by jakubvrana
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3535401&group_id=264133

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: MySQL
Group: 3.3.4
>Status: Closed
>Resolution: Wont Fix
Priority: 5
Private: No
Submitted By: Petr Burian (burianp)
Assigned to: Jakub Vrána (jakubvrana)
Summary: EXPLAIN could interpred user defined variables in statement

Initial Comment:
A SQL statement is not explainable if there is a user defined variable used in the statement. It should be easy to convert user defined variables to constants if explain is needed.



----------------------------------------------------------------------

>Comment By: Jakub Vrána (jakubvrana)
Date: 2012-06-29 10:44

Message:
The reason for this is that EXPLAIN is executed in a separate connection to
not affect queries like "SELECT 1; SELECT FOUND_ROWS();".

I'm not sure about the right fix, replacing variables by constants may give
wrong results.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=3535401&group_id=264133