spatial index #5022

New Issue

admin · 2026-01-22T14:56:50+01:00

admin commented

2026-01-22 14:56:50 +01:00

Originally created by @collmomo on GitHub (Feb 24, 2016).

There's no mention of this in the documentation
CREATE SPATIAL INDEX sp_index ON geom (g);
https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html

Originally created by @collmomo on GitHub (Feb 24, 2016). There's no mention of this in the documentation `CREATE SPATIAL INDEX sp_index ON geom (g);` https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html

admin closed this issue

2026-01-22 14:56:50 +01:00

admin commented

2026-01-22 14:56:51 +01:00

@Ocramius commented on GitHub (Feb 24, 2016):

Spatial indexes are engine-specific. We do not support them in core.
On Feb 24, 2016 03:50, "collmomo" notifications@github.com wrote:

There's no mention of this in the documentation
CREATE SPATIAL INDEX sp_index ON geom (g);
https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html

—
Reply to this email directly or view it on GitHub
https://github.com/doctrine/doctrine2/issues/5678.

@Ocramius commented on GitHub (Feb 24, 2016): Spatial indexes are engine-specific. We do not support them in core. On Feb 24, 2016 03:50, "collmomo" notifications@github.com wrote: > There's no mention of this in the documentation > CREATE SPATIAL INDEX sp_index ON geom (g); > https://dev.mysql.com/doc/refman/5.7/en/creating-spatial-indexes.html > > — > Reply to this email directly or view it on GitHub > https://github.com/doctrine/doctrine2/issues/5678.

admin commented

2026-01-22 14:56:51 +01:00

@collmomo commented on GitHub (Feb 24, 2016):

I don't know what that means but I found the documentation here http://doctrine-orm.readthedocs.org/projects/doctrine-orm/en/latest/changelog/migration_2_5.html

@collmomo commented on GitHub (Feb 24, 2016): I don't know what that means but I found the documentation here http://doctrine-orm.readthedocs.org/projects/doctrine-orm/en/latest/changelog/migration_2_5.html

admin commented

2026-01-22 14:56:52 +01:00

@octaharon commented on GitHub (Oct 13, 2017):

But you support engine-specific "Options" still, don't you?
http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/annotations-reference.html#annref-index
So there's an obvious contradiction.
Also since "index" annotation has an undocumented "flags" property, it could be super easy to provide

Do you possibly have a recipe on how I can still have spatial indexes in my DB?

I'm not saying that you should support engine-specific things, but I don't see any real way of having a spatial index now without creating a shitlload of code which intercepts all of doctrine table-related events, circumvents sql generator and so on, while for the result I only need to add just one word to the query. That's completely bizarre

@octaharon commented on GitHub (Oct 13, 2017): But you support engine-specific "Options" still, don't you? http://docs.doctrine-project.org/projects/doctrine-orm/en/latest/reference/annotations-reference.html#annref-index So there's an obvious contradiction. Also since "index" annotation has an undocumented "flags" property, it could be super easy to provide Do you possibly have a recipe on how I can still have spatial indexes in my DB? I'm not saying that you _should_ support engine-specific things, but I don't see any real way of having a spatial index now without creating a shitlload of code which intercepts all of doctrine table-related events, circumvents sql generator and so on, while for the result I only need to add just *one word* to the query. That's completely bizarre

Sign in to join this conversation.

Branches Tags

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: doctrine/archived-orm#5022