Doctrine 2 - ORM

LIKE and IS NULL operators not supported in HAVING clause

Details

  • Type: Improvement Improvement
  • Status: In Progress In Progress
  • Priority: Major Major
  • Resolution: Unresolved
  • Affects Version/s: 2.2.2
  • Fix Version/s: None
  • Component/s: DQL
  • Security Level: All
  • Labels:
    None
  • Environment:
    Win7, Mysql

Description

The LIKE and IS NULL operators are not supported in HAVING clause.

Work:
SELECT _a.id, count(_photos) as uuuu FROM Acme\CoreBundle\Entity\Member _a LEFT JOIN _a.photos _photos GROUP BY _a HAVING uuuu in (3,6)
SELECT _a.id, count(_photos) as uuuu FROM Acme\CoreBundle\Entity\Member _a LEFT JOIN _a.photos _photos GROUP BY _a HAVING uuuu = 3
SELECT _a.id, count(_photos) as uuuu FROM Acme\CoreBundle\Entity\Member _a LEFT JOIN _a.photos _photos GROUP BY _a HAVING uuuu >= 3
...

Don't work:
SELECT _a.id, count(_photos) as uuuu FROM Acme\CoreBundle\Entity\Member _a LEFT JOIN _a.photos _photos GROUP BY _a HAVING uuuu LIKE 3
SELECT _a.id, count(_photos) as uuuu FROM Acme\CoreBundle\Entity\Member _a LEFT JOIN _a.photos _photos GROUP BY _a HAVING uuuu IS NULL
SELECT _a.id, count(_photos) as uuuu FROM Acme\CoreBundle\Entity\Member _a LEFT JOIN _a.photos _photos GROUP BY _a HAVING uuuu IS NOT NULL

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Marco Pivetta added a comment -

I think this has already been fixed in latest master and 2.1.7. Could you just give it a try and eventually confirm?

Show
Marco Pivetta added a comment - I think this has already been fixed in latest master and 2.1.7. Could you just give it a try and eventually confirm?
Hide
Permalink
PETIT Yoann added a comment -

Already try with 2.17, 2.20 and 2.2.2. This hasn't been fixed.

Show
PETIT Yoann added a comment - Already try with 2.17, 2.20 and 2.2.2. This hasn't been fixed.
Hide
Permalink
Bdiang added a comment -

I'm also having this issue (2.2.2). Is there any workaround for this?

Column aliases also are not supported in HAVING clause:

$qb->select('p', 'COUNT(p.field) as FieldCount')
            ->from('Entity', 'p')
            ->groupBy('p.id')
   ->having('FieldCount IS NULL')

Above code causes error "FieldCount is not pointing to class" and IS NULL causes "Expected =, <, <=, <>, >, >=, !=, got 'IS'"

Show
Bdiang added a comment - I'm also having this issue (2.2.2). Is there any workaround for this? Column aliases also are not supported in HAVING clause: $qb->select('p', 'COUNT(p.field) as FieldCount') ->from('Entity', 'p') ->groupBy('p.id') ->having('FieldCount IS NULL') Above code causes error "FieldCount is not pointing to class" and IS NULL causes "Expected =, <, <=, <>, >, >=, !=, got 'IS'"
Benjamin Eberlei made changes -
Field Original Value New Value
Workflow jira [ 13760 ] jira-feedback [ 14075 ]
Benjamin Eberlei made changes -
Workflow jira-feedback [ 14075 ] jira-feedback2 [ 15939 ]
Benjamin Eberlei made changes -
Workflow jira-feedback2 [ 15939 ] jira-feedback3 [ 18188 ]
Hide
Permalink
Benjamin Eberlei added a comment -

Its not a bug as the EBNF says that this is not possible.

Guilherme Blanco Is this something we should support or not?

Show
Benjamin Eberlei added a comment - Its not a bug as the EBNF says that this is not possible. Guilherme Blanco Is this something we should support or not?
Benjamin Eberlei made changes -
Issue Type Bug [ 1 ] Improvement [ 4 ]
Assignee Benjamin Eberlei [ beberlei ] Guilherme Blanco [ guilhermeblanco ]
Hide
Permalink
Christophe Coevoet added a comment -

Another place where it is not supported is in the CASE clause.

I would vote +1 for supporting it

Show
Christophe Coevoet added a comment - Another place where it is not supported is in the CASE clause. I would vote +1 for supporting it
Daniel Tangermann made changes -
Status Open [ 1 ] Awaiting Feedback [ 10000 ]
This list may be incomplete, as errors occurred whilst retrieving source from linked applications:
  • Request to http://www.doctrine-project.org/fisheye/ failed: Error in remote call to 'FishEye 0 (http://www.doctrine-project.org/fisheye/)' (http://www.doctrine-project.org/fisheye) [AbstractRestCommand{path='/rest-service-fe/search-v1/crossRepositoryQuery', params={query=DDC-1858, expand=changesets[-21:-1].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

People

  • Assignee:
    Guilherme Blanco
    Reporter:
    PETIT Yoann
Vote (3)
Watch (5)

Dates

  • Created:
    Updated: