Public bug reported: Binary package hint: openoffice.org
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" ** Affects: openoffice.org (Ubuntu) Importance: Undecided Status: New -- adding table twice results in unexpected behaviour in query https://bugs.launchpad.net/bugs/274867 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
