LIKE predicate for character large object (CLOB) columns [CR 415546]

Sybase IQ 12.7 ESD #3 includes support of the LIKE predicate on LONG VARCHAR (CLOB) columns.

The following sentence will be added to the section “LONG VARCHAR columns in queries” in Chapter 3, “Character Large Object (CLOB) data”:

“You can use the LIKE predicate to search for a pattern on a LONG VARCHAR column. All patterns of 126 characters or less are supported. Patterns of length greater than 254 characters are not supported. Some patterns of length between 127 and 254 characters are supported, depending on the contents of the pattern.”

The following paragraph will be added to the section “LONG BINARY columns in queries” in Chapter 2, “Binary Large Object (BLOB) data”:

“LIKE predicates are not supported on LONG BINARY (BLOB) columns. If you attempt to search for a pattern in a LONG BINARY column using a LIKE predicate, the error “Invalid data type comparison in predicate...” is returned.”

The following error will be added to Chapter 8, “Error and Warning Messages”:

Invalid data type comparison %1

This error is reported if you attempt to search for a pattern in a LONG BINARY column using a LIKE predicate. LIKE predicates are not supported on LONG BINARY (BLOB) columns.