[dba-issues] [Issue 72252] SQL queries to Oracle stop working
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72252 --- Additional comments from o...@openoffice.org Tue Jul 6 05:45:16 + 2010 --- *** Issue 112505 has been marked as a duplicate of this issue. *** - 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 72252] SQL queries to Oracle stop working
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72252 --- Additional comments from o...@openoffice.org Tue Jul 6 05:40:44 + 2010 --- *** Issue 93692 has been marked as a duplicate of this issue. *** - 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 72252] SQL queries to Oracle stop working
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72252 User oj changed the following: What|Old value |New value Status|RESOLVED |CLOSED --- Additional comments from o...@openoffice.org Tue Jul 6 05:39:22 + 2010 --- 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 72252] SQL queries to Oracle stop working
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72252 User oj changed the following: What|Old value |New value Status|REOPENED |RESOLVED Resolution| |WORKSFORME --- Additional comments from o...@openoffice.org Tue Jul 6 05:38:55 + 2010 --- Tested in a DEv300_m84 and it works. Please add a description how to reproduce it, when it still occurs. - 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 72252] SQL queries to Oracle stop working
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72252 User mba changed the following: What|Old value |New value Target milestone|OOo 2.2 |--- --- Additional comments from m...@openoffice.org Mon May 25 13:27:54 + 2009 --- Assigning no target for now. Someone in the know should find correct one. The current one definitely isn't. - 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 72252] SQL queries to Oracle stop working
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72252 --- Additional comments from [EMAIL PROTECTED] Fri Sep 19 20:53:12 + 2008 --- Hi! Thanks for your suggestion, but this don´t solve the real problem. We need to save the queries correctly and, at this moment, the option "Use keyword AS before table alias names" simply don´t work. It´s a real bug and not a case of using other alternative. Thanks, Gustavo Pacheco. - 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 72252] SQL queries to Oracle stop working
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72252 --- Additional comments from [EMAIL PROTECTED] Wed Aug 13 19:13:11 + 2008 --- Using the "Run SQL command directly" I found that it doesn't matter if you use the SELECT t.dummy FROM table t; or SELECT t.dummy FROM table AS t; enclosing the t with " " or not. - 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 72252] SQL queries to Oracle stop working
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72252 User ace_dent changed the following: What|Old value |New value Status|CLOSED|REOPENED Resolution|FIXED | --- Additional comments from [EMAIL PROTECTED] Wed Aug 6 07:11:12 + 2008 --- Re-openining. - 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 72252] SQL queries to Oracle stop working
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72252 --- Additional comments from [EMAIL PROTECTED] Tue Aug 5 06:47:39 + 2008 --- Hi. I have the same problem on : Ubuntu 8.04 - the Hardy Heron OpenOffice.org 2.4.1. Oracle JDBC - ojdbc14.jar It does not matter if I use database type "Oracle JDBC" or "JDBC" or use "Use keyword AS before table alias names" or not. It still give a error : SQL Status: 42000 Error code: 933 ORA-00933: SQL command not properly ended The SQL command leading to this error is: SELECT "STATE", "POZNAMKA_AR" FROM "ERTTEST"."AKADEMICKY_ROK_KS" AS "AKADEMICKY_ROK_KS" Thanks ! Tomas D. - 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 72252] SQL queries to Oracle stop working
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72252 User gbpacheco changed the following: What|Old value |New value CC|''|'gbpacheco' --- Additional comments from [EMAIL PROTECTED] Tue Jul 29 16:18:52 + 2008 --- Hi! unfortunatelly, I found this issue in OpenOffice.org 2.4.1. I tested two cases: 1) Oracle connection - Windows XP SP2 with Driver Microsoft ODBC for Oracle 2.575.1117.00. 2) Microsoft Access connection - Windows XP SP2 with Microsoft Access ODBC 4.00.6305.00. In the second case, the option "Use keyword AS before table alias names" to "Edit/Database/Advanced Settings/Special Settings" works fine. When the user edit the SQL statement, then AS is suppress or not, in accordance with the option. But in the first case (the Oracle connection), the option "Use keyword AS before table alias names" don´t work. The AS in statement isn´t suppressed. Someone can confirm this with Oracle ODBC driver? If yes, is possible reopen this issue? Thanks! Gustavo Pacheco - 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 72252] SQL queries to Oracle stop working
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72252 User msc changed the following: What|Old value |New value Status|RESOLVED |VERIFIED --- Additional comments from [EMAIL PROTECTED] Wed Dec 13 05:14:58 -0800 2006 --- verified in cws dba22ui 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=SRC680%2Fdba22ui - 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 72252] SQL queries to Oracle stop working
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72252 User fs changed the following: What|Old value |New value Target milestone|OOo 2.x |OOo 2.2 --- Additional comments from [EMAIL PROTECTED] Mon Dec 11 01:47:17 -0800 2006 --- targeting to 2.2, since the fix is part of a CWS aiming for this release - 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 72252] SQL queries to Oracle stop working
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72252 User fs changed the following: What|Old value |New value Assigned to|fs|msc --- Additional comments from [EMAIL PROTECTED] Wed Dec 6 04:41:52 -0800 2006 --- fs-> msc: please verify in CWS dba22ui - 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 72252] SQL queries to Oracle stop working
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72252 User fs changed the following: What|Old value |New value Status|STARTED |RESOLVED Resolution| |FIXED --- Additional comments from [EMAIL PROTECTED] Wed Dec 6 00:47:13 -0800 2006 --- Fixed in CWS dba22ui Added a new option "Use keyword AS before table alias names" to "Edit / Database / Advanced Settings / Special Settings". When unchecked (default is checked), then AS will be supppressed when generating statements. Spec at http://dba.openoffice.org/specifications/Data_Source_Property_Dialog.sxw has been adjusted accordingly. - 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 72252] SQL queries to Oracle stop working
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72252 --- Additional comments from [EMAIL PROTECTED] Mon Dec 4 07:00:50 -0800 2006 --- try http://download.openoffice.org/2.0.3/contribute.html?product=OpenOffice.org&os=win&lang=en&version=2.0.3 - this is the 2.0.4 ULR, with version numbers replaced. Other than that, I do not know. - 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 72252] SQL queries to Oracle stop working
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72252 --- Additional comments from [EMAIL PROTECTED] Mon Dec 4 06:20:32 -0800 2006 --- thank you very much for your time and support. BTW, I cannot find anymore v2.0.3. Is there a repository where I can download it ? kind regards, -GianLuca - 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 72252] SQL queries to Oracle stop working
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72252 User fs changed the following: What|Old value |New value Status|NEW |STARTED --- Additional comments from [EMAIL PROTECTED] Mon Dec 4 06:12:54 -0800 2006 --- Yes, something changed, that's why I set the "regression" keyword: In 2.0.3, we spared the "AS" keyword, when we generated the SQL statement (it's re-generated on various occasions, sometimes even if not necessary). In 2.0.4, we always generate it. Sorry that this caused trouble with Oracle, I wasn't aware of it not knowing this (perfectly valid) syntax. We will introduce some per-database option to switch of the generation of AS. Unfortunately, this will be too late for 2.1. - 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 72252] SQL queries to Oracle stop working
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72252 --- Additional comments from [EMAIL PROTECTED] Mon Dec 4 05:30:33 -0800 2006 --- something must have changed from 2.0.3 to 2.0.4, because the same queries do not work anymore. - 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 72252] SQL queries to Oracle stop working
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72252 User fs changed the following: What|Old value |New value Assigned to|dbaneedsconfirm |fs Ever confirmed| |1 Status|UNCONFIRMED |NEW Keywords| |regression OS/Version|Windows XP|All Target milestone|not determined|OOo 2.x --- Additional comments from [EMAIL PROTECTED] Mon Dec 4 04:16:18 -0800 2006 --- SQL-99 (perhaps also earlier version) allow table_reference ::= ... | [ [AS] ] | ... So, this is valid SQL. Nonetheless, if Oracle doesn't support this notation, we should allow to switch off the generation of AS. This option would be used automatically when creating new .odbs for Oracle databases, and would need a small manual interaction for existing .odbs. - 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 72252] SQL queries to Oracle stop working
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=72252 Issue #|72252 Summary|SQL queries to Oracle stop working Component|Database access Version|OOo 2.0.4 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|glsarto --- Additional comments from [EMAIL PROTECTED] Mon Dec 4 03:33:58 -0800 2006 --- Windows XP Sp2 - Oracle ODBC driver 10.02.00.01 - OpenOffice 2.0.4 Oracle Database 10g Release 10.2.0.1.0 - 64bit Production Queries that worked fine with OO 2.0.3 stop working with 2.0.4 update and report Oracle error 933 Oracle support reports: SELECT DUMMY FROM DUAL AS FOO is invalid syntax - AS identifies an alternative name for a column, not a table. This correctly fails with ORA-933. - 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]
