Major Description
If you have a table with TIMESTAMP column, that column can't be used in WHERE clause properly - it is not evaluated properly.
F.e., SELECT * FROM a WHERE timestamp='2014-08-21 00:00:00.0', would return nothing even if there would be a row with such a timestamp. The literal is not interpreted into a timestamp.
The workaround SELECT * FROM a WHERE timestamp=CAST('2014-08-21 00:00:00.0' AS TIMESTAMP) fails, because the parser does not allow anything but STRING in the CAST dataType expression.