PRSQL9108008: SQL Query with CONVERT Causes GP-Fault

ID Number: Q75665

1.10

OS/2

buglist1.10

Summary:

Problem ID: PRSQL9108008

SYMPTOMS

The following query causes the server to GP-Fault:

declare @msg varchar(80)

select @msg = convert(char(6), 2304/512.0)

CAUSE

With the above convert statement, SQL Server incorrectly handles

the conversion to char type for any number that evaluates to 4.5 or

is of the form x.yyyy (up to four decimal places). Numbers with

five decimal places or more will convert successfully.

STATUS

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

1.1. We are researching this problem and will post new information

here as it becomes available.