hi,

i run the query:

select
      l_returnflag,
      l_linestatus,
      sum(l_quantity) as sum_qty,
      sum(l_extendedprice) as sum_base_price,
      sum(l_extendedprice*(1-l_discount)) as sum_disc_price,
      sum(l_extendedprice*(1-l_discount)*(1+l_tax)) as sum_charge,
      avg(l_quantity) as avg_qty,
      avg(l_extendedprice) as avg_price,
      avg(l_discount) as avg_disc,
      count(*) as count_order
from
      lineitem
where
      l_shipdate <= date ‘1998-12-01’
group by
      l_returnflag,
      l_linestatus
order by
      l_returnflag,
      l_linestatus;

and got the following error:
ERROR 5 (HY000): The query includes syntax that is not supported by the Infobri
ht Optimizer. Either restructure the query with supported syntax, or enable the
MySQL Query Path in the brighthouse.ini file to execute the query with reduced
erformance.

can you advise what is not supported?

Hi !

instead of

use

In such a version this query works for me. What ICE version do you use?

J.

thanks, check it now!

i tried your suggesytion, same error, i am using the latest ice on your website: 4.03

4.0.7 should be the latest version

http://www.infobright.org/Download/ICE/

And the query works just fine for me with 4.0.7

you are correct - i am running 4.0.7. i will try to check again the code.