Postgres Pro
Downloads
Home   >   mailing lists

chkpass Major Issue - compares 'contains' and not 'equal' - Mailing list pgsql-bugs

From Eyedia Tech
Subject chkpass Major Issue - compares 'contains' and not 'equal'
Date
Msg-id CAHcjpqfBK=YZZjJPLfS=E8C1ZK_RJyqyZW=8uxn4D1-XtmSS5A@mail.gmail.com
Whole thread Raw
Responses Re: chkpass Major Issue - compares 'contains' and not 'equal'  ("David G. Johnston" <david.g.johnston@gmail.com>)
Re: chkpass Major Issue - compares 'contains' and not 'equal'  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view
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

pgsql-bugs by date:

Previous
From: Sergei Kornilov
Date:
Subject: Re: BUG #15231: After Upgrade from 9.3.23 to 9.6.9 getting ERROR: found xmin 598 from before relfrozenxid 68569164
Next
From: Dmitry Dolgov
Date:
Subject: Re: BUG #15212: Default values in partition tables don't work asexpected and allow NOT NULL violation