[dba-issues] [Issue 92019] query designer changes SEL ECT * FROM table1, table2 to a different state ment
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92019 User atjensen changed the following: What|Old value |New value Status|VERIFIED |CLOSED --- Additional comments from atjen...@openoffice.org Mon May 25 01:30:27 + 2009 --- Checked w/ OO.o 3.1 - WindowsXP Closing - 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: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org - To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
[dba-issues] [Issue 92019] query designer changes SEL ECT * FROM table1, table2 to a different state ment
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92019 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from [EMAIL PROTECTED] Wed Sep 3 11:29:40 + 2008 --- verified in CWS dba31b find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fdba31b - 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 92019] query designer changes SEL ECT * FROM table1, table2 to a different state ment
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92019 User oj changed the following: What|Old value |New value Assigned to|oj|msc --- Additional comments from [EMAIL PROTECTED] Tue Aug 19 11:25:52 + 2008 --- Please verify. Thanks. - 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 92019] query designer changes SEL ECT * FROM table1, table2 to a different state ment
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=92019
User oj changed the following:
What|Old value |New value
Status|NEW |RESOLVED
Resolution| |FIXED
Target milestone|OOo 3.x |OOo 3.1
--- Additional comments from [EMAIL PROTECTED] Wed Aug 13 09:29:11 +
2008 ---
Fixed in cws dba31b.
please submit an extra issue for the second part. Do not submit two issues in
one :-)
Now the statement will be changed to
SELECT "categories".*, "products".* FROM { OJ "products" AS "products" RIGHT
OUTER JOIN "categories" AS "categories" ON "products"."CategoryID" =
"categories"."ID" }
-
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 92019] query designer changes SEL ECT * FROM table1, table2 to a different state ment
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92019 User fs changed the following: What|Old value |New value Target milestone|--- |OOo 3.x --- Additional comments from [EMAIL PROTECTED] Wed Jul 23 06:35:55 + 2008 --- targeting to OOo 3.x - 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 92019] query designer changes SEL ECT * FROM table1, table2 to a different state ment
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=92019 --- Additional comments from [EMAIL PROTECTED] Wed Jul 23 06:35:36 + 2008 --- Created an attachment (id=55317) document to reproduce the bug case - 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 92019] query designer changes SEL ECT * FROM table1, table2 to a different state ment
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=92019
Issue #|92019
Summary|query designer changes SELECT * FROM table1, table2 to
| a different statement
Component|Database access
Version|DEV300m26
Platform|All
URL|
OS/Version|All
Status|NEW
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|oj
Reported by|fs
--- Additional comments from [EMAIL PROTECTED] Wed Jul 23 06:35:02 +
2008 ---
- open the attached database document
- open the query "categorized products" in SQL view ("Edit in SQL View" from
its context menu)
=> the statement starts with "SELECT * FROM ..."
- switch to the graphical query designer
- switch back to the SQL view
=> the query now is "SELECT "products".*, "products".* FROM ..."
This is clearly a different statement, which yields a different result ...
A bug which is probably related: If you try to enter such a statement in the
graphical view, i.e. if you merely enter "*" in the "Field" cell, then this is
automatically corrected to "products.*". In other words, it is impossible to
create a SELECT statement which does a "SELECT * ..." from multiple tables.
-
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]
