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

          People

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

            Dates

            • Created:
              Updated: