EXPLAIN output is not provided

[ghost]

Consider the following snippet from the Python console:

import monetdbe
conn = monetdbe.connect(‘test’)
cur = conn.cursor()
res = cur.execute(‘explain select 1’)
tbl = res.fetchall()
print(tbl)
[]

Either an exception or the table is expected.

For the case ‘trace select 1’ I miss the header and end of function, but that is less of a problem

[gijzelaerr]

I can't do much about this now, the current monetdbe Jul2021 engine returns an error:

'ParseException:SQLparser:42000!syntax error, unexpected SQL_EXPLAIN in: "prepare explain"

[njnes]

Explain and prepare cannot be combined that way. Also an explain output need changes on the engine Niels

…

On 23 June 2021 14:30:33 CEST, Gijs Molenaar ***@***.***> wrote: I can't do much about this now, the current monetdbe Jul2021 engine returns an error: ``` 'ParseException:SQLparser:42000!syntax error, unexpected SQL_EXPLAIN in: "prepare explain" ``` -- You are receiving this because you were assigned. Reply to this email directly or view it on GitHub: #118 (comment)

[gijzelaerr]

ok then i don't know what to do with this issue for now, moving to 0.12 :)

[njnes]

First step is too have proper (table) output of explain (instead of the current directly streamed result).