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

zhongjiajie pushed a commit to branch 3.1.5-release
in repository https://gitbox.apache.org/repos/asf/dolphinscheduler.git


The following commit(s) were added to refs/heads/3.1.5-release by this push:
     new b547024baf fix: python gateway tenant code query
b547024baf is described below

commit b547024baf1f35691b8694651f798abcf30e1b6f
Author: Jay Chung <[email protected]>
AuthorDate: Mon Apr 3 17:39:30 2023 +0800

    fix: python gateway tenant code query
    
    part of related: #13042
---
 .../org/apache/dolphinscheduler/dao/mapper/UserMapper.xml      | 10 +++++++---
 1 file changed, 7 insertions(+), 3 deletions(-)

diff --git 
a/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/UserMapper.xml
 
b/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/UserMapper.xml
index 807a296974..41208b40ee 100644
--- 
a/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/UserMapper.xml
+++ 
b/dolphinscheduler-dao/src/main/resources/org/apache/dolphinscheduler/dao/mapper/UserMapper.xml
@@ -33,9 +33,13 @@
     </select>
     <select id="queryByUserNameAccurately" 
resultType="org.apache.dolphinscheduler.dao.entity.User">
         select
-        <include refid="baseSql"/>
-        from t_ds_user
-        where user_name=#{userName}
+        <include refid="baseSqlV2">
+            <property name="alias" value="u"/>
+        </include>
+        , t.tenant_code
+        from t_ds_user u
+        left join t_ds_tenant t on u.tenant_id = t.id
+        where u.user_name = #{userName}
     </select>
     <select id="queryUserByNamePassword" 
resultType="org.apache.dolphinscheduler.dao.entity.User">
         select

Reply via email to