One more column returned than asked for

[kristinriebe]

This is a non-critical issue, just unexpected behaviour that may be inconvenient.

Query

select fofTreeId, fofId from MDR1.FOFMtree where treeSnapnum=39 
order by mass desc limit 100

Query plan

-- CALL paquExec('SELECT `fofTreeId` AS `fofTreeId`,`fofId` AS `fofId`,`mass` AS `mass` FROM MDR1.FOFMtree WHERE ( `treeSnapnum` = 39 ) ORDER BY `mass` DESC LIMIT 0,100', 'aggregation_tmp_49437004')
-- USE spider_tmp_shard
-- SET @i=0-- CREATE TABLE cosmosim_user_guest.`mtree-ids` ENGINE=MyISAM SELECT @i:=@i+1 AS `row_id`, `fofTreeId`,`fofId`,`mass` FROM `aggregation_tmp_49437004` ORDER BY `mass` DESC LIMIT 0,100
-- CALL paquDropTmp('aggregation_tmp_49437004') 

Problem The mass-column is not in the select-list, but was returned anyway. This leads to more data being returned (downloaded) than the user expected.