By design, SQL Azure only support CLUSTERED primary key, and for some reason the engineers at Microsoft decided to trigger an error if you attempt to created a non-clustered primary keys there :)

Because clustered primary keys should work just the same on standard SQL Server, we can just switch all the primary keys to clustered.

CommentFileSizeAuthor
#3 drupalsqlsrvazure.png64.67 KBVFXCode
#1 889068-clustered.patch856 bytesdamien tournoud

Comments

damien tournoud’s picture

damien tournoud commented
Status: Active » Fixed
StatusFileSize
new 889068-clustered.patch856 bytes

Committed the following patch.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

VFXCode’s picture

VFXCode commented
Priority: Normal » Major
Status: Closed (fixed) » Active
StatusFileSize
new drupalsqlsrvazure.png64.67 KB

This doesnt seem to work correctly. I still get this error on install with both of your driver versions (alpha1 & dev).

Screenshot attached.

VFXCode’s picture

VFXCode commented

Hi,
is there any update on this?

Thanks

damien tournoud’s picture

damien tournoud commented
Status: Active » Fixed

There are other issues that currently prevent fully using SQL Azure. One of those is the test table you mentioned, but it is not the only one.

This issue was about switching to CLUSTERED indexes, which has been done. I'm closing back this.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.