[Bug]: Multiple chromadb handler commands not executing in mindsdb editor, throwing parsing error

[divyakhatiyan]

Short description of current behavior

When we are executing multiple commands for chromadb handler in the mindsdb editor. It is throwing parsing error.

Command Executed:

Drop Database chroma_test

CREATE DATABASE chroma_test
WITH ENGINE = "chromadb",
PARAMETERS = {
"host": "localhost",
"port": "8000"
}

Error:
SQL statement cannot be parsed by mindsdb_sql - Drop Database chroma_test

CREATE DATABASE chroma_test
WITH ENGINE = "chromadb",
PARAMETERS = {
"host": "localhost",
"port": "8000"
}: Syntax error, unknown input:

Drop Database chroma_test
CREATE DATABASE chroma_test
-----^^^^^^

Video or screenshots

Mo.

ChromaDb_Parsing_multiplecommands.mp4

re details in the attached video

Expected behavior

It should parse the commands properly.

How to reproduce the error

Execute these commands in mindsdb editor

Drop Database chroma_test

CREATE DATABASE chroma_test
WITH ENGINE = "chromadb",
PARAMETERS = {
"host": "localhost",
"port": "8000"
}

Anything else?

No response

[ritwickrajmakhal]

I think this problem will occur for every handler. Currently Mindsdb Studio editor doesn't support executing multiple queries.

[ZoranPandovski]

Thanks for reporting this @divyakhatiyan, currently you can only execute one command in the editor. @zac-mindsDB Maybe something we can consider supporting in the future?