PRSQL9103027: Cannot CONVERT to Image with an ORDER BY

ID Number: Q70847

1.10

OS/2

buglist1.10 fixlist1.11

Summary:

PROBLEM ID: PRSQL9103027

SYMPTOMS

A GP-fault occurs when CONVERT and ORDER BY are used to select data

from the systypes table.

CAUSE

Converting character type to text or image data in combination with

an ORDER BY will cause this problem unless the column in the ORDER

BY is part of a clustered, unique index.

WORKAROUND

Select the converted information into a temporary table, then

perform the ORDER BY on this temporary table.

STATUS

Microsoft has confirmed this to 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 you primary support provider.