To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107654 Issue #|107654 Summary|In some cases Query loses the Function if something ch |anges inside the "Field" row Component|Database access Version|OOO320m7 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ud
------- Additional comments from [email protected] Sun Dec 13 22:32:07 +0000 2009 ------- I create an query with a "Sum" function like: CASEWHEN( "ID" > 2, "Zahl", 0 ) This works properly, but if i change something inside like CASEWHEN( "ID" > 3, "Zahl", 0 ) I get this error: SQL Status: 37000 Error code: -67 Not in aggregate function or group by clause: org.hsqldb.express...@85e019 in statement [SELECT SUM( "Zahl" ) AS "Summe", CASEWHEN( "ID" > 2, "Zahl", 0 ) AS "ChangeMe" FROM "Table1"] To get it work again, i have to change the Function to e.g. "count", run the query again and after that set the function back to "Sum" Only a save or save and close of the query does not solve the problem. But after reopen the query you can see, that the "Sum" Function is lost. Not only the "Sum" Function is affected. -Open attached database -Edit query "Query1" -Change "CASEWHEN( "ID" > 2, "Zahl", 0 )" to "CASEWHEN( "ID" > 3, "Zahl", 0 )" -Run the query => ERROR -Change Function to "count" -Run the query -Change Function to "Sum" -Run the query => NO ERROR => It is the same Error, if i start with the "count" Funktion I checked with OOO320m7 and OOO3.1.1 and both the same --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
