To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=42405 Issue #:|42405 Summary:|Query with function works not with HSQLDB Component:|Database access Version:|680m77 Platform:|All URL:| OS/Version:|Windows 2000 Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|msc Reported by:|hkienlein
------- Additional comments from [EMAIL PROTECTED] Thu Feb 10 02:18:24 -0800 2005 ------- Hi * I have a Table with id as integer (PK), fk2 as integer, name2 as varchar and wert2 as varchar and some datas in it. If I create a new Query in designMode and take a function over one single column I got error: Die Dateninhalte konnten nicht geladen werden. SQL-Status: 37000 Fehler-Code: -67 Not in aggregate function or group by clause: COLUMN Tabelle2.id2 in statement [SELECT "id2", "name2", "wert2", MAX( "fk2" ) FROM "Tabelle2" "Tabelle2"] If I take a function for every field in the query, it works, so a: SELECT MIN( "id2" ), COUNT( "name2" ), COUNT( "wert2" ), MAX( "fk2" ) FROM "Tabelle2" "Tabelle2" give the right result back --------------------------------------------------------------------- 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]