the sql generated in django

Question

when i print the sql generated in connection.queries:

i found some sql like this:

SELECT (1) AS `a` FROM `auth_user` WHERE `auth_user`.`id` = 2 

what's that mean?

Answer 1

It's used to check if that row exists, without actually fetching any data (constructed by django.db.models.sql.query.BaseQuery.has_results, called by e.g. QuerySet.exists).