Can't get all data qualities anymore

[dominikkirchhoff]

This is due to (some) bad data quality names, e.g.:

SELECT d.name AS dataset, MAX(IF(dq.quality='J48.00001.AUC', dq.value, NULL))
AS J48.00001.AUC FROM dataset d, data_quality dq WHERE d.did = dq.data AND 
d.isOriginal = 'true' GROUP BY dataset

Error 1064: 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 '.00001.AUC FROM dataset d, data_quality dq WHERE d.did = dq.data AND d.isOrigina' at line 1

[joaquinvanschoren]

Hi Dominik,

Quick fix: use backquotes when you name stuff: MAX(...) AS J48.00001.AUC

We currently have no constraints on data quality names, but even if we
would then periods '.' should be allowed?

On 6 June 2014 18:47, dominikkirchhoff notifications@github.com wrote:

This is due to (some) bad data quality names, e.g.:

SELECT d.name AS dataset, MAX(IF(dq.quality='J48.00001.AUC', dq.value, NULL))
AS J48.00001.AUC FROM dataset d, data_quality dq WHERE d.did = dq.data AND
d.isOriginal = 'true' GROUP BY dataset

Error 1064: 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
'.00001.AUC FROM dataset d, data_quality dq WHERE d.did = dq.data AND
d.isOrigina' at line 1

—
Reply to this email directly or view it on GitHub
#59.

Joaquin Vanschoren
about me http://www.win.tue.nl/~jvanscho/

[dominikkirchhoff]

Perfect, now it works again. Thank you.

Yeah, periods are not too weird ;) Now that it's fixed, I don't see a problem there.