【infobright】The query includes syntax that is not supported by the Infobright Optimizer.

报错：
[Err] 5 - The query includes syntax that is not supported by the Infobright 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 performance.

原因是不支持mysql的语法，很好解决，但是网上的方法

在my-ib.ini 修改
AllowMySQLQueryPath = 1

是无效的，因为他是个只可读的变量
正确方法应该是在infobright/data/brighthouse.ini里修改
把下图红框里的#去掉即可
然后记得重启服务哈！