Uh oh!
There was an error while loading.Please reload this page.
- Notifications
You must be signed in to change notification settings - Fork7k
Open
Description
I have some questions regarding the following code snippet:
model=PrimaryKeyRelatedField(pk_field=IntegerField(),queryset=MachineModel.objects.filter(active=True),many=True,required=True,)
WhenPrimaryKeyRelatedField is set withmany=True, it generates these queries. It seems like they are not using join.
SELECT"api_application_machinemodel"."id","api_application_machinemodel"."brand_id","api_application_machinemodel"."name","api_application_machinemodel"."description","api_application_machinemodel"."active"FROM"api_application_machinemodel"WHERE ("api_application_machinemodel"."active"AND"api_application_machinemodel"."id"=1)LIMIT21; args=(1,); alias=defaultSELECT"api_application_machinemodel"."id","api_application_machinemodel"."brand_id","api_application_machinemodel"."name","api_application_machinemodel"."description","api_application_machinemodel"."active"FROM"api_application_machinemodel"WHERE ("api_application_machinemodel"."active"AND"api_application_machinemodel"."id"=2)LIMIT21; args=(2,); alias=defaultSELECT"api_application_machinemodel"."id","api_application_machinemodel"."brand_id","api_application_machinemodel"."name","api_application_machinemodel"."description","api_application_machinemodel"."active"FROM"api_application_machinemodel"WHERE ("api_application_machinemodel"."active"AND"api_application_machinemodel"."id"=3)LIMIT21; args=(3,); alias=defaultSELECT"api_application_machinemodel"."id","api_application_machinemodel"."brand_id","api_application_machinemodel"."name","api_application_machinemodel"."description","api_application_machinemodel"."active"FROM"api_application_machinemodel"WHERE ("api_application_machinemodel"."active"AND"api_application_machinemodel"."id"=4)LIMIT21; args=(4,); alias=defaultSELECT"api_application_machinemodel"."id","api_application_machinemodel"."brand_id","api_application_machinemodel"."name","api_application_machinemodel"."description","api_application_machinemodel"."active"FROM"api_application_machinemodel"WHERE ("api_application_machinemodel"."active"AND"api_application_machinemodel"."id"=5)LIMIT21; args=(5,); alias=default
Is this behavior a bug, or is it expected not to use join?
Metadata
Metadata
Assignees
Labels
No labels