Hi,
Thanks for your valuable feedback on the patch.
Will check on the cases mentioned by you and do the needful.
Best Regards
Shubhankar K.
Member Technical Staff
Zoho Corporation
On Sat, 14 Jun 2025 09:03:25 +0530 Andy Fan wrote
---
Shubhankar Anand Kulkarni < mailto:shubhankar
Shubhankar Anand Kulkarni writes:
Hi,
> Apologies for delayed response,
> I believe there may be a slight misunderstanding regarding the use case we're
> aiming to improve. Let me clarify it from
> the beginning.
>
> """
> Example :
> SELECT udf1(t1.a) FROM t1_1000row t1, t2_1row t2 where udf1
Hi,
Apologies for delayed response,
I believe there may be a slight misunderstanding regarding the use case we're
aiming to improve. Let me clarify it from the beginning.
"""
Example :
SELECT udf1(t1.a) FROM t1_1000row t1, t2_1row t2 where udf1(t1.a) = t2.a and
t1.a > 5;
"""
In this q
Shubhankar Anand Kulkarni writes:
Hi,
> As seen, the expression got pushed down to respective foreign scan, reducing
> the overall query time reduced
> significantly, but there is an increase in the memory footprint.
That's great on the query time improvement. When you say the memory
footprin
Can you please resolve the doubt mentioned in the below thread?
Thanks &Regards
Shubhankar K
Zlabs-CStore
Member of Technical Staff, Zoho
On Mon, 26 May 2025 16:58:12 +0530 Shubhankar Anand Kulkarni
wrote ---
Hi Andy,
Thanks for the reply. As suggested, I tried using CTE which
Hi Andy,
Thanks for the reply. As suggested, I tried using CTE which seems to solve the
case. This is the updated plan:
QUERY PLAN
Shubhankar Anand Kulkarni writes:
Hi,
> SELECT sensitive_data1, column1 FROM benchmark_encytion AS t1 LEFT JOIN (
> SELECT aes256_cbc_decrypt( c1, '\x1234' ::
> bytea, '\x5678' :: bytea ) AS column1 FROM cipher ) AS t2 ON
> t1.sensitive_data1 = t2.column1;
>
> As you can see in the above Que
Hi Hackers,
While dealing with a few queries, I noticed that when the join expression (join
clause) is used in projection as well, the expression will be computed twice.
For a better understanding, please take reference from the following example:
SELECT sensitive_data1, column1 FROM benchmark
