To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=44644 Issue #:|44644 Summary:|Incorrect query result Component:|Database access Version:|OOo 2.0 Beta Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|none Assigned to:|msc Reported by:|jspitz
------- Additional comments from [EMAIL PROTECTED] Wed Mar 9 14:10:12 -0800 2005 ------- I have created a simple query "SELECT min(CELKEM), max(CELKEM) FROM 'denik'". As a result I obtain two columns CELKEM with the same number equal to minimum of CELKEM. It is incorrect, since there exist different values in the column CELKEM. The problem is obviously caused by omitting aliases of the output fields. If I rewrite the query into form "SELECT min(CELKEM) minimum, max(CELKEM) maximum FROM 'denik'", then I receive two columns MINIMUM and MAXIMUM with correct results. Passing the first query directly to the database (passthru query) I get two columns CELKEM and CELKEM1 with correct results. This should be the normal behaviour in case the field aliases are omitted. Tested on OOo builds 680_82, 680_83 and 680_84 all Czech version under Mandrake Linux 10.1. --------------------------------------------------------------------- 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]