Issue 28341 - DROP INDEX always has a schema name before the index name
Summary: DROP INDEX always has a schema name before the index name
Status: CLOSED FIXED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: ocke.janssen
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-04-25 08:50 UTC by chw
Modified: 2010-11-10 15:55 UTC (History)
1 user (show)

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

Attachments
Patch file (1.26 KB, patch)
2004-04-27 14:39 UTC, ocke.janssen 		no flags Details | Diff
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 chw 2004-04-25 08:50:54 UTC 
It is not possible to drop an index on a database which does
not support schemas, because the dba component always formats
the DROP INDEX SQL statement like

    DROP INDEX "schema"."indexname" ...

As for CREATE INDEX there should be some logic in 
.../connectivity/source/commontools/TIndexes.cxx
which takes the capabilities of the underlying data
source into account regarding support of catalog/schema
name parts in index definitions.
Comment 1 marc.neumann 2004-04-27 14:02:44 UTC 
Hi, 

Something for you.

Bye Marc
Comment 2 ocke.janssen 2004-04-27 14:38:36 UTC 
Hi,

huh, somebody found the code :-)

I'll attach a fix for this one.

Thanks.

Best regards,

Ocke
Comment 3 ocke.janssen 2004-04-27 14:39:44 UTC 
Created attachment 14807 [details]
Patch file
Comment 4 marc.neumann 2004-05-12 09:11:58 UTC 
hi Ocke,

which database do you use for testing this issue.

Bye Marc
Comment 5 ocke.janssen 2004-05-12 10:34:47 UTC 
I verified the code :-) and used MySQL and correct the metadata to not support
schema.

Best regards,

Ocke
Comment 6 marc.neumann 2004-06-15 12:28:58 UTC 
verify in cws by verifing the code, too.
Comment 7 ocke.janssen 2004-09-06 11:56:17 UTC 
.
Comment 8 constencate 2010-11-10 15:55:11 UTC 
Created attachment 73026