Re: A question about leakproof

Hi, On Mon, Oct 17, 2022 at 09:15:20AM +0800, qiumingcheng wrote: > Hello， My questions are as follows： > Problem description > After testing, we don't find the difference between functions of > proleakproof=true and functions of proleakproof=false (the function is > described in pg_proc). Can you

Re: A question about leakproof

Julien Rouhaud writes: > On Mon, Oct 17, 2022 at 09:15:20AM +0800, qiumingcheng wrote: >> After testing, we don't find the difference between functions of >> proleakproof=true and functions of proleakproof=false (the function is >> described in pg_proc). > Have you looked at > https://wiki.postgr

回复：A question about leakproof

> Have you looked at > https://wiki.postgresql.org/wiki/What%27s_new_in_PostgreSQL_9.2#Security_barriers_and_Leakproof > > >? Yes, if I use securtiy_barrierys, it do work, but it still can't use in

Re: 回复：A question about leakproof

"qiumingcheng" writes: > 1. In the test example I gave, the in4eq function's proleakproof=true, but > its actual test result is leaking. Does that mean you will adjust it to > proleakproof=false later? int4eq is about as leakproof as a function could possibly be: it does not leak, it's plain fr

Re: 回复：A question about leakproof

On Sun, Oct 16, 2022 at 8:33 PM Tom Lane wrote: > "qiumingcheng" writes: > > 1. In the test example I gave, the in4eq function's proleakproof=true, > but its actual test result is leaking. Does that mean you will adjust it to > proleakproof=false later? > > int4eq is about as leakproof as a func

回复：回复：A question about leakproof

> you seem to be imagining that changes in a query's plan on the basis of > changes in collected statistics have something to do with this. They do not. Sorry, I may not fully understand what you mean. I mean that after my tests, the execution results of this SQL (explain select * from tb_a_date_