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

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

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)