Valid MySQL query not parsing in Studio

[barry_4]

I have the following SQL query that was developed with the MySQLWorkbench :

 

select L1.issue_no, L1.name,    priority  as Priority,votes_total +1  as Votes,  priority * (votes_total+1) as Importance ,    estimated_months*21/5 + estimated_weeks + estimated_days/5 + estimated_hours/40 as Cost from issues L1 join bugs.listtypes LT  on L1.priority = LT.id where milestone not in (31, 35, 0)and project_id = 1[/code]

 

 

It get me the basic data that I need.  (from  The Bug Genie )  That is, it works.

 

When I copy this query to the Data Source Wizard - I get a syntax error, apparently whatever parser is being used seems to expect a SELECT clause following the paranthesis '(' rather than a simple arithmetic computation.

 

The pattern is:

 

Select colA, colB, colC, ColA*(ColB + ColC - Constant) .... 

 

I can use a variable to get the result, but I'd prefer to use SQL where possible.  I've been doing it for so long now its second nature.

 

Thanks in advance for thoughts.  

 

Stay well

Barry

 

 

 

[hozawa]

Most of the time, I'm able to just save the sql statement desprite the error message and the report runs without any problems.

[barry_4]

Hi, 

I was able to 'fool' it by (Select Col + 1).

Thank you