[dba-issues] [Issue 74071] 2.1.0 Base table alias
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74071 User oj changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from [EMAIL PROTECTED] Tue Aug 28 12:00:36 + 2007 --- 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: [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 74071] 2.1.0 Base table alias
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74071 User oj changed the following: What|Old value |New value Status|NEW |RESOLVED Resolution| |DUPLICATE --- Additional comments from [EMAIL PROTECTED] Tue Aug 28 12:00:14 + 2007 --- Set as duplicate. *** This issue has been marked as a duplicate of 56898 *** - 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 74071] 2.1.0 Base table alias
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74071 --- Additional comments from [EMAIL PROTECTED] Wed Jul 11 19:42:35 + 2007 --- related issues: www.openoffice.org/issues/show_bug.cgi?id=76377 dba.openoffice.org/servlets/BrowseList?list=usersby=threadfrom=1718435 self join problem (requiring table name alias) www.openoffice.org/issues/show_bug.cgi?id=76374 cross join of the same table (requiring table name alias) www.openoffice.org/issues/show_bug.cgi?id=73627 inner join and cross join of the same table (requiring table name alias) www.openoffice.org/issues/show_bug.cgi?id=69227 cyclic reference inside queries dba.openoffice.org/servlets/BrowseList?list=usersby=threadfrom=1493243 dba.openoffice.org/servlets/ReadMsg?list=usersmsgNo=3911 table name alias invoked in SQL statements problem for OO Base GUI Query not a problem for SQL View The revised attachment in issue 69227 has **revised away** the problem of the table name alias for GUI Query. - 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 74071] 2.1.0 Base table alias
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74071 --- Additional comments from [EMAIL PROTECTED] Tue Mar 27 14:58:53 + 2007 --- confirmed - 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 74071] 2.1.0 Base table alias
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74071 --- Additional comments from [EMAIL PROTECTED] Thu Mar 1 10:20:35 + 2007 --- I can confirm too, an easies way to reproduce is create a new db, create a table with some fields, (id, foo as example) calling it 'footable' go in the query gui, add twice the table in the query you will see 'footable' and 'footable_1' and make a join between them by id field, and double clic on a field to add it to the selection, then press the F4 (or choose from menu the 'preview') and the query fails 'cause the alias 'footable_1' is not present in the created query it needs this string ', footable footable_1' in the from clause It's very important to resolve this bug, to make oo.org available for companies that uses complex queries - 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 74071] 2.1.0 Base table alias
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74071 --- Additional comments from [EMAIL PROTECTED] Thu Mar 1 10:21:24 + 2007 --- I can confirm too, an easies way to reproduce is create a new db, create a table with some fields, (id, foo as example) calling it 'footable' go in the query gui, add twice the table in the query you will see 'footable' and 'footable_1' and make a join between them by id field, and double clic on a field to add it to the selection, then press the F4 (or choose from menu the 'preview') and the query fails 'cause the alias 'footable_1' is not present in the created query it needs this string ', footable footable_1' in the from clause It's very important to resolve this bug, to make oo.org available for companies that uses complex queries - 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 74071] 2.1.0 Base table alias
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74071 User fs changed the following: What|Old value |New value Ever confirmed| |1 Status|UNCONFIRMED |NEW --- Additional comments from [EMAIL PROTECTED] Thu Mar 1 10:41:01 + 2007 --- confirming, since it has been reproduced - 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 74071] 2.1.0 Base table alias
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74071 User msc changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |oj --- Additional comments from [EMAIL PROTECTED] Thu Mar 1 10:48:39 + 2007 --- reassign - 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 74071] 2.1.0 Base table alias
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74071 User msc changed the following: What|Old value |New value Target milestone|not determined|OOo 2.x --- Additional comments from [EMAIL PROTECTED] Thu Feb 22 10:07:21 + 2007 --- HI, I can reproduce this issue. I reassign it to the right developer msc - oj: after switching to the GUI design the query doesn't work anymore. Bye Marc - 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 74071] 2.1.0 Base table alias
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=74071 Issue #|74071 Summary|2.1.0 Base table alias Component|Database access Version|OOo 2.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|rjahn1 --- Additional comments from [EMAIL PROTECTED] Wed Jan 31 15:22:11 -0800 2007 --- Table alias is not a cosmetic feature. It is mandatory to build complex queries when the same source table is invoked multiple times. Without table alias, complex queries cannot be built. OO Base currently provides 2 types of stored queries. * SQL View created through CUI (Tools – SQL) stored on the DB engine side handled by DB engine * GUI Query created through GUI stored on the client side handled by Base GUI parser GUI Query in 2.1.0 always fails when table alias is in query statement. Example: * Create a new database. * Create 2 test tables, as shown in the end. * Select GUI Query (Queries in the left pane) * Select Create Query in SQL Window Note: still inside Base GUI, not handled by DB engine * type in the contrived query statement, as shown in the end. * Press the design mode button (switch to GUI mode) 4 tables of alias names appear in relation window. No tables of the original name No key connection lines between any tables. * Press the design mode button (switch to text mode) Table aliases disappeared in the From clause. Table aliases remain in other sections of the query statement. * Press the design mode button (switch to GUI mode) 6 tables icons appear in relation window, 4 in alias names, 2 in the original names. No key connection lines exist on the table icons of the original names. Key connection lines appear correctly for table icons of alias names. * Further switching between the GUI and text modes reveals no more changes. * Save as qq test and close the GUI. Should see a stored GUI Query qq test. * Double click qq test to execute. * error message: The data content could not be loaded. Column not found: tm01.ID module in ... -- SQL code to reproduce the symptom Create Table tt part ( ID part BigInt, source VarChar( 100 ), notesVarChar( 100 ), Constraint pk_tt_part Primary Key ( ID part ) ); Create Table tt module ( ID module BigInt, ID part BigInt, notes VarChar( 100 ), Constraint pk_tt_module Primary Key ( ID module ), Constraint fk_01_tt_module Foreign Key ( ID part ) References tt part ( ID part ) On Update Cascade On Delete Restrict ); -- a trivial, contrived query for table alias Select tm01.ID module as md01, tp01.ID part as pt01, tm02.ID module as md02, tp02.ID part as pt02 From tt module as tm01, tt part as tp01, tt module as tm02, tt part as tp02 Where tp01.source = 'vendor 1' and tp01.ID part = tm01.ID part and tp02.source = 'vendor 2' and tp02.ID part = tm02.ID part; - 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]