[Fixed] Cut and paste column with index

0 votes
asked Feb 25, 2016 in Solved by jvgamers (350 points)
recategorized Jul 4, 2016 by ludek.vodicka

When i cut and paste from one entity to another one a column, if this column had index i got a bug : index still believes in old entity.

Example :
-- tableA --
columnA
columnB
columnC INDEX(mycolumnindex)
-- tableB --
columnD

I cut and paste columnC from tableA to tableB, directly from the graph view. I got :
-- tableA --
columnA
columnB
INDEX(mycolumnindex)
-- tableB --
columnD
columnC

So, when i export after, i got this issue in Doctrine :
indexes={@ORM\Index(name="mycolumnindex", columns={})}

That cause a Doctrine error which is sometimes hard to find.
Thanks for support!

commented Feb 25, 2016 by ludek.vodicka Skipper developer (140,450 points)

Hi, thanks for report and sorry for this complication. Unfortunately this is currently a correct behavior.

You moved column to another entity, so column was detached from index but empty index (index without columns) remained in original entity. In case that index would contain two columns the index will be still valid.

I think it would be possible to implement behavior where index will be removed when no more columns are attached to it. But in situations when you want to remove one column and add another you will be forced to create completely new index.

We have to check it more deeply and let you know

1 Answer

0 votes
answered Jun 1, 2016 by ludek.vodicka Skipper developer (140,450 points)

This issue is fixed in latest beta 3.2.7.1319 available from our support site:
http://support.skipper18.com/402/downloads-skipper-beta

...