Major Description
The SIGN built-in function preserves the order of its input. This needs to be explicitly implemented in SignFunction by implementing the following method:
public OrderPreserving preservesOrder() { return OrderPreserving.YES; }
This will allow certain optimizations reducing the amount of memory and/or buffering that is required if SIGN is used in a GROUP BY or ORDER BY clause.