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 ]
        Hide
        jhvaras added a comment -

        Tested and issued in v2.1.7

        Show
        jhvaras added a comment - Tested and issued in v2.1.7
        Hide
        Marco Pivetta added a comment -

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

        Show
        Marco Pivetta added a comment - Can you please try upgrading? 2.1.x won't get any more updates as far as I know.
        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 ]
        Hide
        jhvaras added a comment -

        Hi Marco,

        We cannot upgrade as we are developing under Symfony 2.0

        Thx

        Show
        jhvaras added a comment - Hi Marco, We cannot upgrade as we are developing under Symfony 2.0 Thx
        Benjamin Eberlei made changes -
        Status Awaiting Feedback [ 10000 ] In Progress [ 3 ]
        Hide
        Benjamin Eberlei added a comment -

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

        Show
        Benjamin Eberlei added a comment - Cannot reproduce issue with the attached test-case. Works perfectly with 2.1.7
        Benjamin Eberlei made changes -
        Status In Progress [ 3 ] Resolved [ 5 ]
        Resolution Cannot Reproduce [ 5 ]
        Benjamin Eberlei made changes -
        Attachment ddc2149.patch [ 11368 ]

        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-2149, expand=changesets[0:20].revisions[0:29],reviews}, methodType=GET}] : Received status code 503 (Service Temporarily Unavailable)

          People

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

            Dates

            • Created:
              Updated:
              Resolved: