这是表结构,是一个 target to source 的结构,现在需要根据 targetId查询所有上游任务id
WITH RECURSIVE results AS
(
SELECT
tgt_job_id,
src_job_id
FROM gojob_ac3_job_rela
WHERE tgt_job_id = 400684823229894656
UNION ALL
SELECT
origin.tgt_job_id,
origin.src_job_id
FROM results
JOIN gojob_ac3_job_rela origin
ON results.src_job_id = origin.tgt_job_id
)
SELECT
tgt_job_id,
src_job_id
FROM results;