function test_pkey()
{
echo "<h4>Test search on pkey</h4>";
$sExpr1 = "SELECT cmdbContact WHERE id IN (40, 42)";
$sExpr2 = "SELECT cmdbContact WHERE IN NOT IN (40, 42)";
$this->search_and_show_list_from_oql($sExpr1);
$this->search_and_show_list_from_oql($sExpr2);
echo "Et maintenant, on fusionne....</br>\n";
$oSet1 = new CMDBObjectSet(DBObjectSearch::FromOQL($sExpr1));
$oSet2 = new CMDBObjectSet(DBObjectSearch::FromOQL($sExpr2));
$oIntersect = $oSet1->CreateIntersect($oSet2);
$oDelta = $oSet1->CreateDelta($oSet2);
$oMerge = clone $oSet1;
$oAppend->Append($oSet2);
$oAppend->Append($oSet2);
echo "Set1 - Found " . $oSet1->Count() . " items.</br>\n";
echo "Set2 - Found " . $oSet2->Count() . " items.</br>\n";
echo "Intersect - Found " . $oIntersect->Count() . " items.</br>\n";
echo "Delta - Found " . $oDelta->Count() . " items.</br>\n";
echo "Append - Found " . $oAppend->Count() . " items.</br>\n";
//$this->show_list($oObjSet);
}
