CUBRID2008 Manager Client에서 서브쿼리 결과오류 문의드립니다.

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

-------------------------------------------------------