mtxr / vscode-sqltools

Database management for VSCode
https://vscode-sqltools.mteixeira.dev?utm_source=github&utm_medium=homepage-link
MIT License
1.52k stars 306 forks source link

MariaDB: `Cannot read properties of undefined (reading 'undefined')` returns for every query #1093

Closed sharpchen closed 1 year ago

sharpchen commented 1 year ago

Describe the bug I'm writing very simple queries, these queries are valid and I can get correct results using terminal. When using sqltools, it returns Cannot read properties of undefined (reading 'undefined') for every simple query.

Screenshots image image

Desktop (please complete the following information):

sharpchen commented 1 year ago

Found a solution: Run USE <database> first, then run the query, it works.

But really do I have to do this, or it's just a bug?

mtxr commented 1 year ago

do you have a database set on you settings.json file?

sharpchen commented 1 year ago

I have set a default database to connect. To be clear, this issue is about it cannot execute query together with use <database>. I'm not sure whether I have clearly expressed myself, feel free to comment if you don't understand me.

gjsjohnmurray commented 1 year ago

Duplicate of #1131