IX_OrderGroupNote_OrderGroupId Index issue in database schema upd

Calling all developers! We invite you to provide your input on Feature Experimentation by completing this brief survey.

AI OnAI Off

Home / Forums / Developers (Main Products) Forum / Customized Commerce 13 and earlier versions /

IX_OrderGroupNote_OrderGroupId Index issue in database schema update script version 7.0.7

valdis

Vote:

Oringal statement:

IF EXISTS (SELECT name FROM sysindexes WHERE name = 'IX_OrderGroupNote_OrderGroupId')
DROP INDEX IX_OrderGroupNote_OrderGroupId ON [dbo].[OrderGroupNote]
CREATE NONCLUSTERED INDEX [IX_OrderGroupNote_OrderGroupId]
    ON [dbo].[OrderGroupNote]([OrderGroupId] ASC);

GO

Not working very well on SQL Azure. Need to add "." between "sys" and "indexes":

IF EXISTS (SELECT name FROM sys.indexes WHERE name = 'IX_OrderGroupNote_OrderGroupId')
DROP INDEX IX_OrderGroupNote_OrderGroupId ON [dbo].[OrderGroupNote]
CREATE NONCLUSTERED INDEX [IX_OrderGroupNote_OrderGroupId]
    ON [dbo].[OrderGroupNote]([OrderGroupId] ASC);

GO

Production site was down while trying to find this issue :)

#142758

Dec 22, 2015 0:03

Magnus Rahl

Vote:

Thanks for reporting it, I'll register a bug and make sure it is fixed ASAP.

#142759

Dec 22, 2015 7:38

Quan Mai

Vote:

Hi,

Thank you for your feedback. We'll look into this problem.

Regards,

#142760

Dec 22, 2015 7:42

This topic was created over six months ago and has been resolved. If you have a similar question, please create a new topic and refer to this one.