DDC-2314: getResults with numeric indexes for fields #2907

New Issue

admin · 2026-01-22T14:07:05+01:00

admin commented

2026-01-22 14:07:05 +01:00

Originally created by @doctrinebot on GitHub (Feb 22, 2013).

Originally assigned to: @beberlei on GitHub.

Jira issue originally created by user ninjds:

When executing a simple query with field names in SELECT clause, it is not possible to map field to numeric indexes.

This is an example that i would imagine to be useful:

SELECT c.id AS 0, c.name AS 1, l.text AS 2 FROM Category c LEFT JOIN c.label l

Thus, the resulting results could be numeric indexed array. It is useful for many situations: when working with an API which expects such arrays, or when using list to assign result fields to variables directly.

Query::HYDRATE_SCALAR does not achieve this, as one could think at first glance.

Originally created by @doctrinebot on GitHub (Feb 22, 2013). Originally assigned to: @beberlei on GitHub. Jira issue originally created by user ninjds: When executing a simple query with field names in SELECT clause, it is not possible to map field to numeric indexes. This is an example that i would imagine to be useful: `SELECT c.id AS 0, c.name AS 1, l.text AS 2 FROM Category c LEFT JOIN c.label l` Thus, the resulting results could be numeric indexed array. It is useful for many situations: when working with an API which expects such arrays, or when using `list` to assign result fields to variables directly. Query::HYDRATE_SCALAR does not achieve this, as one could think at first glance.

admin added the Improvement label 2026-01-22 14:07:05 +01:00

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