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

From: Teju Jakkidi <teja(dot)jakkidi05(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Issue with retrieving data when the column has @- in it's value
Date: 2025-04-05 01:41:48
Message-ID: CAKA2XvYUiaY8f+EzOP4ANLE5g3ni9wAZOFf1r4u_k0YguthZ1Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello Admins,

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(at)-1';

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

On orig db, I have to either a dd trim or COLLATE "C" for it to return data.

The collation is same on both the dbs (en_US.UTF-8) and the os locate is
also the same on both.

Column col1 datatype is varchar.

I tried checking if there are any spaces or special characters and did not
see anything in the output.

SELECT char_length("col1"), octet_length("col1"), length("col1"),
encode("col1"::bytea, 'escape')
FROM "test_col" WHERE "col1" = 'test_level(at)-1';

output is the same for both:
char_length | octet_length | length | encode
-------------+--------------+--------+---------------
13 | 13 | 13 | test_level(at)-1

Can anyone guide me on what else can be checked?

Thanks,
Teja.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2025-04-05 01:46:38 Re: Issue with retrieving data when the column has @- in it's value
Previous Message Mauricio Fernandez 2025-04-03 13:19:03 Re: Create foreign table documentation