Indexing wont work with = 1 or = true

[jensstalder]

MySQL expects there to be no literal.

$qb->andWhere("ST_Intersects(node.polygon, mainnode.polygon) = true");

This works but the spacial index wont be used!

And this is not valid dql.

$qb->andWhere("ST_Intersects(node.polygon, mainnode.polygon)");

... Error: Expected Literal, ...

Do you have an idea if that can get fixed? or is there a workaround?

[yurtesen]

No, there is no workaround to this. It is related to doctrine syntax checker. See this.

In addition, this issue is probably related to MySQL also because I just checked and PostgreSQL uses index. I actually switched to PostgreSQL due to MySQL's spatial support being so weak.