Explain query not work in MySQL client

[francis-du]

What type of bug is this?

Crash

What subsystems are affected?

Standalone mode

What happened?

What operating system did you use?

MBP Intel CPU

Relevant log output and stack trace

No response

How can we reproduce the bug?

Run query in MySQL client:

explain select * from numbers;

[v0y4g3r]

MySQL protocol now only supports reading and writing data, more functionalities is under active developing. EXPLAIN will soon be supported.

[francis-du]

How to support Explain syntax for this? can i try it?

[v0y4g3r]

How to support Explain syntax for this? can i try it?

We'd appreciate any contribution, please reach us if you need any help!

As to implementing EXPLAIN statement in MySQL protocol, you need to first implement SQL parser for EXPLAIN keyword, and convert the statement to datafusion::logical_plan::plan::LogicalPlan::Explain in datafusion, execute the plan and then return to client.

[v0y4g3r]

Anyway if MySQL protocol handler receives any statement that is currently not supported, it should return an UnsupportedError instead of just panicking. We will fix this.

[francis-du]

How to support Explain syntax for this? can i try it?

We'd appreciate any contribution, please reach us if you need any help!

As to implementing EXPLAIN statement in MySQL protocol, you need to first implement SQL parser for EXPLAIN keyword, and convert the query following EXPLAIN to plans in datafusion, and serialize the plan to string and then return to client.

Thanks you, let me try. Can you assign this issue to me?

[v0y4g3r]

How to support Explain syntax for this? can i try it?

We'd appreciate any contribution, please reach us if you need any help!
As to implementing EXPLAIN statement in MySQL protocol, you need to first implement SQL parser for EXPLAIN keyword, and convert the query following EXPLAIN to plans in datafusion, and serialize the plan to string and then return to client.

Thanks you, let me try. Can you assign this issue to me?

If you need any help, please reach us thru our slack channel.

[francis-du]

Thanks for your help @v0y4g3r