Oracle DB seed database

Description

The Oracle database seed dump in the repository, contains some wrong constraints i.e.:
M_INVENTORYLINEMA_KEY
M_INOUTLINEMA_KEY

I think there are an errors in migration script: 201310141246_IDEMPIERE-386.sql
i.e. there is this
ALTER TABLE M_InOutLineMA DROP CONSTRAINT m_inoutlinema_key
instead of
DROP INDEX M_INOUTLINEMA_KEY;

Best regards

Environment

Oracle XE 11G

Activity

Show:
Dirk Niemeyer
July 28, 2016, 3:02 PM
Edited

I have encountered the same problem.

If I understand correct Oracle is creating also an index when you create a primary key constraint. When you drop the constraint, the index is not droped automatically.

I have attached a migration for Oracle which takes care and works even if you had already manually droped the index.

I think for the future people have just to remember this and take care that besides the constraint they also drop a related index.

WDYT?

Regards,

Dirk Niemeyer

Carlos Ruiz
August 3, 2016, 11:04 AM

Thanks , committed a version with direct DROP because in my tests with syncApplied it didn't work the pl/sql version.

Assignee

Carlos Ruiz

Reporter

Fabio Canella

Labels

None

Tested By

None

Components

Affects versions

Priority

Major
Configure