views:

52

answers:

2

Any idea why the following query syntax is wrong:

SELECT year, sum(profit)
FROM BASEDATA b 
group by year WITH rollup

Error Code: 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.....

MYSQL Version 5.0.77-community-log

A: 

All seems ok. Are you sure you selected the correct database?

ocell
yes works without with rollup
DD
Really looks like an X file! Are you sure that the client (API/etc.) your are using supports it?
ocell
A: 

It appears to be a bug in MySQL Workbench...the query runs fine under MySQL Query Browser.

DD