[dolphinscheduler] branch dev updated: [Enhancement-8006] Improve the performance of SQL query (#8007)

[ke...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

kerwin pushed a commit to branch dev
in repository https://gitbox.apache.org/repos/asf/dolphinscheduler.git


The following commit(s) were added to refs/heads/dev by this push:
     new 5e975da  [Enhancement-8006] Improve the performance of SQL query (#8007)
5e975da is described below

commit 5e975dad3400c569a59714de660315b99f48bf98
Author: springmonster <ch...@163.com>
AuthorDate: Fri Jan 14 13:53:31 2022 +0800

    [Enhancement-8006] Improve the performance of SQL query (#8007)
    
    Co-authored-by: kuanghc1 <ku...@lenovo.com>
---
 .../org/apache/dolphinscheduler/dao/mapper/ProjectMapper.xml          | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProjectMapper.xml b/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProjectMapper.xml
index e9c0aae..dcbb659 100644
--- a/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProjectMapper.xml
+++ b/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/ProjectMapper.xml
@@ -160,6 +160,8 @@
     </select>
 
     <select id="queryAllProject" resultType="org.apache.dolphinscheduler.dao.entity.Project">
-        select * from t_ds_project
+        select
+        <include refid="baseSql"/>
+        from t_ds_project
     </select>
 </mapper>