IX_OrderGroupNote_OrderGroupId Index issue in database schema upd

Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more

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.