[
https://issues.apache.org/jira/browse/TRAFODION-3047?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yang, Yongfeng resolved TRAFODION-3047.
---------------------------------------
Resolution: Fixed
> 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
> Priority: Major
>
> 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)
