Re: What's wrong - Mailing list pgsql-hackers

From Tom Lane
Subject Re: What's wrong
Date
Msg-id 24209.1049135082@sss.pgh.pa.us
Whole thread Raw
In response to What's wrong  (ohp@pyrenet.fr)
Responses Re: What's wrong
Re: What's wrong
List pgsql-hackers
ohp@pyrenet.fr writes:
> It worked fine in 7.2 but now IFAICS, it never gives the original result
> and moreover, if I run SELECT sql_crypt('xxx','xxx') several times, it
> gives 3 diferent results and loops other those 3 results.

I would've expected it to be unreliable under previous versions too.
AFAICS you aren't taking care to ensure that the inputs to crypt()
are null-terminated.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Changing behavior of BEGIN...sleep...do something...COMMIT
Next
From: "Merlin Moncure"
Date:
Subject: Re: SQL/XML examples