Skip to content

Filter.getCriterion() fails when DB column is a Sybase TEXT fieldย #434

@PeteDarinzo

Description

@PeteDarinzo

When an app uses a sybase datasource, attempting to filter admin track logs on the additional data field causes an SQL exception.

The cause is that some operations performed by the field filter's criterion when creating the filtering query cannot be performed on a TEXT field in sybase.

For example, a "like" or "not like" filter will throw the following when the filter criterion attempts to convert the data field to lowercase.

com.sybase.jdbc3.jdbc.SybSQLException: Function LOWER invoked with wrong number or type of argument(s).

Experimentation shows that such a query succeeds when the TEXT field is first cast as a VARCHAR of sufficient size.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions