Re: operator does not exist: text = bytea

[Karthik K L V <venkata.karthik4u@xxxxxxxxx>]

Update: 

Followed this thread

PostgreSQL: Re: Null bind variable in where clause

and set transform_null_equals to ON in the parameter group on the AWS Console. But no luck.

We are using Aurora PostgresSQL v13.3

On Wed, Jul 20, 2022 at 3:02 PM Karthik K L V <venkata.karthik4u@xxxxxxxxx> wrote:

Hi Team,

I am getting the below error while executing a Select query using Spring DataJPA and Hibernate framework in Aurora Postgres SQL.

Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: text = bytea
  Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
  Position: 1037

We have a query with bind value which sometimes gets resolved to null (no data) depending on the application scenario.

The datatype of the bindvalue and the corresponding column is String.

The same query executes fine when the value of the bindvalue is populated.

Could you please let me know how I can resolve this issue without making changes to the query? 

Is there any configuration available in the Postgres Driver or on the Postgres DB Server which can be set to resolve null bind values?

Appreciate your help. Thank you.

--

Karthik klv

--

Karthik klv