Opened 9 years ago

Closed 9 years ago

Last modified 9 years ago

#25416 closed Uncategorized (invalid)

Queries are displayed without values quoted

Reported by: Jimmy Merrild Krag Owned by: nobody
Component: Database layer (models, ORM) Version: 1.8
Severity: Normal Keywords:
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

I am debugging some queries, and noticed an error in how my queries are printed.
What I did in my code, was:

query_set = ModelClass.objects.filter([other_filters]).exclude(field='')

The query_set.query then contains somthing like:

SELECT [columns] FROM [table] WHERE [other_filters] AND NOT ([table].field = ))

The QuerySet works, but note that there are no quotes around the empty string value.

I tried with a value instead, which also does not get quoted. Even if it contains spaces.
The issue is the same if I use .filter() instead of .exclude().

Change History (2)

comment:1 by Simon Charette, 9 years ago

Resolution: needsinfo
Status: newclosed

Hi beruic,

The string representation of a Query is not meant to be valid SQL, it is solely provided for introspection means.

Were you using this private API in order to generate SQL to execute your query manually?

comment:2 by Jimmy Merrild Krag, 9 years ago

Resolution: needsinfoinvalid

I don't know why my replies does not show here, so now I try a straight comment instead:

I recon that I have misinterpreted the purpose of query_set.query, and this ticket is thus invalid.

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