Re: crypt function crash on postgresql 9.3.20 and 10 - Mailing list pgsql-bugs

02.02.2018 17:55, David G. Johnston пишет:

On Fri, Feb 2, 2018 at 7:50 AM, Pavan Teja <pavan.postgresdba@gmail.com> wrote:

On Feb 2, 2018 8:15 PM, "Mike Porter" <mike@udel.edu> wrote:

On Fri, 2 Feb 2018, Михаил Манерко wrote:

If you send an asterisk in the crypt function, the function crashes.


example

i=# select crypt('123','*');
ОШИБКА:  invalid salt
i=#

function takes the text parameter
Should it fall from a 1-character long text?

Yes, exactly!
This is similar to calling "sqrt(-1)". The parameter is invalid for the function, such thatthe function can not be performed.

Rainer