Hello
I have query and I want to use WITH ROLLUP modifier.
Infobright “tells me” that I can’t use it.
Now I will have to do very complicated query with subquery to complete my task.

Is Infobright Dev Team will be implements WITH ROLLUP modifier? Or is there some way to use that now?

Thanks, cheers,
Slawek

slawekk,

Although we have seen this mentioned a few times by evaluators we have not seen it as a requirement.  “WITH ROLLUP” is a very large development effort as it is part of a larger set of functionality from the ANSI SQL 2003 standard known as Windowing Functions.  (This is from the top of my head so I apologize for any incorrect details.)  These functions are implemented to differing degrees by other vendors but we are also aware that some of this development spanned over three years.

At this point in time, although these functions are available in MySQL in general, there are no current plans to implement them in Infobright.  If this is a major issue for you and your organization, please feel free to provide us a more detailed needs analysis for evaluation by Product Management and Engineering.

Best wishes,