I see the infotip and query to execute ALTER TABLE `blocks` ADD PRIMARY KEY(`theme`(32), `module`, `delta`) in D5 for speed on the sitedoc output. I know whenever I get around to doing a D6 upgrade, I'll forget about having executed such a query, so what will happen when I upgrade? From #164532: Improve table indices for common queries it looks like it was added to D6, so wouldn't the normal core upgrade query conflict and fail then? Is it the same as that primary index anyway?

Comments

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Assigned: Unassigned » nancydru
Status: Active » Closed (works as designed)

That tip is triggered by finding no index on the table. In D6 there is an index, so no message.

deekayen’s picture

deekayen commented

That's not really what I asked. I'm more concerned about what will happen when Drupal core update functions try to apply the index to the table when it already exists.

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented

Ir wasn't a problem on the sites I upgraded.