[dba-issues] [Issue 96470] Adding table twice results in unexpected behaviour in query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96470 User leggewie changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from [EMAIL PROTECTED] Wed Nov 26 17:44:31 + 2008 --- atjensen, thank you for helping me understand this. Although I find it somewhat unintuitive (adding a table without adding a field from it should not change the result, or so I thought), the resulting SQL does indeed work as designed. - 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]
[dba-issues] [Issue 96470] Adding table twice results in unexpected behaviour in query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96470 User atjensen changed the following: What|Old value |New value Status|UNCONFIRMED |RESOLVED Resolution| |WORKSFORME --- Additional comments from [EMAIL PROTECTED] Mon Nov 24 10:44:07 + 2008 --- Given that following the steps to reproduce this problem does not seem to cause a problem I will resolve this as WORKSFORME @leggewie - If I've misunderstood the situation update the issue. Also, don't hesitate to use the support services offered for SQL questions at either the User Forums or dba project user mailing list. - 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]
[dba-issues] [Issue 96470] Adding table twice results in unexpected behaviour in query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96470 --- Additional comments from [EMAIL PROTECTED] Sun Nov 23 13:17:01 + 2008 --- Sure - Tested using Ubuntu 8.10(x64) - SUN JRE 1.0.6.10 OO.o used Ubuntu supplied 2.4.1 OpenOffice.org supplied 3.0 Both cases: Using the odb file referenced, current query produces 3 rows Add second instance of Products table, no join, produces 9 rows - 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]
[dba-issues] [Issue 96470] Adding table twice results in unexpected behaviour in query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96470 --- Additional comments from [EMAIL PROTECTED] Sun Nov 23 12:53:59 + 2008 --- atjensen, thank you for testing this out. You still get three rows even after adding the products table for the second time? I tried with a different user on my system and I see more than ten rows after adding the table twice. Can you maybe give more information on your system? I am running Ubuntu hardy on a Thinkpad X24. I was able to reproduce this with the binaries provided from ubuntu. Right now, I run a self-compiled binary based on m9 (OOo3) which still has this problem. - 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]
[dba-issues] [Issue 96470] Adding table twice results in unexpected behaviour in query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96470 User atjensen changed the following: What|Old value |New value CC|''|'atjensen' - 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]
[dba-issues] [Issue 96470] Adding table twice results in unexpected behaviour in query
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=96470 User atjensen changed the following: What|Old value |New value Summary|Adding table twice results|Adding table twice results | in unexpected behaviour i| in unexpected behaviour i |n query |n query --- Additional comments from [EMAIL PROTECTED] Sun Nov 23 12:23:16 + 2008 --- @leggewie - Well unless you left out a step in how to reproduce this it appears to be working correctly. Adding a table and not adding any type of join will result in the output this query produces. - 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]
[dba-issues] [Issue 96470] Adding table twice results in unexpected behaviour in query
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 + 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]