shatteredsilicon / ssm-submodules

GNU Affero General Public License v3.0
0 stars 2 forks source link

EXPLAIN SELECT section of INSERT INTO ... SELECT ... statements #112

Closed gordan-bobic closed 1 year ago

gordan-bobic commented 1 year ago

INSERT statements can't have an EXPLAIN, but if the statement is INSERT INTO ... SELECT ... it would be really useful to have the EXPLAIN of just the SELECT section.

So strip out the INSERT ... part up to SELECT, and make QAN display the EXPLAIN of the SELECT part of the statement.