Query needs fixing:
adrpar opened this issue · 1 comments
SELECT part.fofId, part.particleId from MDR1.FOFParticles AS part, MDR1.FOF AS hal WHERE part.fofId=hal.fofId LIMIT 10;
CALL paquExec("SELECT part.fofId AS part.fofId,part.particleId AS part.particleId FROM MDR1.FOFParticles AS part ORDER BY NULL LIMIT 0,10", "aggregation_tmp_21476816");
CALL paquExec("SELECT part.fofId AS part.fofId,part.particleId AS part.particleId FROM MDR1.FOF AS hal JOIN ( SELECT part.fofId,part.particleId FROM aggregation_tmp_21476816 LIMIT 0,10) AS part WHERE ( part.part.fofId.fofId=hal.fofId ) ", "aggregation_tmp_5422139"); CALL paquDropTmp("aggregation_tmp_21476816"); USE spider_tmp_shard; SET @i=0; CREATE TABLE multidark_user_admin./@GEN_RES_TABLE_HERE/ENGINE=MyISAM SELECT DISTINCT @i:=@i+1 ASrow_id,part.fofId,part.particleId FROMaggregation_tmp_5422139` ;
CALL paquDropTmp("aggregation_tmp_5422139");
aliasing BROKEN!