SELECT
AA.tb_id AS tb_id,
AA.tb_name AS tb_name,
AA.tb_level AS tb_level,
AA.tb_parent_id AS tb_parent_id,
AA.tb_alias AS tb_alias,
AA.pop3_id AS pop3_id,
AA.last_route AS last_route,
AA.flag_use AS flag_use,
AA.flag_tbtype AS flag_tbtype,
AA.tbclass_1,
AA.tbclass_2,
AA.tbclass_3,
AA.register_date AS register_date,
AA.cnt_agent AS cnt_agent,
BB.cnt_option AS cnt_option,
CC.cnt_subtb AS cnt_subtb,
DD.cnt_templet AS cnt_templet
FROM
v_tblistall1 AS AA,
v_tblistall2 AS BB,
v_tblistall3 AS CC,
v_tblistall4 AS DD
WHERE
AA.tb_id = BB.tb_id AND
AA.tb_id = CC.tb_id AND
AA.tb_id = DD.tb_id
ORDER BY
AA.tb_level, AA.sort_order
이 쿼리를 날렸을때 아래와 같은 에러가뜨네요..
SQLException caught subSelectTBListWithQuery: The current query would generate a key size of 660 for a work table.
This exceeds the maximum allowable limit of 600
여기서 v_tblistall1, v_tblistall2, v_tblistall3, v_tblistall4 는 view입니다.
sybase에서 from절에는 subQuery가 지원이 안된다구 해서 view로 만들어서 쿼리를 실행했는데 에러가 나네용.. 흑흑.. 왜 나는지 좀 알려주세요..
해결책도 함께.. ^^
|