show full processlist in 5.6.14
Hi,
Did an upgrade of a 5.5.28 to 5.6.14 today and found something odd when running "show full processlist".
show full processlist in 5.6.14:
select max(last_report) as "Latest poll time ", cid as "ins_no",mon_stat,sub_tp,substring(sub_exptp,9,1) as "Reprogramming status",
max(from_unixtime(svr.intm)) as "Latest service",spi.`s#ins`
from ge_logs.alive_tracker_log atl force index (last_report_cid_ix)
left join reporting.sbn_panel_info spi on (atl.cid=spi.ins_no)
left join sbnmain.sv_requests svr on (svr.`s#ins`=spi.`s#ins`)
where atl.last_report >= vTimeStart
and atl.last_report <= vTimeStop
and spi.dealer like vDealer
and atl.userName like vRec
and spi.sub_tp like vSubTp
and substring(sub_exptp,9,1) like vSubExpTp
and atl.dealer = vDealId
group by 2
order by 1 desc;
show full processlist in 5.5.28:
select max(last_report) as "Latest poll time ", cid as "ins_no",mon_stat,sub_tp,substring(sub_exptp,9,1) as "Reprogramming status",
max(from_unixtime(svr.intm)) as "Latest service",spi.`s#ins`
from ge_logs.alive_tracker_log atl force index (last_report_cid_ix)
left join reporting.sbn_panel_info spi on (atl.cid=spi.ins_no)
left join sbnmain.sv_requests svr on (svr.`s#ins`=spi.`s#ins`)
where atl.last_report >= NAME_CONST('vTimeStart',_latin1'2013-10-01 00:00:00' COLLATE 'latin1_swedish_ci')
and atl.last_report <= NAME_CONST('vTimeStop',_latin1'2013-10-07 23:59:59' COLLATE 'latin1_swedish_ci')
and spi.dealer like NAME_CONST('vDealer',_latin1'%DNO%' COLLATE 'latin1_swedish_ci')
and atl.userName like NAME_CONST('vRec',_latin1'%MIX%' COLLATE 'latin1_swedish_ci')
and spi.sub_tp like NAME_CONST('vSubTp',_latin1'%DCOM%' COLLATE 'latin1_swedish_ci')
and substring(sub_exptp,9,1) like NAME_CONST('vSubExpTp',_latin1'%' COLLATE 'latin1_swedish_ci')
and atl.dealer = NAME_CONST('vDealId',350)
group by 2
order by 1 desc;
In 5.5.28 the variables was expanded and readable but that is not showing in 5.6.14. We have a application that runs stored procedures and it was handy to be able to copy the running query and do an explain on it without editing.
I there an option that we have missed to turn this back on?