Limit applied too soon in query with join
Closed this issue · 1 comments
SELECT p.x,p.y,p.z
FROM
MDR1.FOFParticles AS fp,
MDR1.particles85 AS p
WHERE fp.fofId = 85000000000
AND fp.particleId = p.particleId
limit 10
results in
CALL paquExec('SELECT p.x AS p.x,p.y AS p.y,p.z AS p.z,p.particleId AS p.particleId FROM MDR1.particles85 AS p ORDER BY NULL LIMIT 0,10', 'aggregation_tmp_52487562')-- CALL paquExec('SELECT p.p.x AS p.x,p.p.y AS p.y,p.p.z AS p.z FROM MDR1.FOFParticles AS fp JOIN ( SELECT p.x,p.y,p.z,p.particleId FROM aggregation_tmp_52487562 LIMIT 0,10) AS p WHERE ( fp.fofId = 85000000000 AND fp.particleId = p.p.particleId ) ', 'aggregation_tmp_60388287')-- CALL paquDropTmp('aggregation_tmp_52487562')-- USE spider_tmp_shard-- SET @i=0-- CREATE TABLE multidark_user_kristin.test-join-fp-2 ENGINE=MyISAM SELECT @i:=@i+1 AS row_id, distinct_res_table.* FROM ( SELECT DISTINCT p.x,p.y,p.z
FROM aggregation_tmp_60388287 ) as distinct_res_table-- CALL paquDropTmp('aggregation_tmp_60388287')
and returns no results