Почему из
X++:
        ret = (select firstOnly startDate from UKS_VillageTask
            where UKS_VillageTask.VillageID == this.VillageID
                  &&
                  UKS_VillageTask.TaskType == _type
        ).startDate;получается вот такой SQL?
Код:
SELECT A.VILLAGEID,A.TASKTYPE,A.STARTDATE,A.ENDDATE,A.ENABLED,A.MODIFIEDDATE,A.MODIFIEDTIME,A.MODIFIEDBY,A.MODIFIEDTRANSACTIONID,A.CREATEDDATE,A.CREATEDTIME,A.CREATEDBY,A.CREATEDTRANSACTIONID,A.RECVERSION,A.RECID FROM UKS_VILLAGETASK A WITH( INDEX(I_50984VILLAGETASKIDX)) WHERE ((DATAAREAID=?) AND ((VILLAGEID=?) AND (TASKTYPE=?))) OPTION(FAST 2)
CacheLookup == None