SPACE Function
Depending on where it is executed, the SPACE function with negative arguments can return different results. For example, for SPACE(-1):
• TDV (function not pushed) returns NULL.
• Microsoft SQL Server returns NULL.
• DB2 throws an exception.
• Greenplum, MySQL, PostgreSQL, and return nothing.