<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p><br>
</p>
<div class="moz-cite-prefix">On 1/5/25 03:02, Tatsuo Ishii wrote:<br>
</div>
<blockquote type="cite"
cite="mid:20250501.090210.2170879573052867721.ishii@postgresql.org">
<blockquote type="cite">
<pre wrap="" class="moz-quote-pre">update : the bug (this new bug) is not present prior to the first
patch. So the bug (the new one) is not present in plain vanilla :
pgpool-II-4.6.0 . Reverting both patches solves the issue with the new
bug which has most probably to do with an array function called
"first" :
</pre>
</blockquote>
<pre wrap="" class="moz-quote-pre">
"first" is coming with the extension? I am not familiar with it.</pre>
</blockquote>
<p>This (and a couple of others I wrote back then) is a C function
written by me, when still intarray was not an extension, I mean
before the extensions framework, sometime in 2004 or so. This is a
simple C function which returns the first element of an array.</p>
<p><span style="font-family:monospace"><span
style="color:#000000;background-color:#ffffff;">dynacom=# \df+
first
</span><br>
List
of functions
<br>
Schema | Name | Result data type | Argument data types | Type |
Volatility | Parallel | Owner | Security | Access
privileges | Language | Source code |<br>
Description <br>
--------+-------+------------------+---------------------+------+------------+----------+----------+----------+--------------------------+----------+-------------+<br>
-------------
<br>
public | first | integer | integer[] | func |
immutable | unsafe | postgres | invoker |
postgres=X/postgres +| c | first |<br>
<br>
| | | | |
| | | |
powerprom=X/postgres +| | |<br>
<br>
| | | | |
| | | |
default_group=X/postgres | | |<br>
<br>
(1 row)
<br>
<br>
dynacom=# <br>
<br>
<br>
</span></p>
<blockquote type="cite"
cite="mid:20250501.090210.2170879573052867721.ishii@postgresql.org">
<pre wrap="" class="moz-quote-pre">
</pre>
<blockquote type="cite">
<pre wrap="" class="moz-quote-pre">select defid, description from machdefs where first(parents)=214766150
order by description;
I haven't been able to reproduce with SQL (from psql).
</pre>
</blockquote>
<pre wrap="" class="moz-quote-pre">
Is it possible for you to create a java reproducer?</pre>
</blockquote>
I will try.<br>
<blockquote type="cite"
cite="mid:20250501.090210.2170879573052867721.ishii@postgresql.org">
<pre wrap="" class="moz-quote-pre">
</pre>
<blockquote type="cite">
<pre wrap="" class="moz-quote-pre">Also reverting both patches, i.e. going back to plain vanilla
pgpool-II-4.6.0 solves this new bug, but re-introduces the previous (
with seeing stale and data and not invalidate data on table
testpgpool)
</pre>
<blockquote type="cite">
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="" class="moz-quote-pre">
</pre>
<blockquote type="cite">
<pre wrap="" class="moz-quote-pre">
Best regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: <a class="moz-txt-link-freetext" href="http://www.sraoss.co.jp/index_en/">http://www.sraoss.co.jp/index_en/</a>
<a class="moz-txt-link-freetext" href="Japanese:http://www.sraoss.co.jp">Japanese:http://www.sraoss.co.jp</a>
</pre>
</blockquote>
<pre wrap="" class="moz-quote-pre">_______________________________________________
pgpool-general mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
</pre>
</blockquote>
<pre wrap="" class="moz-quote-pre">
_______________________________________________
pgpool-general mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
</pre>
</blockquote>
<pre wrap="" class="moz-quote-pre">
_______________________________________________
pgpool-general mailing list
<a class="moz-txt-link-abbreviated" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>
<a class="moz-txt-link-freetext" href="http://www.pgpool.net/mailman/listinfo/pgpool-general">http://www.pgpool.net/mailman/listinfo/pgpool-general</a>
</pre>
</blockquote>
</blockquote>
</blockquote>
</body>
</html>