Moti Asayag has posted comments on this change. Change subject: core: Task Manager Add Tables ......................................................................
Patch Set 3: (1 inline comment) .................................................... File backend/manager/dbscripts/upgrade/03_01_0210_add_job_subject_entity_table.sql Line 13: CONSTRAINT pk_jobs_subject_entity PRIMARY KEY(job_id,entity_id) The pk was changed to job_id and entity_id, as the behaviour described in previous comment(on patch set 2). The retrieval of the third column from 3 columns table which its index is on 3 fields doesn't fetch the value from the index itself if it is PK is relevant for secondary index, not for primary key. The explain plan of the select statement is the same. -- To view, visit http://gerrit.ovirt.org/1083 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: comment Gerrit-Change-Id: Ib662f58d8a739b1fa44f4c4ec25f053923178fc0 Gerrit-PatchSet: 3 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Moti Asayag <[email protected]> Gerrit-Reviewer: Eli Mesika <[email protected]> Gerrit-Reviewer: Itamar Heim <[email protected]> Gerrit-Reviewer: Moti Asayag <[email protected]> Gerrit-Reviewer: Yair Zaslavsky <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
