search

antares-sql / antares

A modern, fast and productivity driven SQL client with a focus in UX
https://antares-sql.app
MIT License
1.87k stars 129 forks source link

Error: 'Unsupported SHOW type' is not supported on TiDB Serverless #744

Closed shehari007 closed 10 months ago

shehari007 commented 10 months ago

Describe the bug I was connecting serverless database using Antares SQL it worked fine for months now it says this error on connecting, "Error: 'Unsupported SHOW type' is not supported on TiDB Serverless", while on other SQL apps I tested it connects fine and i can view edit data as expected. please check this issue I've been using Antares for months now I love this app.

To Reproduce Steps to reproduce the behavior:

Connect Any serverless HTTPS database it shows error.

Application (please complete the following information):

Latest and Beta Both Window Releases

Environment (please complete the following information):

Fabio286 commented 10 months ago

It looks like some incompatible background query with TiDB. Can you tell me if, from another client, you can run the query SHOW GLOBAL VARIABLES LIKE '%sql_mode%'?

shehari007 commented 10 months ago

This is the output I get by running your query, I used For testing Heidi SQL, MySQL Workbench, DBeaver they all work fine only Antares showing error which before worked fine too.

ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Fabio286 commented 10 months ago

I will do some testing as soon as I figure out how to set up a test environment. To be honest, I didn't know of its existence (TiDB) until today.

shehari007 commented 10 months ago

Thanks! I just wanna mention If i click on Test Connection it says "Connection Made Successfully" but if i click Connect I get the error i explained before.

zhangyangyu commented 10 months ago

I am from TiDB Serverless. This issue is due to for TiDB Serverless with kernel version 7.1, SHOW FUNCTION STATUS returns an error. We've fixed it and will release it to production soon. @shehari007

Fabio286 commented 10 months ago

I am from TiDB Serverless. This issue is due to for TiDB Serverless with kernel version 7.1, SHOW FUNCTION STATUS returns an error. We've fixed it and will release it to production soon. @shehari007

Thank you for your clarification!

shehari007 commented 10 months ago

I am from TiDB Serverless. This issue is due to for TiDB Serverless with kernel version 7.1, SHOW FUNCTION STATUS returns an error. We've fixed it and will release it to production soon. @shehari007

Thank you for your clarification!

I am from TiDB Serverless. This issue is due to for TiDB Serverless with kernel version 7.1, SHOW FUNCTION STATUS returns an error. We've fixed it and will release it to production soon. @shehari007

Thank you from both sides my issue has been resolved and now I can connect fine using Antares SQL, I just tested and all good here now! Really appreciate the fix and acknowledgment of my issue.