CUBRID Manager Client에서 서브쿼리의 결과가 출력되지 않습니다.
실제 CUBRID DB에서 실행하면 정상적으로 결과를 얻을수 있지만,
CUBRID Manager Client 에서는 결과가 나오지 않는군요.
큐브리드버젼 : CUBRID 2008 R2.0
------------ 실행 쿼리 ------------------
SELECT
MC.vcBizcerti,
MC.vcBank,
to_char(MC.dtBizRegdate, 'YYYY-MM-DD') dtBizRegdate,
to_char(MC.dtBankRegdate, 'YYYY-MM-DD') dtBankRegdate,
(SELECT M.cTestimony FROM tbl_member M WHERE M.cUserId = MC.cUserId) cTestimony
FROM
tbl_member_certification MC
WHERE
MC.cUserId = '아이디'
----------------------------------------
------- 실행 쿼리에 대한 실행 계획 --------
Join graph segments (f indicates final):
seg[0]: [0]
seg[1]: cTestimony[0] (f)
seg[2]: cUserId[0]
Join graph nodes:
node[0]: tbl_member M(134/12) (sargs 0)
Join graph terms:
term[0]: M.cUserId=MC.cUserId (sel 0.0175439) (sarg term) (not-join eligible) (indexable cUserId[0]) (loc 0)
Query plan:
iscan
class: M node[0]
index: pk_tbl_member2_cuserid term[0]
cost: fixed 1(0.0/1.0) var 1(0.0/1.0) card 2
Query stmt:
(select M.cTestimony from tbl_member M where M.cUserId=MC.cUserId)
Join graph segments (f indicates final):
seg[0]: [0]
seg[1]: vcBizcerti[0] (f)
seg[2]: vcBank[0] (f)
seg[3]: dtBizRegdate[0] (f)
seg[4]: dtBankRegdate[0] (f)
seg[5]: cUserId[0] (f)
Join graph nodes:
node[0]: tbl_member_certification MC(134/5) (sargs 0)
Join graph terms:
term[0]: MC.cUserId='test16' (sel 0.0181818) (sarg term) (not-join eligible) (indexable cUserId[0]) (loc 0)
Query plan:
iscan
class: MC node[0]
index: pk_tbl_member_certification_cuserid term[0]
cost: fixed 1(0.0/1.0) var 1(0.0/1.0) card 2
Query stmt:
select MC.vcBizcerti, MC.vcBank, to_char(MC.dtBizRegdate, 'YYYY-MM-DD', 'en_US'), to_char(MC.dtBankRegdate, 'YYYY-MM-DD', 'en_US'), (select M.cTestimony from tbl_member M where M.cUserId=MC.cUserId) from tbl_member_certification MC where MC.cUserId= ?:0
-------------------------------------------------------