SQLSTATE[22P02]: Invalid text representation

I get this error on a specific table with a clause on a specific column:

SQLSTATE[22P02]: Invalid text representation

There are no null values in this column nor UUIDs.

I've tried to refresh the view, as well as the database maintenance tool... without success.

Trying to locate the row that causes the error I discovered a strange behavior:

select * from table where id < 29 and my_buggy_column >= 0 // works

select * from table where id < 30 and my_buggy_column >= 0 // fails

select * from table where id = 30 and my_buggy_column >= 0 // works

The my_buggy_column type is decimal.

Note that the requests are made using the table view and the filter utililty.

Additional information: I don't get the problem on the 'live' database but on a 'test' data source.

Any idea on how to solve this issue?

7 replies