For certain cases, the node[1] is not null, but the 'nodes[1].dataType' is NULL. For stored procedure with parameter on trim character, our planner does not know its expected type, which will throw exception. I am not sure why hsql will plan a NULL datatype for the input character.

For this case, we can assign the data type for it on hsql here, or add a special check on VoltXML side for TRIM function.