Skip to content

Unknown column in HAVING clause #662

@stepapo

Description

@stepapo

Describe the bug

I tried RC version of 5.0 and so far so good except for one thing in MySQL. It's connected to this comment. That bug was fixed, difference is in IColletion::OR operator. The reason remains the same, two columns with the same name from different tables in HAVING clause. This works in 4.0

To Reproduce

$books = $this->orm->books->findBy([
  ICollection::OR,
  'tags->id' => 1,
  'author->name' => 'Writer 1',
  'publisher->name' => 'Nextras publisher A',
]);
Assert::same($books->count(), 3);

MySQL: Unknown column 'author.name' in 'having clause'

Versions

  • Database: MariaDB 11.0.2
  • Orm: 5.0.0-rc1
  • Dbal: 5.0.0-rc4

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions