Microsoft KB Archive/70855

PRSQL9103035: Select Distinct Does Not Return Expected Results ID Number: Q70855

1.10 OS/2 buglist1.10

Summary:

PROBLEM ID: PRSQL9103035

SYMPTOMS In a case insensitive database, when issuing a “select distinct” command on a character column in a table, identical rows that have different combinations of uppercase and lowercase letters are returned.

STATUS Microsoft has confirmed this to be a problem in SQL Server version 1.10. We are researching this problem and will post new information here as it becomes available.