Ticket #214 (closed defect: fixed)

Opened 10 months ago

Last modified 2 months ago

1.8 midgard-schema creates indexes incorrectly

Reported by: rambo Assigned to: piotras
Priority: major Milestone: 1.8 Thor
Component: Midgard Core Version: 1.8 Thor
Keywords: Cc:

Description

it uses "ALTER TABLE <table_name> ADD KEY(<column_name>);" which causes a new index to be created each time midgard-schema is run, change to use "CREATE INDEX <column_name>_idx ON <table_name> (<column_name>);", which will complain about duplicate index name.

Change History

02/11/08 13:52:08 changed by piotras

  • status changed from new to closed.
  • resolution set to fixed.

(In [14845]) Added default FALSE is_linked member to type property struct. Removed some unused key and indexes and added colname_idx convention to have as many indexes as needed. Fix #193 Fix #214 Fix #78 Ported some database related routines from 1-9 branch

09/30/08 14:57:43 changed by bergie

  • milestone set to 1.8 Thor.