Issue with retrieving data when the column has @- in it's value
От | Teju Jakkidi |
---|---|
Тема | Issue with retrieving data when the column has @- in it's value |
Дата | |
Msg-id | CAKA2XvYUiaY8f+EzOP4ANLE5g3ni9wAZOFf1r4u_k0YguthZ1Q@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Issue with retrieving data when the column has @- in it's value
Re: Issue with retrieving data when the column has @- in it's value |
Список | 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@-1';
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.
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@-1';
FROM "test_col" WHERE "col1" = 'test_level@-1';
output is the same for both:
char_length | octet_length | length | encode
-------------+--------------+--------+---------------
13 | 13 | 13 | test_level@-1
-------------+--------------+--------+---------------
13 | 13 | 13 | test_level@-1
Can anyone guide me on what else can be checked?
Thanks,
Teja.
В списке pgsql-admin по дате отправления: