search

zzzprojects / sqlfiddle

http://sqlfiddle.com
MIT License
275 stars 52 forks source link

Running malformed SELECTs throws bad error message #20

Closed biziclop closed 12 years ago

biziclop commented 12 years ago

Writing a SELECT with an error (typo, etc) throws an inappropriate error message, instead of the concrete error it shows the following error:

"DDL and DML statements are not allowed in the query panel for MySQL; only SELECT statements are allowed. Put DDL and DML in the schema panel."

It does the same thing with commented out selects, like /* SELECT * FROM xxx; */

jakefeasel commented 12 years ago

This should be fixed now, at least for error reporting:

http://sqlfiddle.com/#!2/a2581/894

Comments should also work, so long as they are not part of an isolated query batch. See here:

http://sqlfiddle.com/#!2/a2581/1243

vs here:

http://sqlfiddle.com/#!2/a2581/1244