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

Support for single quotes in string comparison #10

Closed kristinriebe closed 11 years ago

kristinriebe commented 11 years ago

String comparisons like: ... where FOF="F" are working, but not for: ... where FOF='F'.

In detail: the following query at the multidark-website:
select * from MDR1.AvailHalos where FOF='F'

failed with: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' ) LIMIT 0;', '', concat('host "', __sp__.host ,'", port "', __sp__.port' at line 1

Query plan was: select * from MDR1.AvailHalos where FOF='F'-- The query plan used to run this query: -------------------------------------------------- CALL paquExec("SELECT MDR1.AvailHalos.snapnum AS MDR1__AvailHalos__snapnum,MDR1.AvailHalos.redshift AS MDR1__AvailHalos__redshift,MDR1.AvailHalos.FOF AS MDR1__AvailHalos__FOF,MDR1.AvailHalos.BDM AS MDR1__AvailHalos__BDM,MDR1.AvailHalos.BDMprof AS MDR1__AvailHalos__BDMprof FROM MDR1.AvailHalos WHERE ( FOF = 'F' ) ", "aggregation_tmp_83109682")-- USE spider_tmp_shard-- SET @i=0-- CREATE TABLE multidark_user_kristin.2013-09-17T14:15:44:6655 ENGINE=MyISAM SELECT DISTINCT @i:=@i+1 AS row_id, MDR1__AvailHalos__snapnum,MDR1__AvailHalos__redshift,MDR1__AvailHalos__FOF,MDR1__AvailHalos__BDM,MDR1__AvailHalos__BDMprof FROM aggregation_tmp_83109682 -- CALL paquDropTmp("aggregation_tmp_83109682")

adrpar commented 11 years ago

solved in c446eaa4cb4492a2e4f89ca735e2b3434db43b68