RaigorJiang commented on issue #13851:
URL:
https://github.com/apache/shardingsphere/issues/13851#issuecomment-982250380
> example SELECT out_cmnt.cmnt_id cmnt_id, out_cmnt.cmnt_pid cmnt_pid,
out_cmnt.cmnt_gid cmnt_gid, out_cmnt.cmnt_mark cmnt_mark, out_cmnt.cmnt_label
cmnt_label, out_cmnt.cmnt_cont cmnt_cont, out_cmnt.cmnt_json cmnt_json,
out_cmnt.cmnt_data cmnt_data, out_cmnt.cmnt_num_pid cmnt_num_pid,
out_cmnt.cmnt_num_gid cmnt_num_gid, out_cmnt.for_uid for_uid, out_cmnt.user_id
user_id, out_cmnt.cmnt_ctime cmnt_ctime, out_cmnt.part_fkid part_fkid,
out_cmnt.vote_bind vote_bind, out_cmnt.vote_label vote_label, IF(vote_bind IS
NULL, 0, out_cmnt.vote_num) vote_num , vote_user_tab.user_id vote_uid FROM (
SELECT cmnt_tab., count(cmnt_tab.cmnt_id) vote_num, vote_bind_tab.bind_fkid
vote_bind, vote_bind_tab.vote_label vote_label FROM ( SELECT base_cmnt. FROM
part_cmnt base_cmnt WHERE base_cmnt.part_fkid = #{partFkid,jdbcType=BIGINT} AND
base_cmnt.cmnt_label = #{cmntLabel,jdbcType=VARCHAR} AND base_cmnt.cmnt_mark =
#{cmntMark,jdbcType=VARCHAR} AND base_cmnt.cmnt_score <=
#{cmntScore,jdbcType=INTEGER} AND
base_cmnt.cmnt_ctime >= #{cmntCtime,jdbcType=TIMESTAMP} AND base_cmnt.cmnt_del
= 0 AND base_cmnt.cmnt_pid = 0 AND base_cmnt.cmnt_pid != 0 AND
base_cmnt.cmnt_gid = #{cmntPid,jdbcType=BIGINT} ORDER BY base_cmnt.cmnt_id DESC
LIMIT 2000 ) cmnt_tab LEFT JOIN part_vote vote_bind_tab ON
vote_bind_tab.bind_fkid = cmnt_tab.cmnt_id AND vote_bind_tab.part_fkid =
#{partFkid,jdbcType=BIGINT} AND vote_bind_tab.vote_label =
#{voteLabel,jdbcType=VARCHAR} AND vote_bind_tab.vote_mark =
#{voteMark,jdbcType=VARCHAR} AND vote_bind_tab.vote_del = 0 GROUP BY
cmnt_tab.cmnt_id ) out_cmnt LEFT JOIN part_vote vote_user_tab ON
vote_user_tab.bind_fkid = out_cmnt.cmnt_id AND vote_user_tab.user_id =
#{userId,jdbcType=BIGINT} AND vote_user_tab.part_fkid =
#{partFkid,jdbcType=BIGINT} AND vote_user_tab.vote_label =
#{voteLabel,jdbcType=VARCHAR} AND vote_user_tab.vote_mark =
#{voteMark,jdbcType=VARCHAR} AND vote_user_tab.vote_del = 0 GROUP BY cmnt_id
>
> describe column part_fkid is sub table foreign key，but it doesn't work in
left sql
Thanks for your feedback, can you provide `Logic SQL`?
`Logic SQL` can be Obtained from the log, by setting `sql-show` to `true`.
Because such a mapper is not easy to read and verify.
--
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]
