[GitHub] [shardingsphere] zhangwangren removed a comment on issue #13067: normal table and sharding table can't join the broadcast table at the same time

Sun, 17 Oct 2021 23:32:05 -0700 


zhangwangren removed a comment on issue #13067:
URL: 
https://github.com/apache/shardingsphere/issues/13067#issuecomment-945407386


   Actual SQL: ds0 ::: SELECT
       rwd.id,
       rwd.STCD,
       sbi.STNM,
       rwd.TM,
       rwd.RZ,
       rwd.INQ,
       rwd.W,
       rwd.BLRZ,
       rwd.OTQ,
       rwd.RWCHRCD,
       rwd.RWPTN,
       rwd.INQDR,
       rwd.MSQMT,
       rwd.ADDVCD
       FROM 
org.apache.shardingsphere.sharding.rewrite.token.pojo.TableToken@138e4187 rwd
       LEFT JOIN 
org.apache.shardingsphere.sharding.rewrite.token.pojo.TableToken@33c5a40e sbi 
ON sbi.STCD = rwd.STCD
       WHERE 1=1
         AND rwd.STCD = ?  
        
           AND rwd.TM >= ? AND rwd.TM < ?  
        
       AND rwd.id > ? LIMIT ? ::: [81120905, 2021-09-26 00:00:00.0, 2021-09-26 
23:55:00.0, 0, 10]


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to