To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96470 Issue #|96470 Summary|Adding table twice results in unexpected behaviour in |query Component|Database access Version|DEV300m9 Platform|PC URL|https://bugs.launchpad.net/ubuntu/+source/openoffice.o |rg/+bug/274867 OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|leggewie
------- Additional comments from [EMAIL PROTECTED] Sun Nov 23 11:26:41 +0000 2008 ------- copied from https://bugs.launchpad.net/ubuntu/+source/openoffice.org/+bug/274867 steps to reproduce problem: * open http://www.openoffice.org/nonav/issues/showattachment.cgi/56852/OOo_debug.odb * open "unnormalized table" query in edit mode * Press F5, the query runs fine and displays three rows * return to edit mode * press F7 and add the products table for a second time * press F5 to run the query again and see that there are a number of erroneous rows in the result still present even in m31 The SQL statement that returns the correct results is SELECT "products"."productName", "categories"."categoryName" FROM "products", "categories" WHERE "products"."categoryID" = "categories"."categoryID" the one after adding the table for the second time is SELECT "products"."productName", "categories"."categoryName" FROM "products", "categories", "products" AS "products_1" WHERE "products"."categoryID" = "categories"."categoryID" --------------------------------------------------------------------- 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]
