Microsoft KB Archive/70832

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.