FIX: UNION in Views Maintains Duplicate Rows If Table Has Bit (159701)
The information in this article applies to:
This article was previously published under Q159701
BUG #: 16130 (WINDOWS: 6.5)
SYMPTOMS
Running a SELECT from a view that is defined as a UNION of select
statements does not eliminate duplicate rows, if the underlying table
contains a field of the bit type. However, duplicate rows are eliminated if
the UNION statement is not within a view.
WORKAROUND
If the bit datatype must be used, place the UNION statement outside a view,
or use the DISTINCT keyword when selecting from the view. Otherwise, use
tinyint, smallint, or int datatypes rather than the bit type.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server
version 6.5. This problem has been corrected in U.S. Service Pack 2 for
Microsoft SQL Server version 6.5. For more information, contact your
primary support provider.
Modification Type: | Major | Last Reviewed: | 10/3/2003 |
---|
Keywords: | kbBug kbfix kbProgramming KB159701 |
---|
|