Relationships on non-Integer fields fail under MSSQL

[paj]

Using MSSQL, relationships on String fields don't work - the relationship always returns an empty list. I am attaching a minimal test case that demonstrates this. The same test case works correctly using SQLite.

[paj]

minimal test case

[paj]

On further investigation, this appears to be a problem with adodbapi. adodbapi is returning no rows from the query, when it ought to!

I notice the query is constructed "... WHERE ? = contact.tsrid ..." Manually recoding it as "... WHERE contact.tsrid = ? ..." fixes the problem.

So potentially SA could have a workaround for this issue, but I am going to see if I can fix adodbapi first.

[paj]

It doesn't look like a problem with adodbapi per-se; seems ADO doesn't like the bind parameter being on the left hand side. I will have a go at recoding MSSQLSchemaGenerator to stop this happening.

[paj]

Sorry, I meant MSSQLCompiler not MSSQLSchemaGenerator

[paj]

Ok, I have a patch that makes this work!

[paj]

patch for suggested fix

[Former user]

(original author: ram) Committed in rev 2316, thanks

[Mike Bayer]

Milestone next micropoint release deleted

[Mike Bayer]

Removing milestone: 0.4.0 (automated comment)