Description:
When pasting a query into Query Browser, it will not execute if the last line is indented. For example, the following query (as pasted into the query textbox):
"SELECT tbl.id FROM `some_table` AS tbl
GROUP BY tbl.id"
Results in the query being rejected with the following error:
"Unknown column 'tbl' in 'group statement' (#1054)"
Although "tbl" is clearly the table alias as opposed to a column.
The query will execute perfectly if indentation is removed from the last line, or an extra line is inserted after the last line. Appending a semicolon to the end of the query, or adjusting indentation of other lines makes no difference. You can even add the indentation back into the last line and it will still execute perfectly; it is only problematic if the indentation is originally included in the paste, it would appear. Indentation of intervening lines (for example JOIN or WHERE clauses that may be between the first and last line) also appears to make no difference.
How to repeat:
*Paste* a query of similar format to the above (it need not be a GROUP BY clause on the last line - JOIN, WHERE etc all appear to have the same problem) into MySQL Query Browser.
The query will fail with the above error, although if the indentation of the last line is removed (and even subsequently restored by typing back in) the query should execute as desired.
Suggested fix:
This would appear to be an issue with how Query Browser is interpreting the {TAB} characters at the start of the line. The seemingly arbitrary nature of the error and the fact that Query Browser then mistakes table aliases for column names would imply also that this is a parsing issue.
Description: When pasting a query into Query Browser, it will not execute if the last line is indented. For example, the following query (as pasted into the query textbox): "SELECT tbl.id FROM `some_table` AS tbl GROUP BY tbl.id" Results in the query being rejected with the following error: "Unknown column 'tbl' in 'group statement' (#1054)" Although "tbl" is clearly the table alias as opposed to a column. The query will execute perfectly if indentation is removed from the last line, or an extra line is inserted after the last line. Appending a semicolon to the end of the query, or adjusting indentation of other lines makes no difference. You can even add the indentation back into the last line and it will still execute perfectly; it is only problematic if the indentation is originally included in the paste, it would appear. Indentation of intervening lines (for example JOIN or WHERE clauses that may be between the first and last line) also appears to make no difference. How to repeat: *Paste* a query of similar format to the above (it need not be a GROUP BY clause on the last line - JOIN, WHERE etc all appear to have the same problem) into MySQL Query Browser. The query will fail with the above error, although if the indentation of the last line is removed (and even subsequently restored by typing back in) the query should execute as desired. Suggested fix: This would appear to be an issue with how Query Browser is interpreting the {TAB} characters at the start of the line. The seemingly arbitrary nature of the error and the fact that Query Browser then mistakes table aliases for column names would imply also that this is a parsing issue.