Doctrine 1
  1. Doctrine 1
  2. DC-843

MSSQL - Equal-to Operator doesn't work with columns of type text in where condition [+patch]

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Minor Minor
    • Resolution: Unresolved
    • Affects Version/s: 1.2.2, 1.2.3
    • Fix Version/s: None
    • Component/s: Connection
    • Labels:
      None

      Description

      Example:

      Doctrine::getTable('Ticket_DCXXX2_Model')->findByUsernameAndFoo('foo', 'bar');
      

      foo is of type "text". Doctrine generates "where .... foo = 'bar'", but this will throw an mssql exception because you cant use the equal to operator in mssql for text and varchar types. Doctrine should consider this database related behavoir, shouldn't it?

        Activity

        Hide
        Enrico Stahn added a comment -
        Show
        Enrico Stahn added a comment - TestCase added http://github.com/estahn/doctrine1/compare/master...DC-843
        Hide
        Enrico Stahn added a comment -

        Patch added to github (see above)

        commit msg: DC-843 fix (TestCase need fix for DC-841 to run successfully)

        Show
        Enrico Stahn added a comment - Patch added to github (see above) commit msg: DC-843 fix (TestCase need fix for DC-841 to run successfully)
        Hide
        Enrico Stahn added a comment -

        I made a mistake with github, the updated branch can be found at
        http://github.com/estahn/doctrine1/tree/DC-843-2

        Show
        Enrico Stahn added a comment - I made a mistake with github, the updated branch can be found at http://github.com/estahn/doctrine1/tree/DC-843-2

          People

          • Assignee:
            Jonathan H. Wage
            Reporter:
            Enrico Stahn
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: