[TRAFODION-3047] Cannot get right result using prepare statement with dynamic parameters

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: sql-cmp
• Assignee: Yang, Yongfeng
• Reporter: Yang, Yongfeng
• Created: 27/Apr/18 03:10
• Updated: 15/Sep/18 07:31
• Resolved: 17/May/18 05:34

Description

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';