microsoft/mssql-django

Errors Running Tests with 1.4.1

dcleveng opened this issue · 5 comments

dcleveng commented

I'm curious if anyone else is seeing issues running tests with the 1.4.1 version. Here is part of the traceback I'm seeing when I run tests on my dev environment and in my pipeline.

  File "/app/.local/lib/python3.11/site-packages/django/db/migrations/migration.py", line 132, in apply
    operation.database_forwards(
  File "/app/.local/lib/python3.11/site-packages/django/db/migrations/operations/fields.py", line 108, in database_forwards
    schema_editor.add_field(
  File "/app/.local/lib/python3.11/site-packages/mssql/schema.py", line 1054, in add_field
    self.execute(sql, params)
  File "/app/.local/lib/python3.11/site-packages/mssql/schema.py", line 1389, in execute
    cursor.execute(sql, params)
  File "/app/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 67, in execute
    return self._execute_with_wrappers(
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/app/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
    return executor(sql, params, many, context)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/app/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 84, in _execute
    with self.db.wrap_database_errors:
  File "/app/.local/lib/python3.11/site-packages/django/db/utils.py", line 91, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/app/.local/lib/python3.11/site-packages/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/app/.local/lib/python3.11/site-packages/mssql/base.py", line 678, in execute
    return self.cursor.execute(sql, params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
django.db.utils.ProgrammingError: ('42000', "[42000] [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Incorrect syntax near 'ae4'. (102) (SQLExecDirectW)")

The - Incorrect syntax near 'ae4' - is different each time, so far, I'm only seeing when running tests. I'm not seeing any other issues during normal operations.

Downgrading to 1.4.0 resolves the issue

paul-eclipse commented

I'm having the same issue. When running tests locally, or via gh actions I get the same error. When running the project normally, everything seems fine.

dauinsight commented

Hi @dcleveng, could you provide the test case and/or query that is throwing the error?

paul-eclipse commented

This issue is fixed for me with the 1.4.2 release.

  • 👍1
dauinsight commented

Hi @dcleveng, we want to confirm with you to see if this issue has been resolved.

dcleveng commented

Yes, thank you. I can confirm tests are passing with 1.4.2.

I apologize for not getting back to you sooner with some of the test cases/examples to help with troubleshooting. Nevertheless, thank you for your quick turnaround time on the issue.

  • 🎉1