Issue 21300 - Quoting in (JDBC generated)SQL does not work in Sybase (#20536 part 1)
Summary: Quoting in (JDBC generated)SQL does not work in Sybase (#20536 part 1)
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC5
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: ocke.janssen
QA Contact: issues@dba
URL:
Keywords:
: 12742 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-10-16 08:37 UTC by jaapbril
Modified: 2013-08-07 15:45 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description jaapbril 2003-10-16 08:37:06 UTC 
I'm trying RC5 against a Sybase 12.5 release on Linux (a production database).
OOo seems to be configured to quote all parts of a statement;
select "firstkey" from "jaap"."dbo"."first" "first" 

This produces the error:
"jaap"."dbo"."first" not found. specify owner.objectname or use sp_help[....].

If I force (default the view gets quoted) a view on jaap.dbo.first, the table is
accessible.


This behaviour seems to be consistent;
I tried opening tables, writing views, creating forms..

This behaviour makes OOo unuseable with Sybase. I can't find away to configure
this behaviour so :
Is it configurable? 
If not I think this is a defect or at least a needed enhancement.

Jaap Bril
Comment 1 marc.neumann 2003-10-31 12:51:48 UTC 
Hi Ocke,

As far as I know it's OK to quote all schema, catalog table on a
datasource . f.e. with a ms sql server database this works.
I can't reproduce it with a sybase database because my database has
only a schema and the table name (no catalog).

Is there anything we can do to fix this? May be provide a new setting
for a datasource or something else.

If not I would say we close this issue as invalid.

Bye Marc
Comment 2 jaapbril 2003-11-04 08:38:19 UTC 
I put the issue to Sybase;
The quoting as done by OOo has never been seen by my contact; but he
will ask around.
BTW The problem occurs in the SQL-parser so (as Sybase reads them)
this way of quoting is outside the SQL-specs.
I would like to be sure one way or the other. Which (version of the)
specs are being used?

Jaap
Comment 3 marc.neumann 2003-11-12 15:47:23 UTC 
*** Issue 12742 has been marked as a duplicate of this issue. ***
Comment 4 hans_werner67 2004-02-02 12:33:56 UTC 
change subcomponent to 'none'
Comment 5 ocke.janssen 2004-05-26 08:36:00 UTC 
Hi Jaap,

would it be okay for you, when the user is allowed to turn off the use of the
catalog name and/or the schema name too. So in that case only the parts which
are not turned off will be  quoted?

You may have a look at the spec for the new database property dialog
http://dba.openoffice.org/specifications/Data_Source_Property_Dialog.sxw

Best regards,

Ocke

PS: If the answer is "yes", you may close this issue.
Comment 6 ocke.janssen 2011-02-01 12:52:15 UTC 
Set to fixed and closing this issue.
Comment 7 ocke.janssen 2011-02-01 12:52:32 UTC 
.