注册

SF_INJECT_HINT如何加长sql语句还是加部分就可以

技术咨询 2025/11/13 81 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:SF_INJECT_HINT(' ', 'ENABLE_HASH_JOIN(0)', 'test_INJECT', 'to list query2', TRUE, NULL);
长sql语句如何添加进去呢 例如这个语句如何添加进去 全部添加无法执行
SELECT count(1) AS "At"
FROM ( SELECT DISTINCT T0.cName AS name,

T0.contactName AS contactName,
T0.contactTel AS contactTel,
T0.cEnterpriseName AS enterpriseName,
T0.cPersonName AS personName,
T0.cOrgName AS orgName,
T0.transType AS transType,
T5.searchCode AS "merchantAppliedDetail!searchcode",
T5.cSpecialManagementDep AS "merchantAppliedDetail!specialManagementDep",
T6.id AS merchantApplyRangeId,
T6.orgId AS belongOrg,
T6.orgId AS "merchantAppliedDetail!belongMerchant",
T2.cMerchantOptions AS "merchantRole!merchantOptions",
T2.cBusinessRole AS "merchantRole!businessRole"
FROM A.B T0
LEFT JOIN A.C T5
ON T5.id = T0.id
AND T5.ytenant_id = 'rlcu7kep'
LEFT JOIN A.D T6
ON T6.id = T5.merchantApplyRangeId
AND T6.ytenant_id = 'rlcu7kep'
AND T6.ispotential = 0
LEFT JOIN iuap_apdoc_coredoc.merchantroleinfo T2
ON T2.imerchantId = T0.id
AND T2.ytenant_id = 'rlcu7kep'
WHERE T0.id IN (2393860315440742415,
2392977330273255433,
2392992250989641741,
2393947417377505282,
2393946601333720052,
2393964734685642782,
2392798127057798119,
2392977330273255434,
2393019884809224199,
2393062482294865923,
2393947374427832346)
AND (T5.stopstatus = 0
AND T5.stopstatus = 0
AND T6.orgId IN ('2392345952922370057')
AND T5.stopstatus = 0
AND T6.iRangeType = 1)
AND T0.ytenant_id = 'rlcu7kep' ) t

回答 0
暂无回答
扫一扫
联系客服