search

spacetelescope / pandokia

Regression tests framework.
Other
2 stars 4 forks source link

Changing unique index in result_scalar table #29

Closed oiintam closed 6 years ago

oiintam commented 6 years ago

Refer to the problem Christine described in pervious PR, we need to shorten the unique index in result_scalar table since it will exceed the limit of InnoDB in some test cases. Therefore, I would like to change the unique index to key_id, which is an auto-incremating field.

cslocum commented 6 years ago

@oiintam have you already altered dystopia?

oiintam commented 6 years ago

@cslocum no, I didn't alter anything in dystopia.

cslocum commented 6 years ago

Then how did you change the indices? This PR modifies the schemas, but you would have had to alter the database to change the indices, right?

oiintam commented 6 years ago

Yes, you're correct. So if we continue to use dystopia, we will need someone that has admin privilege to alter the result_scalar table attribute.

oiintam commented 6 years ago

This is overtaken by events.