Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Cannot Reproduce
    • Affects Version/s: 2.1.7
    • Fix Version/s: None
    • Component/s: None
    • Security Level: All
    • Labels:
    • Environment:
      Symfony 2.0.x

      Description

      $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"

      1. ddc2149.patch
        0.8 kB
        Benjamin Eberlei

        Activity

        jhvaras created issue -
        jhvaras made changes -
        Field Original Value New Value
        Status Open [ 1 ] Awaiting Feedback [ 10000 ]
        Marco Pivetta made changes -
        Environment Symfony2 Symfony 2.0.x
        Priority Critical [ 2 ] Major [ 3 ]
        Marco Pivetta made changes -
        Affects Version/s 2.1 [ 10123 ]
        Marco Pivetta made changes -
        Project Doctrine Common [ 10043 ] Doctrine 2 - ORM [ 10032 ]
        Key DCOM-140 DDC-2149
        Affects Version/s 2.1.7 [ 10198 ]
        Affects Version/s 2.1 [ 10123 ]
        Security All [ 10000 ]
        Benjamin Eberlei made changes -
        Status Awaiting Feedback [ 10000 ] In Progress [ 3 ]
        Benjamin Eberlei made changes -
        Status In Progress [ 3 ] Resolved [ 5 ]
        Resolution Cannot Reproduce [ 5 ]
        Benjamin Eberlei made changes -
        Attachment ddc2149.patch [ 11368 ]

          People

          • Assignee:
            Benjamin Eberlei
            Reporter:
            jhvaras
          • Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: