[PR #6476] Allow arithmetic expressions within IN operator #9995

New Issue

admin · 2026-01-22T16:06:05+01:00

admin commented

2026-01-22 16:06:05 +01:00

Original Pull Request: https://github.com/doctrine/orm/pull/6476

State: closed
Merged: No

In some cases it is necessary to use not only scalar values or subselects within IN-conditions, but also own functions.

With Oracle databases, the following is then possible:

DQL:
SELECT u FROM User WHERE u.name IN ( CUSTOM_DQL_FUNCTION() );

SQL:
SELECT * FROM user WHERE name IN ( SELECT * FROM TABLE(ORACLE_PLSQL_FUNCTION()) );

Another example which is also possible now:

DQL:
[...] WHERE field IN ( CUSTOM_DQL_GET_ID('Foo'), CUSTOM_ESCAPE('Bar') )

SQL:
[...] WHERE field IN ( (SELECT id FROM settings WHERE name = 'Foo'), [...] )

**Original Pull Request:** https://github.com/doctrine/orm/pull/6476 **State:** closed **Merged:** No --- In some cases it is necessary to use not only scalar values or subselects within IN-conditions, but also own functions. With Oracle databases, the following is then possible: DQL: `SELECT u FROM User WHERE u.name IN ( CUSTOM_DQL_FUNCTION() );` SQL: `SELECT * FROM user WHERE name IN ( SELECT * FROM TABLE(ORACLE_PLSQL_FUNCTION()) );` Another example which is also possible now: DQL: `[...] WHERE field IN ( CUSTOM_DQL_GET_ID('Foo'), CUSTOM_ESCAPE('Bar') )` SQL: `[...] WHERE field IN ( (SELECT id FROM settings WHERE name = 'Foo'), [...] )`

admin added the pull-request label 2026-01-22 16:06:05 +01:00

admin closed this issue

2026-01-22 16:06:05 +01:00

admin referenced this issue

2026-01-22 16:12:41 +01:00

[PR #9995] Fix EnumType not being hydrated with HYDRATE_ARRAY #12030

Sign in to join this conversation.