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

Problems with aliasing: Unknown column 'm.m.fofTreeId' in 'field list' #16

Closed kristinriebe closed 11 years ago

kristinriebe commented 11 years ago

Occured for this query:

SELECT p.fofTreeId, p.treeSnapnum, p.x,p.y,p.z, p.mass, p.np, m.fofTreeId FROM MDR1.FOFMtree AS p, (SELECT fofTreeId, mainLeafId FROM MDR1.FOFMtree WHERE fofId=85000000000) AS m WHERE p.fofTreeId BETWEEN m.fofTreeId AND m.mainLeafId ORDER BY p.treeSnapnum

adrpar commented 11 years ago

fixed in 67022dc3d77961e17e35665fbe2e08c69037afde - related to issue 17