Opened 12 years ago

Closed 12 years ago

#18317 closed Bug (fixed)

Raw sql in regressiontests.model_fields.tests.BooleanFieldTests.test_return_type fails with mssql

Reported by: Michael Manfre Owned by: nobody
Component: Testing framework Version: dev
Severity: Normal Keywords:
Cc: Triage Stage: Accepted
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: yes
Easy pickings: no UI/UX: no

Description

MSSQL calls its user LENGTH function, LEN.

Attachments (1)

django-ticket18317.diff​ (1.1 KB ) - added by Michael Manfre 12 years ago.
Adjusts raw SQL depending on connection vendor.

Download all attachments as: .zip

Change History (3)

by Michael Manfre, 12 years ago

Attachment: django-ticket18317.diff​ added

Adjusts raw SQL depending on connection vendor.

comment:1 by Anssi Kääriäinen, 12 years ago

Patch needs improvement: set
Triage Stage: Unreviewed → Accepted

I support the idea of allowing the tests to pass on different backends than the core backends.

I am not sure if checking the connection vendor is the right thing to do. Usually we use some connection.ops.sql_for_string_len(), but as this is used just in testing, that does seem wrong approach, too.

How about using something else than LEN() there? It doesn't seem to matter what function is used in there (in fact, you don't need any function in there, right?). So, just get rid of the LEN() call altogether.

comment:2 by Anssi Kääriäinen <akaariai@…>, 12 years ago

Resolution: → fixed
Status: new → closed

In [459c3b67b7a9aeb96c9a2d57b18c0987c02f2369]:

Fixed #18317 -- Removed db specific raw SQL function from tests

A test in model_fields used LEN() in raw SQL. This function is not
available on some 3rd party backends. I removed this function and
ensured that the test works correctly (breaks pre e9bbdb39de) with
the change.

Note: See TracTickets for help on using tickets.
Back to Top