Error during insert to linked server via view. about mssql-django HOT 4 CLOSED

From my limited understanding, it looks like it's the by-default enabling of return_rows_bulk_insert that could be the culprit, but setting it to False doesn't have any effect on the query produced. Neither with the code I posted above, nor when using cls.objects.bulk_create(table).

from mssql-django.

Hi @xnick, I think you're correct. We've changed the default value back in the dev branch. Can you try it out there and see if that resolves your issue?

from mssql-django.

Hello, thanks for the suggestion.

I can confirm that the dev build works fine. Just out of curiosity, I enabled return_rows_bulk_insert and the problem appeared again.

Does return_rows_bulk_insert provide a significant speedup? Is it worth it enabling it and overriding this snippet with a custom insert, I wonder?

Thank you!

from mssql-django.

I don't believe there's a performance benefit. The dev build will be released next month with the default value changed back.

from mssql-django.