Re: Issue with retrieving data when the column has @- in it's value

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Friday, April 4, 2025, Teju Jakkidi <teja.jakkidi05@xxxxxxxxx> wrote:

I have an issue where in the same scenario below works on my POC but is having an issue in the original db.

Original db - OS : Red Hat   (postgres13)

POC db - OS : SUSE    (postgres 14)

SELECT char_length("col1"), octet_length("col1"), "col1"
FROM "test_col" WHERE "col1" = 'test_level@-1';

The above query returns data in POC, however, on orig db, it does not return any data.

Can anyone guide me on what else can be checked?

Explain analyze to check for index usage and reindexing.

David J.