Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

gdb:When the database is mariaDB and Link = "mariadb:", many more queries are generated. #4192

Open
35598253 opened this issue Mar 12, 2025 · 1 comment
Labels

Comments

@35598253
Copy link

Go version

go 1.24.1

GoFrame version

2.8.3

Can this bug be reproduced with the latest release?

Option Yes

What did you do?

[database]
link ="maraidb:account:password@tcp(ip:port)/database "

What did you see happen?

[DEBU]
SELECT c.COLUMN_NAME AS 'Field', ( CASE WHEN ch.CHECK_CLAUSE LIKE 'json_valid%' THEN 'json' ELSE c.COLUMN_TYPE END ) AS 'Type',...

There are many such queries in the log, and the query time is more than 30ms.

What did you expect to see?

[database]
link ="mysql:account:password@tcp(ip:port)/database "

Change to mysql and it will work fine

@35598253 35598253 added the bug It is confirmed a bug, but don't worry, we'll handle it. label Mar 12, 2025
@35598253 35598253 changed the title gdb: gdb:When the database is mariaDB and Link = "mariadb:", many more queries are generated. Mar 12, 2025
@gqcn
Copy link
Member

gqcn commented Mar 14, 2025

@35598253 hello, the SELECT c.COLUMN_NAME AS 'Field', ... query is used to query table fields from certain table in mariadb,and it is query once for a table and caches the result in memory. The table fields are used for fields filter operations.

@gqcn gqcn added question and removed bug It is confirmed a bug, but don't worry, we'll handle it. labels Mar 14, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants