Good suggestion. The generated query now is correct: FROM User d0_ INNER JOIN Blacklist d1_ ON (d0_.email= d1_.email)
Thank you -- On Sunday, January 26, 2014 9:17:15 PM UTC+1, Marco Pivetta wrote: > > Could you try this with current DBAL and ORM master? There has been some > work around this as far as I know... > > Marco Pivetta > > http://twitter.com/Ocramius > > http://ocramius.github.com/ > > > On 26 January 2014 20:49, Giuseppe Attardi <[email protected] <javascript:> > > wrote: > >> I am using a query like this one: >> >> >> $query = $em->createQuery('SELECT u FROM User u JOIN Blacklist b WITH >> u.email = b.email'); >> >> >> from >> http://docs.doctrine-project.org/en/latest/reference/dql-doctrine-query-language.html >> >> >> >> The SQL code generated has an extra WITH clause that causes error 319 on MS >> SqlServer, i.e. >> >> SELECT * >> FROM User d0_ WITH (NOLOCK) INNER JOIN Blacklist d1_ >> ON (d0_.email= d1_.email) >> >> SQLSTATE[HY000]: General error: 319 General SQL Server error: Check messages >> from the SQL Server [319] (severity 15) >> >> >> I am running version 2.4 >> >> Any help appreciated. >> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "doctrine-user" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected] <javascript:>. >> To post to this group, send email to [email protected]<javascript:> >> . >> Visit this group at http://groups.google.com/group/doctrine-user. >> For more options, visit https://groups.google.com/groups/opt_out. >> > > -- You received this message because you are subscribed to the Google Groups "doctrine-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/doctrine-user. For more options, visit https://groups.google.com/groups/opt_out.
