i use symfony 1.1 and the trunk from the sfDoctrinePlugin. my problem is that with doctrine alone the Query is extended well (Where deleted = 0 ) but as soon as i try it with the symfony plugin and symfony the 0 in the params part get lost and the query messed up:

i have tried to write a test for doctrine alone but i won't fail only if i use it with symfony.

then i created a new symfony project with only one table:

User:
  columns:
    id:
      primary: true
      autoincrement: true
      type: integer(4)
    username:
      type: string(255)
  actAs:
    SoftDelete:

and tried the query:

    $q = new Doctrine_Query();
    $q->select('u.*')
    ->from('User u')
    ->where('u.id = ?',array(1));
    return $q->fetchOne();

it fails with: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens

[ SELECT u ..... FROM User u WHERE u.id = ? AND s.deleted = ?', array(1) <- see the missing 0 ]

when i revert to [4477] everything works

[4478] breaks it again

thats why i posted it here cause the changes seems to be in doctrine core not in the plugin

the tests i attched are a try to show my performance issue concerning the dqlHooks but i found this first

class Doctrine_Ticket_Tobi_TestCase extends Doctrine_UnitTestCase 
{
  public function prepareTables()
  {
    $this->tables[] = 'Ticket_9999_Style';
    $this->tables[] = 'Ticket_9999_StyleAlias';
    parent::prepareTables();
  }

  public function testTicket()
  {
    $style = new Ticket_9999_Style();
    $style->name = 'test';
    $style->save();
    //$this->conn->clear();
    $style =  Doctrine::getTable('Ticket_9999_Style')->find('1');
    $styleAliases =  $style->Aliases;
    $this->assertEqual($style->name, 'test');
    $this->assertEqual($styleAliases[0]->name, 'test');
    // try again!
    $this->conn->clear();
 
    $q = new Doctrine_Query();
    $q->select('s.*')
    ->from('Ticket_9999_Style s, s.Aliases sa')
    ->where('sa.name = ?', array('test'));
    
    $test =  $q->fetchOne();
    $this->assertEqual($test, 'test');
        
  }
}

class Ticket_9999_Style extends Doctrine_Record
{
  public function setTableDefinition()
  {
    $this->setTableName('style');
    $this->hasColumn('id', 'integer', 4, array('primary' => true, 'notnull' => true, 'autoincrement' => true));
    $this->hasColumn('name', 'string', 255);
    $this->hasColumn('description', 'string', 2147483647);
    $this->hasColumn('style_count', 'integer', 4);
    $this->hasColumn('created_by', 'integer', 4);
    $this->option('type', 'INNODB');
    $this->option('collate', 'utf8_general_ci');
    $this->option('charset', 'utf8');
  }

  public function setUp()
  {
    parent::setUp();
    $this->hasMany('Ticket_9999_StyleAlias as Aliases', array('local' => 'id',
                                                              'foreign' => 'style_id'));

    $timestampable0 = new Doctrine_Template_Timestampable();
    $softdelete0 = new Doctrine_Template_SoftDelete();
    $this->actAs($timestampable0);
    $this->actAs($softdelete0);

  }
  public function preInsert($event)
  {
    $normlized_name = normalizeStyle($this->name);
    $alias = Doctrine::getTable('Ticket_9999_StyleAlias')->findOneByName($normlized_name);
    if($alias instanceof Ticket_9999_StyleAlias){
      $this->getErrorStack()->add('name', '"'.$normlized_name.'" exists already in Ticket_9999_StyleAlias');
      $event->skipOperation();
    }
  }
  
  public function postInsert($event)
  {
    if($this['id']){
      $this->addAlias($this->name);
    }
  } 
  public function addAlias($name)
  {
    $name = normalizeStyle($name);
    $alias = Doctrine::getTable('Ticket_9999_StyleAlias')->findOneByName($name);
    if(!($alias instanceof Ticket_9999_StyleAlias)){
      $alias = new Ticket_9999_StyleAlias();
      $alias->name = $name;
      $alias->style_id = $this['id'];
      $alias->save();   
    }
    return $alias;
  }    
}

class Ticket_9999_StyleAlias extends Doctrine_Record
{
  public function setTableDefinition()
  {
    $this->setTableName('style_alias');
    $this->hasColumn('name', 'string', 255, array('primary' => true, 'unique' => true));
    $this->hasColumn('style_id', 'integer', 4, array('primary' => true));

    $this->option('type', 'INNODB');
    $this->option('collate', 'utf8_general_ci');
    $this->option('charset', 'utf8');
  }

  public function setUp()
  {
    parent::setUp();
    $this->hasOne('Ticket_9999_Style as Style', array('local' => 'style_id',
                                                      'foreign' => 'id'));
  }
}
class Ticket_9999_StyleTable extends Doctrine_Table
{
  public static function findByName($name)
  {
    echo "findByName";
    $q = new Doctrine_Query();
    $q->select('s.*')
    ->from('Ticket_9999_Style s, s.Aliases sa')
    ->where('sa.name = ?');
    return $q->fetchOne(array(normalizeStyle($name)));
  }


}
function normalizeStyle($alias){
  return(strtolower(str_replace(array(',',' ',''','"','`',''','|','-','_'),'',$alias)));
}