chkpass Major Issue - compares 'contains' and not 'equal'

Eyedia Tech <eyedia@debjyoti.com>

From: Eyedia Tech <eyedia@debjyoti.com>
To: pgsql-bugs@postgresql.org, darcy@druid.net
Date: 2018-06-07T12:41:44Z
Lists: pgsql-bugs
To replicate use this:

create table "user" (uname text, password chkpass);
insert into "user" values ('user1', 'password')
select * from "user" where uname = 'user1' and password = 'password1'

This is a major issue.

Thanks,
Debjyoti Das