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