mindsdb / mindsdb

The platform for building AI from enterprise data
https://mindsdb.com
Other
26.71k stars 4.87k forks source link

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

Open divyakhatiyan opened 1 week ago

divyakhatiyan commented 1 week ago

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.

https://github.com/user-attachments/assets/d752f7fe-875b-41fe-b00d-bd95395706ae

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 commented 1 week ago

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

ZoranPandovski commented 1 week ago

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?