Uploaded image for project: '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
    • Status: Open
    • Priority: 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

        Show
        enrico Enrico Stahn added a comment - TestCase added http://github.com/estahn/doctrine1/compare/master...DC-843
        Hide
        enrico 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 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 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 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:
            jwage Jonathan H. Wage
            Reporter:
            enrico Enrico Stahn
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: