[dba-issues] [Issue 85792] no links between views
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85792 Issue #|85792 Summary|no links between views Component|Database access Version|OOo 2.3.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|jbu Reported by|viandor --- Additional comments from [EMAIL PROTECTED] Fri Feb 1 10:10:35 + 2008 --- In postgres, i have the following tables/views structure: - CREATE TABLE T1 ( ID_T1 serial NOT NULL, INFO varchar(50) NOT NULL, CONSTRAINT PK_T1 PRIMARY KEY (ID_T1) ) CREATE TABLE T2 ( ID_T2 serial NOT NULL, ID_T1 int4 NOT NULL, INFO varchar(50) NOT NULL, CONSTRAINT PK_T2 PRIMARY KEY (ID_T2), CONSTRAINT FK_T2_T1 FOREIGN KEY (ID_T1) REFERENCES T1 (ID_T1) ); CREATE VIEW v_t1 AS SELECT * FROM T1; CREATE VIEW v_t2 AS SELECT * FROM T2; - I'm building a request with OooBase. If i select T1 and T2, links (relations) between tables are OK (t2.id_t1 = t1.id_t1). If i select v_t1 and v_t2, OooBase don't "guess" the links between the two views. By comparison, it does work with MS-Access. We are really bored, because we can't use OooBase without the capacity to show (auto-detect) links between views. Is there any way to autodetect links between views (i mean we don't want to manually create links, because our database is too big)?. Could it be a new feature, an enhancement? Any help / reply appreciated. [Ooo 2.3.1 + SDBC 0.7.5 + postgresql 8.2 - on windows XP] - 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 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78988 --- Additional comments from [EMAIL PROTECTED] Mon Sep 3 12:30:15 + 2007 --- Thanks for the tips! ;-) - 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 78988] Date queries add braces ar ound dates, causing an error
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=78988 --- Additional comments from [EMAIL PROTECTED] Fri Aug 31 08:11:59 + 2007 --- Do we have any news / clues? This is a bug for SDBC driver postgres or OpenOffice Base? All of them? Is it easy, hard, impossible to resolve? Thanks for any information... :-) - 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 80901] bad SQL for left-outer-joi n
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80901 --- Additional comments from [EMAIL PROTECTED] Wed Aug 22 07:26:48 + 2007 --- Thanks for the tip, it works indeed. Is it possible to resolve the issue when "OJ syntax" is enabled with SDBC for postgres? Or is it possible to uncheck this option if this driver is used, by default? - 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 80904] single quote in restrictio n
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80904 --- Additional comments from [EMAIL PROTECTED] Tue Aug 21 16:11:17 + 2007 --- Created an attachment (id=47691) Single quote in a request - 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 80904] single quote in restrictio n
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=80904
Issue #|80904
Summary|single quote in restriction
Component|Database access
Version|OOo 2.2.1
Platform|All
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|jbu
Reported by|viandor
--- Additional comments from [EMAIL PROTECTED] Tue Aug 21 16:10:28 +
2007 ---
With SDBC for postgres 0.7.4, when there is a single quote (') in a request
restriction (i.e. myrow = L'arme) the generated SQL seems wrong and an error
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: [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 80901] bad SQL for left-outer-joi n
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80901 --- Additional comments from [EMAIL PROTECTED] Tue Aug 21 15:49:52 + 2007 --- Yes, it works when the OJ syntax is disabled! But it should work anyway, with or without the option, no? - 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 80894] can't scroll to the right
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80894 --- Additional comments from [EMAIL PROTECTED] Tue Aug 21 15:43:04 + 2007 --- No there's several hidden 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]
[dba-issues] [Issue 80901] bad SQL for left-outer-joi n
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80901 --- Additional comments from [EMAIL PROTECTED] Tue Aug 21 13:01:54 + 2007 --- Created an attachment (id=47679) Bad SQL with a left-outer-join - 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 80901] bad SQL for left-outer-joi n
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=80901
Issue #|80901
Summary|bad SQL for left-outer-join
Component|Database access
Version|OOo 2.2.1
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|jbu
Reported by|viandor
--- Additional comments from [EMAIL PROTECTED] Tue Aug 21 13:00:59 +
2007 ---
I am using postgresql-sdbc-driver 0.7.4.
When i build a request with a different link between two tables than the default
link (i.e. a left-outer-join), the generated SQL is wrong and i get an error.
The generated SQL is :
SELECT "intrant_intervention"."volume", "intervention"."description" FROM { OJ
"public"."intrant_intervention" LEFT OUTER JOIN "public"."intervention" ON
"intrant_intervention"."id_intervention" = "intervention"."id_intervention" }
It should be :
SELECT "intrant_intervention"."volume", "intervention"."description" FROM
"public"."intrant_intervention" LEFT OUTER JOIN "public"."intervention" ON
"intrant_intervention"."id_intervention" = "intervention"."id_intervention"
-
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 80900] bad SQL for dates
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80900 --- Additional comments from [EMAIL PROTECTED] Tue Aug 21 12:46:37 + 2007 --- Created an attachment (id=47677) Bad SQL with a date - 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 80900] bad SQL for dates
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=80900
Issue #|80900
Summary|bad SQL for dates
Component|Database access
Version|OOo 2.2.1
Platform|PC
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|jbu
Reported by|viandor
--- Additional comments from [EMAIL PROTECTED] Tue Aug 21 12:45:20 +
2007 ---
I am using postgresql-sdbc-driver 0.7.4.
When i execute a request with a date restriction, the generated SQL statement is
wrong and i have an error.
For example, it generates :
SELECT "myrow" FROM "public"."mytable" WHERE ( ( "mydate" > {D '2005-08-17' } )
)
Whereas it should do, for example:
SELECT "myrow" FROM "public"."mytable" WHERE ( ( "mydate" >
TO_DATE('2005-08-17','-MM-DD') ) )
-
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 80894] can't scroll to the right
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80894 --- Additional comments from [EMAIL PROTECTED] Tue Aug 21 12:24:13 + 2007 --- Created an attachment (id=47674) no scrollbar - 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 80894] can't scroll to the right
To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=80894 Issue #|80894 Summary|can't scroll to the right Component|Database access Version|OOo 2.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|viandor --- Additional comments from [EMAIL PROTECTED] Tue Aug 21 12:16:41 + 2007 --- When i try to update an already saved request, i can't scroll to the right in order to see hidden 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]
