Doctrine aliasing issue when column name starts with number #6033

New Issue

admin · 2026-01-22T15:25:06+01:00

admin commented

2026-01-22 15:25:06 +01:00

Originally created by @CheeseBites on GitHub (Aug 7, 2018).

Originally assigned to: @Ocramius on GitHub.

If the column name starts with a number the querybuilder doesn't wrap the alias in quotes,

Error returns:
An exception occurred while executing 'SELECT t0_.AA AS AA_0, t0_.BB AS BB_1, t0_.[12AA] AS 12AA_2 FROM [foo]'

What the query should look like
An exception occurred while executing 'SELECT t0_.AA AS AA_0, t0_.BB AS BB_1, t0_.[12AA] AS "12AA_2" FROM [foo]'

The code looks like this

$queryBuilder = $this->entityManager->createQueryBuilder();
$queryBuilder->select('a')->from(foo::class, 'a');
$list = $queryBuilder->getQuery()->getResult();

Is there any workaround for this?

Originally created by @CheeseBites on GitHub (Aug 7, 2018). Originally assigned to: @Ocramius on GitHub. If the column name starts with a number the querybuilder doesn't wrap the alias in quotes, Error returns: `An exception occurred while executing 'SELECT t0_.AA AS AA_0, t0_.BB AS BB_1, t0_.[12AA] AS 12AA_2 FROM [foo]'` What the query should look like `An exception occurred while executing 'SELECT t0_.AA AS AA_0, t0_.BB AS BB_1, t0_.[12AA] AS "12AA_2" FROM [foo]'` The code looks like this ``` $queryBuilder = $this->entityManager->createQueryBuilder(); $queryBuilder->select('a')->from(foo::class, 'a'); $list = $queryBuilder->getQuery()->getResult(); ``` Is there any workaround for this?

admin added the Duplicate label 2026-01-22 15:25:06 +01:00

admin closed this issue

2026-01-22 15:25:06 +01:00

admin commented

2026-01-22 15:25:07 +01:00

@Ocramius commented on GitHub (Aug 7, 2018):

What ORM version are you on? I think this is already fixed by prefixing without numbers as start

@Ocramius commented on GitHub (Aug 7, 2018): What ORM version are you on? I think this is already fixed by prefixing without numbers as start

admin commented

2026-01-22 15:25:08 +01:00

@ostrolucky commented on GitHub (Aug 7, 2018):

Dupe of https://github.com/doctrine/doctrine2/issues/6965