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.
