PRSQL9103010: Converting Type Bit with ORDER BY GP-Faults SQL

ID Number: Q70830

1.10

OS/2

buglist1.10 fixlist1.11

Summary:

PROBLEM ID: PRSQL9103010

SYMPTOMS

Converting an integer value of a column to type bit with an ORDER

BY clause GP-faults the SQL Server.

CAUSE

This problem is the result of the ORDER BY bit combination.

WORKAROUND

Removing the ORDER BY or converting to binary eliminates the

problem.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version

1.1. This problem has been corrected in SQL Server version 1.11,

which is available from Microsoft Product Support Services. For

more information, contact your primary support provider.