Doctrine 1

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

Details

  • Type: Bug Bug
  • Status: Open Open
  • Priority: Minor Minor
  • Resolution: Unresolved
  • Affects Version/s: 1.2.2, 1.2.3
  • Fix Version/s: 1.2.4
  • 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

Ascending order - Click to sort in descending order
Hide
Permalink
Enrico Stahn added a comment -

TestCase added http://github.com/estahn/doctrine1/compare/master...DC-843

Show
Enrico Stahn added a comment - TestCase added http://github.com/estahn/doctrine1/compare/master...DC-843
Hide
Permalink
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
Permalink
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
Vote (0)
Watch (0)

Dates

  • Created:
    Updated: