Yang, Yongfeng created TRAFODION-3091:
-----------------------------------------
Summary: Unnamed Dynamic parameter doesn't work in WITH statement
Key: TRAFODION-3091
URL: https://issues.apache.org/jira/browse/TRAFODION-3091
Project: Apache Trafodion
Issue Type: Improvement
Components: sql-cmp
Reporter: Yang, Yongfeng
Assignee: Yang, Yongfeng
prepare s1 from WITH req AS (
SELECT 'Y' apr_tgt_yn
FROM msg_sign_rslt
WHERE signer_id = DECODE(signer_gbn, 'G', (SELECT 'D' FROM usr_user WHERE
user_id = ?))
)
,req_info AS (
SELECT apr_tgt_yn FROM req
UNION ALL
SELECT apr_tgt_yn FROM req
)
select * from req_info;
execute s1 using admin;
|create a simple table:
create table t1 (a int , b varchar(10));
insert data:
insert into t1 values(1,'bbb');
in trafci or sqlci:
prepare s from with aa as (
select a from t1 where b = ?
)
select * from aa;
execute s using 'bbb';
----no result
prepare s from with aa as (
select a from t1 where b = ?a
)
select * from aa;
set param ?a 'ING';
execute s ;
----has result|
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
