search

adrpar / paqu

A parallel query engine for MySQL + Spider Engine built on a fork of shard-query
GNU General Public License v2.0
10 stars 0 forks source link

Broken query #2

Closed adrpar closed 11 years ago

adrpar commented 11 years ago

select * from Bolshoi.particles416 where x=0.998373 or y=0.998373 or z=0.998373

resolves wrongly to:

CALL paquExec("SELECT particleId AS particleId,snapnum AS snapnum,x AS x,y AS y,z AS z,vx AS vx,vy AS vy,vz AS vz,phkey AS phkey FROM Bolshoi.particles416 WHERE ( ) and ( ( y = 0.998373 ) or ( z = 0.998373 ) ) ", "aggregation_tmp_19992916"); USE spider_tmp_shard; SET @i=0; CREATE TABLE multidark_user_admin./*@GEN_RES_TABLE_HERE*/ ENGINE=MyISAM SELECT DISTINCT @i:=@i+1 AS row_id, particleId,snapnum,x,y,z,vx,vy,vz,phkey FROM aggregation_tmp_19992916 ; CALL paquDropTmp("aggregation_tmp_19992916");

adrpar commented 11 years ago

fixed in 6f413f5c94b73667de13c3edf11934ccbf6848ae

adrpar commented 11 years ago

fixed in 330119922a26598cced1d630b6a9370c813ffec9