szymic1 Posted October 15, 2009 Share Posted October 15, 2009 Hi,I've recently discovered error on one of our report after migration of our database from Postgres 8.3 to Postgres 8.4. Jasper server generate following select count("CrmGrouView"."*") as "m0" from (SELECT * FROM warehouse.crm_document JOIN warehouse.crm_group ON id_crm_group=crm_group_id WHERE document_type='PAY') as "CrmGrouView"the problem is with this part "*", in Postgres 8,4 * cannot be in ". Do you know any workaround ?Full bug description:http://jasperforge.org/projects/jasperserver/tracker/view.php?id=4355 Michal Szymanskihttp://blog.szymanskich.nethttp://techblog.freeconet.pl Link to comment Share on other sites More sharing options...
swood Posted December 1, 2009 Share Posted December 1, 2009 It looked like you had a comment "/*....*/" in the middle of the MDX. That will not work. ShermanJaspersoft Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now