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

Syntax error when doing computation with built-in function #32

Open kristinriebe opened 9 years ago

kristinriebe commented 9 years ago

Query

SELECT 0.5*max(Mvir) as m from MDR1.BDMV where snapnum=85

Query plan

-- CALL paquExec('SELECT 0.5 * MAX AS `_0__5_*_max_Mvir_` FROM MDR1.BDMV WHERE ( `snapnum` = 85 ) ', 'aggregation_tmp_16656224')
-- USE spider_tmp_shard
-- SET @i=0-- CREATE TABLE cosmosim_user_kristin.`2014-11-28-14-08-18-8760` ENGINE=MyISAM SELECT @i:=@i+1 AS `row_id`, `_0__5_*_max_Mvir_` FROM `aggregation_tmp_16656224` 
-- CALL paquDropTmp('aggregation_tmp_16656224')

Error Unknown column 'MAX' in 'field list'

A query like SELECT max(Mvir) as m ... works fine, I just encounter problems if I add the multiplication or subtract something etc.