※2回も先輩に聞いてしまったので、メモします。

zendframeworkで、ＳＱＬを書く際、
なぜか、->joinや->joinLeftが
setIntegrityCheckの制約でエラーになってしまうのでメモ。

        //$select_search=$dao->select()->setIntegrityCheck(false);
        $select_search = $dao->select();
        $select_search->from(array("T"=>"TEST_TABLE"));
	$select_search->joinLeft(array("H"=>"HOGE"),"T.TEST_ID=H.TEST_ID");
        $this->whereTrack($select_search);
        $this->initPaginator($select_search);

↓

        $select_search=$dao->select()->setIntegrityCheck(false);
        //$select_search = $dao->select();
        $select_search->from(array("T"=>"TEST_TABLE"));
	$select_search->joinLeft(array("H"=>"HOGE"),"T.TEST_ID=H.TEST_ID");
        $this->whereTrack($select_search);
        $this->initPaginator($select_search);