Skip to content

Commit 35fa7a4

Browse files
committed
Update documentation
1 parent a3e532d commit 35fa7a4

File tree

2 files changed

+7
-2
lines changed

2 files changed

+7
-2
lines changed

tpch.sql

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -149,7 +149,7 @@ where filter(betwixt(l_shipdate, '1996-01-01', '1997-01-01')
149149
select
150150
sum(l_extendedprice*l_discount) as revenue
151151
from
152-
lineitem_projection
152+
vops_lineitem_projection
153153
where
154154
l_shipdate between '1996-01-01'::date and '1997-01-01'::date
155155
and l_discount between 0.08 and 0.1

vops.html

Lines changed: 6 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -566,7 +566,12 @@ <h2><a name="transform">Standard SQL query transformation</a></h2>
566566
generate dummy tile with all components equal to the specified constant and perform
567567
(<i>vector</i> <b>OP</b> <i>vector</i>) operation instead of more efficient (<i>vector</i> <b>OP</b> <i>scalar</i>).
568568
</p>
569-
569+
<p>
570+
There is one pitfall with post parse analyze hook: it is initialized in the extension <code>_PG_init</code> function.
571+
But if extension was not registered in <code>shared_preload_libraries</code> list, then it will be loaded on demand when any function of this extension is requested.
572+
Unfortunately it happens <b>after</b> parse analyze is done. So first time you execute VOPS query, it will not be transformed. You can get wrong result in this case.
573+
Either take it in account, either add <code>vops</code> to <code>shared_preload_libraries</code> configuration string.
574+
</p>
570575

571576
<h2><a name="example">Example</a></h2>
572577

0 commit comments

Comments
 (0)