Yang, Yongfeng created TRAFODION-3047:
-----------------------------------------
Summary: Cannot get right result using prepare statement with
dynamic parameters
Key: TRAFODION-3047
URL: https://issues.apache.org/jira/browse/TRAFODION-3047
Project: Apache Trafodion
Issue Type: Bug
Components: sql-cmp
Reporter: Yang, Yongfeng
Assignee: Yang, Yongfeng
prepare s1 from SELECT (SELECT 'Y'
FROM dual
WHERE EXISTS (SELECT 1
FROM dic
WHERE std_area_id = dom.std_area_id)) impact_yn
, (SELECT cd_nm
FROM code
WHERE lang_cd = 'zh_CN'
AND up_cd_id = '6023'
AND cd_id = dom.dom_type_cd) dic_gbn_nm
FROM dom
WHERE dom.std_area_id = ?
AND dom.dom_type_cd = '0003';
execute s1 using '4C6A337943';
can not get result with prepare statement. But can get the get the right result
with following statement.
prepare s1 from SELECT (SELECT 'Y'
FROM dual
WHERE EXISTS (SELECT 1
FROM dic
WHERE std_area_id = dom.std_area_id)) impact_yn
, (SELECT cd_nm
FROM code
WHERE lang_cd = 'zh_CN'
AND up_cd_id = '6023'
AND cd_id = dom.dom_type_cd) dic_gbn_nm
FROM dom
WHERE dom.std_area_id = '4C6A337943'
AND dom.dom_type_cd = '0003';
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
