Re: operator does not exist: text = bytea

2022-07-20 Thread Tom Lane
Karthik K L V writes: > 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. >

Re: operator does not exist: text = bytea

2022-07-20 Thread Karthik K L V
Engine to read *= null* as *is null*. On Wed, Jul 20, 2022 at 5:29 PM hubert depesz lubaczewski wrote: > On Wed, Jul 20, 2022 at 03:02:13PM +0530, Karthik K L V wrote: > > *Caused by: org.postgresql.util.PSQLException: ERROR: operator does not > > exist: text = bytea Hint: No o

Re: operator does not exist: text = bytea

2022-07-20 Thread hubert depesz lubaczewski
On Wed, Jul 20, 2022 at 03:02:13PM +0530, Karthik K L V wrote: > *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* &g

Re: operator does not exist: text = bytea

2022-07-20 Thread Karthik K L V
Aurora PostgresSQL v13.3 On Wed, Jul 20, 2022 at 3:02 PM Karthik K L V 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: ER

operator does not exist: text = bytea

2022-07-20 Thread Karthik K L V
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