No table name escape in ServiceEntityRepository->createQueryBuilder() #6214

New Issue

admin · 2026-01-22T15:29:00+01:00

admin commented

2026-01-22 15:29:00 +01:00

Originally created by @Oihso on GitHub (Mar 31, 2019).

Originally assigned to: @Ocramius on GitHub.

Bug Report

Summary

If you have entity, that named like SQL keyword (Order in my case), you can not use $this->createQueryBuilder('...')->...; because after building the query you get SELECT ... FROM order ... query which always has non-escaped table name. As a result, you cant access table with that name.

How to reproduce

Make entity named like SQL keyword
Build query with $this->createQueryBuilder('...')->...;
Try to execute it

P.S. Not sure, if this 'bug' relates to this repository, and not to doctrine/orm

Originally created by @Oihso on GitHub (Mar 31, 2019). Originally assigned to: @Ocramius on GitHub. ### Bug Report #### Summary If you have entity, that named like SQL keyword (`Order` in my case), you can not use `$this->createQueryBuilder('...')->...;` because after building the query you get `SELECT ... FROM order ...` query which always has non-escaped table name. As a result, you cant access table with that name. #### How to reproduce 1. Make entity named like SQL keyword 2. Build query with `$this->createQueryBuilder('...')->...;` 3. Try to execute it P.S. Not sure, if this 'bug' relates to this repository, and not to [doctrine/orm](https://github.com/doctrine/orm)

admin added the Can't Fix Question labels 2026-01-22 15:29:00 +01:00

admin closed this issue

2026-01-22 15:29:00 +01:00

admin commented

2026-01-22 15:29:01 +01:00

@ostrolucky commented on GitHub (Apr 1, 2019):

Please try with master, one of the major changes is precisely escaping stuff like that. Will not be fixed in 2.x due to bc concerns

Edit: and yes, this relates to orm. Try master version of orm

@ostrolucky commented on GitHub (Apr 1, 2019): Please try with master, one of the major changes is precisely escaping stuff like that. Will not be fixed in 2.x due to bc concerns Edit: and yes, this relates to orm. Try master version of orm

admin commented

2026-01-22 15:29:01 +01:00

@Ocramius commented on GitHub (Apr 1, 2019):

Closing here: this is documented at https://www.doctrine-project.org/projects/doctrine-orm/en/2.6/reference/limitations-and-known-issues.html#identifier-quoting-and-legacy-databases

@Ocramius commented on GitHub (Apr 1, 2019): Closing here: this is documented at https://www.doctrine-project.org/projects/doctrine-orm/en/2.6/reference/limitations-and-known-issues.html#identifier-quoting-and-legacy-databases

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#6214