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

Query needs fixing: #9

Closed adrpar closed 11 years ago

adrpar commented 11 years ago

Dear Daiquiri developer, a message was send via the contact form of the query plan editor: ---Original Query: select webid, eigen1,eigen2,eigen3, floor(iz) from MDR1.Tweb512 as w limit 10 Query Plan:

CALL paquExec("SELECT webid AS webid,eigen1 AS eigen1,eigen2 AS eigen2,eigen3 AS eigen3 FROM MDR1.Tweb512 AS w ORDER BY NULL LIMIT 0,10", "aggregation_tmp_71351010"); 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, webid,eigen1,eigen2,eigen3 FROM aggregation_tmp_71351010 LIMIT 0,10; CALL paquDropTmp("aggregation_tmp_71351010"); ---From: n/a n/a Email: admin@example.com Unnamed columns are not included in the resulting columns, in this case "floor(iz)". When doing the same query like this: select webid,eigen1,eigen2,eigen3, floor(iz) as floor from MDR1.Tweb512 as w limit 10 everything works fine. ---Best Regards

adrpar commented 11 years ago

fixed in 394489afe00af9f4ca83539036bbb072f79e784b