[Bug] [Server] Catalog 接口响应错误

[AlexChen68]

Search before asking

• [X] I had searched in the issues and found no similar issues.

What happened

/catalog/page/table-with-detail 接口当 "name" 参数为空时会导致 mybatisplus 拼接 sql 错误； 查看源码发现是CatalogEntityInstanceServiceImpl 的 getCatalogEntityInstancePage 方法中的 queryWrapper 拼接 and 条件时未先判断参数为空

DataVines Version

1.0.0-SNAPSHOT

DataVines Config

无

Running Command

idea 源码启动

Error Exception

[ERROR] 2024-01-09 16:47:00.754 io.datavines.server.api.inteceptor.DataVinesExceptionHandler:[90] - Exception:
org.springframework.jdbc.BadSqlGrammarException: 
### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY id ASC) TOTAL' at line 3
### The error may exist in io/datavines/server/repository/mapper/CatalogEntityInstanceMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT COUNT(*) FROM (SELECT  id,uuid,datasource_id,type,fully_qualified_name,display_name,description,properties,owner,version,status,create_time,update_by,update_time  FROM dv_catalog_entity_instance     WHERE (uuid IN (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND status = ? AND ) ORDER BY id ASC) TOTAL
### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY id ASC) TOTAL' at line 3

Engine Type

local

Java Version

1.8

Screenshots

Are you willing to submit PR?

• [x] Yes I am willing to submit a PR!