Altering Unique, nullable field to Non-nullable

[dcleveng]

This has been an on-going issue with the Django MSSQL backend. I've experienced it on more than one occasion in my own code and third party modules, the most recent occurring when attempting to integrating djangorestframework-api-key into an existing project.

Running migrations on the newly installed module results in the following failure:

django.db.utils.ProgrammingError: ('42S11', "[42S11] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The operation failed because an index or statistics with name 'rest_framework_api_key_apikey_prefix_4e0db5f8_uniq' already exists on table 'rest_framework_api_key_apikey'. (1913) (SQLExecDirectW)")

On closer inspection one of the migrations is altering a field from unique=True, null=True to a unique nullable field. Typically, if I run into this issue in my own code, I'll just work around it and make the necessary changes. In this case, I'm concerned about future compatibility issues with the djangorestframework-api-key down the road if I make those changes myself.

Some additional info from the forked project can be found here: ESSolutions/django-mssql-backend#77

[absci]

Thanks for this report, we will review the issue and existing PR from ESSolutions/django-mssql-backend#77.

[lendenmc]

Thanks for this report, we will review the issue and existing PR from ESSolutions/django-mssql-backend#77.

Hello, any plan any time soon for the existing PR ? I am also running into the same error within the same context:

django.db.utils.ProgrammingError: ('42S11', "[42S11] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]The operation failed because an index or statistics with name 'rest_framework_api_key_apikey_prefix_8i9pw3z1_uniq' already exists on table 'rest_framework_api_key_apikey'. (1913) (SQLExecDirectW)")

[massoudrahimzadeh]

I have the same issue, following..

[jmah8]

This issue should be fixed by PR #163. I am going to close this issue but if you are still having the same issue feel free to reopen this issue.