Bvb_Grid_Source_Zend_Select->getAutoCompleteForFilter

What steps will reproduce the problem?
1. Create a new DataGrid
2. Setting the source for new DataGrid: $grid->setSource($source);
Where source must be a select with two or more nested 'where' clauses on this 
way:
$select = $this->select(false)
     ->from(array("PC" => "mytable"), array("id", "field1", "field2"))
     ->where('firstClause')
     ->where('secondClause');
3. Setting some datagrid field 'someField' to 'autocomplete': 
$grid->listenEvent('grid.init_deploy', array($this, 'AddAutoCompleteToFields'));

What is the expected output? 
Autocomplete working correctly

What do you see instead?
exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access 
violation: 1064 You have an error in your SQL syntax; check the manual that 
corresponds to your MySQL server version for the right syntax to use near 'AND 
(secondClause)) AND (someField LIKE '%p%') ORDER BY `something'

Please insert the appropriate values;
                    Zend Framework version: 1.11.6
ZFDatgrid Version (Bvb_Grid::getVersion()): 0.8
                          Operating system: Windows XP
                               PHP Version: 5.3
               Database Server and version: MySQL 5.1.56
                          Source Adatapter: Zend_Db_Adapter_Abstract->query(Object(Zend_Db_Table_Select), Array)

Please provide any additional information below.

Original issue reported on code.google.com by smiranda...@gmail.com on 2 Dec 2011 at 1:55

madcorp / zfdatagrid

Bvb_Grid_Source_Zend_Select->getAutoCompleteForFilter #796