开发日记——Maximum output rowsize(32767) exceeded

分析原因后发现是因为有几个字段设置的值很大，select 1 的时候解析sql会把所有字段算进去。改成select id就行了。 

select tr.sus_trade_id,tr.sus_trade_code,tr.source,tr.rstc,tr.stcd,tr.trade_num,tr.status,tr.create_date,tr.start_date
from rpt_sus_trade tr 
where 
exists(select mo.mon_id from rpt_monitoring_standard mo 
        where tr.sus_trade_id = mo.sus_trade_id and mo.mon_id is not null
        and exists(select te.tech_id from rpt_tech te where mo.mon_id=te.mon_id))
or exists(select te.tech_id from rpt_tech te where tr.sus_trade_id=te.sus_trade_id)