Inconsistent datatype: lob type comparison...

[marianr]

According to the documentation : LOB columns cannot appear in WHERE clauses as a predicate except LIKE, CONTAINS, =, or <>.

[marianr]

From the SAP HANA Reference: Data Types:
LOB types are provided for storing and retrieving such large data. LOB types support the following operations.

The length() function returns the LOB length in bytes.
LIKE can be used to search LOB columns.

The LOB types have the following restrictions:

LOB columns cannot appear in ORDER BY or GROUP BY clauses.
LOB columns cannot appear in FROM clauses as a join predicate.
LOB columns cannot appear in WHERE clauses as a predicate except LIKE, CONTAINS, =, or <>.
LOB columns cannot appear in SELECT clauses as an aggregate function argument.
LOB columns cannot appear in SELECT DISTINCT clauses.
LOB columns cannot be used in set operations such as EXCEPT. UNION ALL is an exception.
LOB columns cannot be used as a primary key.
LOB columns cannot be used in CREATE INDEX statements.
LOB columns cannot be used in statistics update statements.

It looks like the documentation is not correct: Comparison on LOB column is not allowed . In the where clause only LIKE operator is allowed for comparing LOBs.