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

PaQu parse error for subquery inside BETWEEN #12

Closed kristinriebe closed 11 years ago

kristinriebe commented 11 years ago

Following query is not executed due to an SQL Parse Error in PaQu. The individual parts are fine, just the combination of a subquery inside the BETWEEN statement causes trouble

SELECT * FROM MDR1.FOFMtree WHERE fofTreeId BETWEEN 100000000 AND (SELECT lastProgId FROM MDR1.FOFMtree WHERE fofTreeId = 100000000) AND np>1000

adrpar commented 11 years ago

fixed in e86063e8945a7f169ffe4203295a4bc8f9ded690