Doctrine 1
  1. Doctrine 1
  2. DC-1055

Bug in select query when executed against postgreSQL

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Query
    • Labels:
      None
    • Environment:
      symfony-1.4.17 php 5.3.5 apache 2.2.17 WIndows xp/7 PostgreSQL 9.1.2

      Description

      In the attached Squema run this query against postgreSQL.
      (it runs ok In mysql)

      $lang = 'en';
      $session = 1;
      $q = Doctrine_Query::create()
      ->from('Sys_Trace t')
      ->leftJoin('t.Sys_Session s')
      ->leftJoin('t.Translation tr WITH tr.lang = ?', array($lang))
      ->leftJoin('t.Sys_Oper so')
      ->leftJoin('so.Translation tr2 WITH tr2.lang = ?', array($lang))
      >where('t.session_id = ?', array($session));

      SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for integer: "en"

      1. schema.rar
        1 kB
        Damian Bergantinnos

        Activity

        Damian Bergantinnos created issue -

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

          People

          • Assignee:
            Guilherme Blanco
            Reporter:
            Damian Bergantinnos
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated: