DDC-2149: lte with or conditional not working #2705

Closed
opened 2026-01-22 14:01:05 +01:00 by admin · 5 comments
Owner

Originally created by @doctrinebot on GitHub (Nov 16, 2012).

Originally assigned to: @beberlei on GitHub.

Jira issue originally created by user jhvaras:

$qb->select(array('c.id'))
->from('Veiss\BoletusBundle\Entity\Calendar', 'c')
->where("(c.endDate >= 111) OR (c.startDate >= 222)")

returns correctly:
"SELECT c0_.id AS id0 FROM Calendar c0_ WHERE (c0_.endDate >= 111) OR (c0_.startDate >= 222)"

but lte condition:
->where("(c.endDate <= 111) OR (c.startDate >= 222)")

returns incorrectly:
"SELECT c0_.id AS id0 FROM Calendar c0_ WHERE (c0_.endDate = 222)"

I have tested that an same occurs with "expr()->lte"

Originally created by @doctrinebot on GitHub (Nov 16, 2012). Originally assigned to: @beberlei on GitHub. Jira issue originally created by user jhvaras: $qb->select(array('c.id')) ->from('Veiss\BoletusBundle\Entity\Calendar', 'c') ->where("(c.endDate >= 111) OR (c.startDate >= 222)") returns correctly: "SELECT c0_.id AS id0 FROM Calendar c0_ WHERE (c0_.endDate >= 111) OR (c0_.startDate >= 222)" but lte condition: ->where("(c.endDate <= 111) OR (c.startDate >= 222)") returns incorrectly: "SELECT c0_.id AS id0 FROM Calendar c0_ WHERE (c0_.endDate = 222)" I have tested that an same occurs with "expr()->lte"
admin added the Bug label 2026-01-22 14:01:05 +01:00
admin closed this issue 2026-01-22 14:01:06 +01:00
Author
Owner

@doctrinebot commented on GitHub (Nov 16, 2012):

Comment created by jhvaras:

Tested and issued in v2.1.7

@doctrinebot commented on GitHub (Nov 16, 2012): Comment created by jhvaras: Tested and issued in v2.1.7
Author
Owner

@doctrinebot commented on GitHub (Nov 16, 2012):

Comment created by @ocramius:

Can you please try upgrading? 2.1.x won't get any more updates as far as I know.

@doctrinebot commented on GitHub (Nov 16, 2012): Comment created by @ocramius: Can you please try upgrading? 2.1.x won't get any more updates as far as I know.
Author
Owner

@doctrinebot commented on GitHub (Nov 16, 2012):

Comment created by jhvaras:

Hi Marco,

We cannot upgrade as we are developing under Symfony 2.0

Thx

@doctrinebot commented on GitHub (Nov 16, 2012): Comment created by jhvaras: Hi Marco, We cannot upgrade as we are developing under Symfony 2.0 Thx
Author
Owner

@doctrinebot commented on GitHub (Jan 6, 2013):

Comment created by @beberlei:

Cannot reproduce issue with the attached test-case. Works perfectly with 2.1.7

@doctrinebot commented on GitHub (Jan 6, 2013): Comment created by @beberlei: Cannot reproduce issue with the attached test-case. Works perfectly with 2.1.7
Author
Owner

@doctrinebot commented on GitHub (Jan 6, 2013):

Issue was closed with resolution "Cannot Reproduce"

@doctrinebot commented on GitHub (Jan 6, 2013): Issue was closed with resolution "Cannot Reproduce"
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: doctrine/archived-orm#2705