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

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=#

The second argument is the salt, and you have not passed enough bits
for the default hash type.

i=> select crypt( '123', 'aa' );
     crypt
---------------
 aamrgyQfDFSHw
(1 row)

i=> select crypt( '123', 'a' );
ERROR:  invalid salt

Regards,

Mike

--
Regards,
Michael A. Manerko

Megalink Company, Engineer
318, Chehova street, Taganrog, Russia, 347932
tel work: +7 8634 431431 (ext 159)
tel mobile: +7 999 6939428
sip: 159@tagan.ru
www.tagan.ru

-
Mike Porter
PGP Fingerprint: 139B 5431 9346 A577 C0F8  6C76 635D 6C9D 5ABB D433
Old Key: F4 AE E1 9F 67 F7 DA EA  2F D2 37 F3 99 ED D1 C2