> On Fri, Nov 04, 2022 at 05:58:06AM +0100, Pavel Stehule wrote: > Hi > > fix clang warning
I've stumbled upon something that looks weird to me (inspired by the example from tests):
=# create variable v2 as int; =# let v2 = 3; =# create view vv2 as select coalesce(v2, 0) + 1000 as result
=# select * from vv2; result -------- 1003
=# set force_parallel_mode to on; =# select * from vv2; result -------- 1000
In the second select the actual work is done from a worker backend. Since values of session variables are stored in the backend local memory, it's not being shared with the worker and the value is not found in the hash map. Does this suppose to be like that?
It looks like a bug, but parallel queries should be supported.
The value of the variable is passed as parameter to the worker backend. But probably somewhere the original reference was not replaced by parameter