[jira] [Resolved] (TRAFODION-3047) Cannot get right result using prepare statement with dynamic parameters

["Yang, Yongfeng (JIRA)" <ji...@apache.org>]

     [ 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)