为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:V3.0.0 docker 容器部署
- 【问题描述】:
通过查询窗口执行select语句报错:
SELECT
bep.employee_code,
ccai.product_one_type,
ccai.customer_id,
ccai.contract_code,
ccai.achievement_date
FROM
(
SELECT
FROM
dwd.dwd_trd_contract_info_tidb ccai
WHERE
(
ccai.achievement_date BETWEEN ‘2018-09-01’
AND ‘2018-09-30’
)
) ccai
LEFT JOIN dwd.dwd_customer_belong_employee bep ON ccai.CUSTOMER_ID = bep.customer_id
AND ccai.achievement_date >= bep.start_dt
AND ccai.achievement_date < bep.end_dt
LEFT JOIN dwd.dwd_admin_belong dabel ON dabel.employee_code = bep.employee_code
AND ccai.achievement_date >= dabel.start_dt
AND ccai.achievement_date < dabel.end_dt
LEFT JOIN dwd.dwd_org_info org ON org.org_code = dabel.org_code
AND ccai.achievement_date >= org.start_dt
AND ccai.achievement_date < org.end_dt
报错信息:
1105 - runtime error: slice bounds out of range [:10245] with capacity 10240, Time: 0.467000s