PRSQL9103012: SPACE(NULL) Will GP-Fault SQL Server 1.10

ID Number: Q70832

1.10

OS/2

buglist1.10

Summary:

PROBLEM ID: PRSQL9103012

SYMPTOMS

Calling the SPACE() function will GP-fault SQL Server 1.10.

CAUSE

If the SPACE() function is called with the syntax "SPACE(null)",

the server will GP-fault.

RESOLUTION

Pass a temporary variable that has been set to null. For example,

"SPACE(@tmp)", where @tmp has previously been set to null.