Kate SQL plugin returns text "-1 line changed" (or similar, transleted from russian) in text output tab and nothing in data tab, when executing query like "explain select ...". Database is mysql. Reproducible: Always Steps to Reproduce: 1. Execute query "explain select * from any_table" 2. See both query result tabs. Actual Results: Message "28.05.13 11:44: Затронута -1 строка" in text output tab. Nothing in data output tab. Expected Results: Table, describing query plan, in data output tab.
Hi Dmitriy, thanks for your bug report. I'll investigate on this issue as soon as possibile. i admit i never tried to execute the EXPLAIN statement, i'll search for a way to handle this kind of output
(In reply to comment #1) This is MySQL-specific issue. Also, 'DESCRIBE SELECT ...' do same thing. PostgreSQL/Oracle use 'PLAN SELECT ...' syntax, but I don't know, how does it return results.
One more problematic query: 'SHOW CREATE TABLE ...'
It seems that Qt doesn't know how to handle this statement, it's recognized as a non-select, then simply execute it but discarding results. I have to look deeper into Qt code and its way to retrieve results from a query. About your last example there's a workaround: in schema browser, select your table --> right click --> Generate --> CREATE It will give you the sql-specific statement needed to create the selected table
I don't see anythyng other than select/insert/update/delete in context menu
If Qt doesn't know how to handle this, we can't improve easily for that. If that still is an issue with Qt 5, please report and bug there.