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]> 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]. > 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. > -- 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.
