Re: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641)

Started by Hayato Kuroda (Fujitsu)about 2 months ago16 messagesbugs
Jump to latest
#1Hayato Kuroda (Fujitsu)
kuroda.hayato@fujitsu.com

Hi,

This is the reply for [1]/messages/by-id/CAF7a2M-OF+TjYUBvkSV2oyZNYuPm=EqTApcMDOC+aevBFPuWrg@mail.gmail.com. My mailer could not receive the original post due to
the company's policy, so I will put as the normal post. Sorry for inconvenience.

I confirmed this could happen on PG18, PG17 and PG14. Not tested, but expecting
for PG15 and 166 as well. This could not happen on PG19/HEAD because the
elog(ERROR) was removed by 87f7b824f20, but possible for all branches.

I think your analysis is correct. bsysscan tries to indicate that whether we're
scanning a system table, which was turned on at systable_beginscan* and turned
off at systable_endscan*. But if the systable scan is nested (i.e., pg_constraint.conbin),
the flag can be wrong reset. In PG18- the state is checked for every getnextslot,
which raised the ERROR. In PG19+ the check is unified at the beginning thus the
ERROR does not happen, but I guess the flag can be still wrong.

One idea is to track the depth of scans. Attached patch is for PG18, and I tried not
to modify the header as much as possible. It also had a test code based on your
reproducer. Can you see it's same as your expectation?

[1]: /messages/by-id/CAF7a2M-OF+TjYUBvkSV2oyZNYuPm=EqTApcMDOC+aevBFPuWrg@mail.gmail.com

Best regards,
Hayato Kuroda
FUJITSU LIMITED

Attachments:

v1-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=v1-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+121-30
#2Jiří Kavalík
jiri.kavalik@comgate.cz
In reply to: Hayato Kuroda (Fujitsu) (#1)

Hi Kuroda-san,

Thank you for the quick analysis and the patch.

Can you see it's same as your expectation?

Yes. I tested v1 on REL_18_STABLE (37bbf5bba0, 18.6 plus later commits),
with
two builds from the same tree differing only by the patch, both configured
with --enable-debug --enable-cassert.

In each case below, a fresh backend peeks at a slot while a transaction that
first inserts one row into the test table, then 10000 rows into a filler
table, is still open (logical_decoding_work_mem = 64kB, CHECKPOINT before
the
peek):

1. TOASTed conbin first, three more constraints after it:
- test_decoding: unpatched ERROR, patched OK
- pgoutput, table published: unpatched ERROR, patched OK
- pgoutput, table NOT published: unpatched ERROR, patched OK

2. TOASTed conbin first, only the NOT NULL and PK constraints after it:
- test_decoding: unpatched ERROR, patched OK
- pgoutput, table published: unpatched ERROR, patched OK
- pgoutput, table NOT published: unpatched ERROR, patched OK

3. TOASTed conbin last: OK on both builds, both plugins.

4. No TOASTed conbin: OK on both builds, both plugins.

"OK" means the whole transaction was decoded (10098 rows from test_decoding,
10100 from pgoutput). There were no assertion failures in either server log.

Your new stream.sql test fails on the unpatched build with the same ERROR
and
passes with the patch. With the patch, contrib/test_decoding "make check"
(19 regression + 13 isolation tests) and the core "make check" (231 tests)
pass.

The "table NOT published" rows may be worth noting: the relation that hit
the
error in our production case is not in the subscribed publication, it is
only
modified by the streamed transaction. The relcache entry is still built, so
the bug is reachable for any table the transaction touches.

One question while reading the patch, not a problem I could trigger: the
depth
is incremented in systable_beginscan* and decremented in systable_endscan*
only
if CheckXidAlive is valid, and that is evaluated separately at each end. If
CheckXidAlive changed while a scan was open, the counter would be off by
one.
I could not find a path where that happens. Error paths look fine, since
AbortTransaction/AbortSubTransaction call ResetLogicalStreamingState(). If a
SysScanDesc field is acceptable despite the header concern, remembering in
the
scan whether it was counted would make the pairing explicit.

Regards,
Jiří Kavalík

pá 2. 10. 2026 v 9:33 odesílatel Hayato Kuroda (Fujitsu) <
kuroda.hayato@fujitsu.com> napsal:

Hi,

This is the reply for [1]. My mailer could not receive the original post
due to
the company's policy, so I will put as the normal post. Sorry for
inconvenience.

I confirmed this could happen on PG18, PG17 and PG14. Not tested, but
expecting
for PG15 and 166 as well. This could not happen on PG19/HEAD because the
elog(ERROR) was removed by 87f7b824f20, but possible for all branches.

I think your analysis is correct. bsysscan tries to indicate that whether
we're
scanning a system table, which was turned on at systable_beginscan* and
turned
off at systable_endscan*. But if the systable scan is nested (i.e.,
pg_constraint.conbin),
the flag can be wrong reset. In PG18- the state is checked for every
getnextslot,
which raised the ERROR. In PG19+ the check is unified at the beginning
thus the
ERROR does not happen, but I guess the flag can be still wrong.

One idea is to track the depth of scans. Attached patch is for PG18, and I
tried not
to modify the header as much as possible. It also had a test code based on
your
reproducer. Can you see it's same as your expectation?

[1]:
/messages/by-id/CAF7a2M-OF+TjYUBvkSV2oyZNYuPm=EqTApcMDOC+aevBFPuWrg@mail.gmail.com

Best regards,
Hayato Kuroda
FUJITSU LIMITED

--
S pozdravem
Jiří Kavalík
jiri.kavalik@comgate.cz
Comgate a.s.
Gočárova třída 1754/48b, 500 02 Hradec Králové
www.comgate.cz

#3Hayato Kuroda (Fujitsu)
kuroda.hayato@fujitsu.com
In reply to: Jiří Kavalík (#2)
RE: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641)

Hi Jiří,

Thanks for the test. I understood that no issues were found for now.

One question while reading the patch, not a problem I could trigger: the depth
is incremented in systable_beginscan* and decremented in systable_endscan* only
if CheckXidAlive is valid, and that is evaluated separately at each end. If
CheckXidAlive changed while a scan was open, the counter would be off by one.
I could not find a path where that happens. Error paths look fine, since
AbortTransaction/AbortSubTransaction call ResetLogicalStreamingState(). If a
SysScanDesc field is acceptable despite the header concern, remembering in the
scan whether it was counted would make the pairing explicit.

Hmm, I'm not excited to modify the exposed data structure yet, unless there is a
real issue. Per my analysis, SysScanDescData only contains pointers (8 bytes),
it does not have any paddings. This meant we need to modify a size of the data
structure, it might cause failures somewhere.
Also, the existing code has the same possibility while turning on/off bsysscan,
right? So I feel it's already accepted.
(Of course, we must fix if it causes a real failure)

Best regards,
Hayato Kuroda
FUJITSU LIMITED

#4Jiří Kavalík
jiri.kavalik@comgate.cz
In reply to: Hayato Kuroda (Fujitsu) (#3)

Hi Kuroda-san,

Hmm, I'm not excited to modify the exposed data structure yet, unless

there is a

real issue.

Agreed. It was only a readability suggestion, not a fix for a real failure.
I checked again. CheckXidAlive is set only at the start of each change in
ReorderBufferProcessTXN(), before that change's catalog access. It is
cleared
only after the change loop, or on abort, where ResetLogicalStreamingState()
also resets the new depth counter. So it does not change while a scan is
open,
except on the error path, which v1 already handles. v1 looks complete to me.

Thanks for the patch.

Regards,
Jiří Kavalík

út 6. 10. 2026 v 11:22 odesílatel Hayato Kuroda (Fujitsu) <
kuroda.hayato@fujitsu.com> napsal:

Hi Jiří,

Thanks for the test. I understood that no issues were found for now.

One question while reading the patch, not a problem I could trigger: the

depth

is incremented in systable_beginscan* and decremented in

systable_endscan* only

if CheckXidAlive is valid, and that is evaluated separately at each end.

If

CheckXidAlive changed while a scan was open, the counter would be off by

one.

I could not find a path where that happens. Error paths look fine, since
AbortTransaction/AbortSubTransaction call ResetLogicalStreamingState().

If a

SysScanDesc field is acceptable despite the header concern, remembering

in the

scan whether it was counted would make the pairing explicit.

Hmm, I'm not excited to modify the exposed data structure yet, unless
there is a
real issue. Per my analysis, SysScanDescData only contains pointers (8
bytes),
it does not have any paddings. This meant we need to modify a size of the
data
structure, it might cause failures somewhere.
Also, the existing code has the same possibility while turning on/off
bsysscan,
right? So I feel it's already accepted.
(Of course, we must fix if it causes a real failure)

Best regards,
Hayato Kuroda
FUJITSU LIMITED

--
S pozdravem
Jiří Kavalík
jiri.kavalik@comgate.cz
Comgate a.s.
Gočárova třída 1754/48b, 500 02 Hradec Králové
www.comgate.cz

#5Zhijie Hou
houzhijie22@gmail.com
In reply to: Hayato Kuroda (Fujitsu) (#1)

Hi,

On Fri, Oct 2, 2026 at 3:33 PM Hayato Kuroda (Fujitsu)
<kuroda.hayato@fujitsu.com> wrote:

Hi,

This is the reply for [1]. My mailer could not receive the original post due to
the company's policy, so I will put as the normal post. Sorry for inconvenience.

I confirmed this could happen on PG18, PG17 and PG14. Not tested, but expecting
for PG15 and 166 as well. This could not happen on PG19/HEAD because the
elog(ERROR) was removed by 87f7b824f20, but possible for all branches.

I think your analysis is correct. bsysscan tries to indicate that whether we're
scanning a system table, which was turned on at systable_beginscan* and turned
off at systable_endscan*. But if the systable scan is nested (i.e., pg_constraint.conbin),
the flag can be wrong reset. In PG18- the state is checked for every getnextslot,
which raised the ERROR. In PG19+ the check is unified at the beginning thus the
ERROR does not happen, but I guess the flag can be still wrong.

One idea is to track the depth of scans. Attached patch is for PG18, and I tried not
to modify the header as much as possible. It also had a test code based on your
reproducer. Can you see it's same as your expectation?

I think using a counter to fix this is OK. But I'm wondering whether it's
necessary to keep both the boolean and the counter, could we merge them into a
single parameter to simplify things?

Best Regards,
Zhijie Hou

#6Hayato Kuroda (Fujitsu)
kuroda.hayato@fujitsu.com
In reply to: Zhijie Hou (#5)
RE: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641)

Dear Hou,

Thanks for the review!

I think using a counter to fix this is OK. But I'm wondering whether it's
necessary to keep both the boolean and the counter, could we merge them into
a
single parameter to simplify things?

Actually it's intentional because the initially attached patch was for PG18.
bsysscan was exported and functions in tableam.h referred it. I did not want to
modify the header as much as possible thus they were retained.

For HEAD, yes, the boolean can be removed from everywhere, see attached.
I will create patched for back branches when they are stabilized.

Best regards,
Hayato Kuroda
FUJITSU LIMITED

Attachments:

t254034_6
v2-HEAD-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=v2-HEAD-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+122-35
#7Jiří Kavalík
jiri.kavalik@comgate.cz
In reply to: Hayato Kuroda (Fujitsu) (#6)

Hi Kuroda-san,

For HEAD, yes, the boolean can be removed from everywhere, see attached.

One small thing in v2-HEAD: the definition in xact.c is left behind.
With the patch applied on master (061065e), "git grep -w bsysscan" still
finds

src/backend/access/transam/xact.c:103:bool bsysscan = false;

and since the extern is gone from xact.h, gcc 14 warns:

xact.c:103:17: warning: no previous declaration for 'bsysscan'
[-Wmissing-variable-declarations]

Removing that line should be enough. The comment above it in xact.c may also
want a word about the counter.

Regards,
Jiří Kavalík

čt 8. 10. 2026 v 4:36 odesílatel Hayato Kuroda (Fujitsu) <
kuroda.hayato@fujitsu.com> napsal:

Dear Hou,

Thanks for the review!

I think using a counter to fix this is OK. But I'm wondering whether it's
necessary to keep both the boolean and the counter, could we merge them

into

a
single parameter to simplify things?

Actually it's intentional because the initially attached patch was for
PG18.
bsysscan was exported and functions in tableam.h referred it. I did not
want to
modify the header as much as possible thus they were retained.

For HEAD, yes, the boolean can be removed from everywhere, see attached.
I will create patched for back branches when they are stabilized.

Best regards,
Hayato Kuroda
FUJITSU LIMITED

--
S pozdravem
Jiří Kavalík
jiri.kavalik@comgate.cz
Comgate a.s.
Gočárova třída 1754/48b, 500 02 Hradec Králové
www.comgate.cz

#8Hayato Kuroda (Fujitsu)
kuroda.hayato@fujitsu.com
In reply to: Jiří Kavalík (#7)
RE: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641)

Dear Jiří

Good catch. I accidentally removed the meson option " --werror" so that
I could not recognize. PSA fixed version.

Best regards,
Hayato Kuroda
FUJITSU LIMITED

Attachments:

t254034_8
v3-HEAD-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=v3-HEAD-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+122-36
#9Hayato Kuroda (Fujitsu)
kuroda.hayato@fujitsu.com
In reply to: Hayato Kuroda (Fujitsu) (#8)
RE: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641)

Hi members,

I made a patch set for supported branches. I confirmed the error can happen
and the patch can address the issue on PG14-PG18.

I refactored the test code for the readability. Wondering PG19/HEAD should contain
the test, because the reported ERROR could not happen in the first place.

Best regards,
Hayato Kuroda
FUJITSU LIMITED

Attachments:

t254034_9
nocfbot-v4-PG14-PG15-0001-Track-the-depth-of-scans-of-system-tabl.patchapplication/octet-stream; name=nocfbot-v4-PG14-PG15-0001-Track-the-depth-of-scans-of-system-tabl.patchDownload+117-30
v4-HEAD-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=v4-HEAD-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+120-36
nocfbot-v4-PG19-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=nocfbot-v4-PG19-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+119-35
nocfbot-v4-PG16-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=nocfbot-v4-PG16-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+119-30
nocfbot-v4-PG17-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=nocfbot-v4-PG17-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+119-30
nocfbot-v4-PG18-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=nocfbot-v4-PG18-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+119-30
#10Peter Smith
smithpb2250@gmail.com
In reply to: Hayato Kuroda (Fujitsu) (#9)

On Tue, Oct 27, 2026 at 12:25 AM Hayato Kuroda (Fujitsu)
<kuroda.hayato@fujitsu.com> wrote:

Hi members,

I made a patch set for supported branches. I confirmed the error can happen
and the patch can address the issue on PG14-PG18.

I refactored the test code for the readability. Wondering PG19/HEAD should contain
the test, because the reported ERROR could not happen in the first place.

Hi Kuroda-San,

Since you are refactoring this flag anyway, would it be better to try
to eliminate the global-variable completely? e.g. expose the same
information by some accessor function.

-extern PGDLLIMPORT bool bsysscan;
+extern PGDLLIMPORT int sysscan_depth;

======
Kind Regards,
Peter Smith.
Fujitsu Australia.

#11Hayato Kuroda (Fujitsu)
kuroda.hayato@fujitsu.com
In reply to: Peter Smith (#10)
RE: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641)

Hi Peter,

Since you are refactoring this flag anyway, would it be better to try
to eliminate the global-variable completely? e.g. expose the same
information by some accessor function.

-extern PGDLLIMPORT bool bsysscan;
+extern PGDLLIMPORT int sysscan_depth;

Good point, it can be removed by providing few functions. v5 did the same.
We need to keep bsysscan anyway for back branches, so the patch shape for them
is slightly different, see v5-PG18.

Best regards,
Hayato Kuroda
FUJITSU LIMITED

Attachments:

t254034_11
v5-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=v5-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+76-42
nocfbot-v5-PG18-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=nocfbot-v5-PG18-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+134-31
nocfbot-v5-PG19-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=nocfbot-v5-PG19-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+72-39
#12Chao Li
li.evan.chao@gmail.com
In reply to: Hayato Kuroda (Fujitsu) (#11)

On Oct 27, 2026, at 14:42, Hayato Kuroda (Fujitsu) <kuroda.hayato@fujitsu.com> wrote:

Hi Peter,

Since you are refactoring this flag anyway, would it be better to try
to eliminate the global-variable completely? e.g. expose the same
information by some accessor function.

-extern PGDLLIMPORT bool bsysscan;
+extern PGDLLIMPORT int sysscan_depth;

Good point, it can be removed by providing few functions. v5 did the same.
We need to keep bsysscan anyway for back branches, so the patch shape for them
is slightly different, see v5-PG18.

Best regards,
Hayato Kuroda
FUJITSU LIMITED

<v5-0001-Track-the-depth-of-scans-of-system-tables.patch><nocfbot-v5-PG18-0001-Track-the-depth-of-scans-of-system-tables.patch><nocfbot-v5-PG19-0001-Track-the-depth-of-scans-of-system-tables.patch>

Hi Hayato,

I agree with the solution. However, I have a minor concern about the naming. BeginSystemTableScan() and EndSystemTableScan() sound like functions that actually start and end system table scans, whereas they only track sysscan_depth. How about renaming them to TrackSystemTableScanStart() and TrackSystemTableScanEnd() to better reflect their purpose?

Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/

#13Hayato Kuroda (Fujitsu)
kuroda.hayato@fujitsu.com
In reply to: Chao Li (#12)
RE: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641)

Hi Chao,

I agree with the solution. However, I have a minor concern about the naming.
BeginSystemTableScan() and EndSystemTableScan() sound like functions that
actually start and end system table scans, whereas they only track sysscan_depth.
How about renaming them to TrackSystemTableScanStart() and
TrackSystemTableScanEnd() to better reflect their purpose?

+1, PSA new version.

Best regards,
Hayato Kuroda
FUJITSU LIMITED

Attachments:

t254034_13
nocfbot-v6-PG14-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=nocfbot-v6-PG14-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+133-30
nocfbot-v6-PG15-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=nocfbot-v6-PG15-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+133-30
nocfbot-v6-PG16-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=nocfbot-v6-PG16-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+135-30
nocfbot-v6-PG17-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=nocfbot-v6-PG17-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+134-31
nocfbot-v6-PG18-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=nocfbot-v6-PG18-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+134-31
nocfbot-v6-PG19-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=nocfbot-v6-PG19-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+72-39
v6-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=v6-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+76-42
#14Shlok Kyal
shlok.kyal.oss@gmail.com
In reply to: Hayato Kuroda (Fujitsu) (#13)

On Thu, 29 Oct 2026 at 10:22, Hayato Kuroda (Fujitsu)
<kuroda.hayato@fujitsu.com> wrote:

Hi Chao,

I agree with the solution. However, I have a minor concern about the naming.
BeginSystemTableScan() and EndSystemTableScan() sound like functions that
actually start and end system table scans, whereas they only track sysscan_depth.
How about renaming them to TrackSystemTableScanStart() and
TrackSystemTableScanEnd() to better reflect their purpose?

+1, PSA new version.

Hi Kuroda-san,

I have reviewed and tested the patches.
I am able to reproduce the issue in PG14 to PG18 using the test added
in stream.sql and confirm that the corresponding patches address the
issue.
Patches is applying cleanly on all branches and passed 'make check-world'

I have some minor comments:
1. For all patches: Most of the comments for function in the file
'xact.c' is like of format:
/*
* Function name
*
* Function Description
*/
Maybe we should follow the same for the functions added by these patches?

2. For patches for PG14 to PG18: In logical.c we can remove:
+#include "access/genam.h"
#include "access/xact.h"

In logical.c we only introduced "ResetSystemTableScanState();" and
this function which was declared 'access/xact.h'
logical.c already includes access/xact.h

3. For patches for PG 18 and PG 17: I noticed a unrelated line deletion change:
#include "utils/snapmgr.h"

-
/* ----------------------------------------------------------------

Was it intentional?

4. For patches for PG 14 and PG 15:
+ ALTER TABLE nested_sys_scan_test ALTER COLUMN checked_value set
storage external;
I think we should capitalize 'set storage external;'

Thanks,
Shlok Kyal

#15Hayato Kuroda (Fujitsu)
kuroda.hayato@fujitsu.com
In reply to: Shlok Kyal (#14)
RE: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641)

Hi Shlok,

Thanks for the review!

1. For all patches: Most of the comments for function in the file
'xact.c' is like of format:
/*
* Function name
*
* Function Description
*/
Maybe we should follow the same for the functions added by these patches?

I do not have strong opinions for it, but added accordingly.

2. For patches for PG14 to PG18: In logical.c we can remove:
+#include "access/genam.h"
#include "access/xact.h"

In logical.c we only introduced "ResetSystemTableScanState();" and
this function which was declared 'access/xact.h'
logical.c already includes access/xact.h

Fixed. It was included because functions are initially declared in genam.h.

3. For patches for PG 18 and PG 17: I noticed a unrelated line deletion change:
#include "utils/snapmgr.h"

-
/* ----------------------------------------------------------------

Was it intentional?

No, removed.

4. For patches for PG 14 and PG 15:
+ ALTER TABLE nested_sys_scan_test ALTER COLUMN checked_value set
storage external;
I think we should capitalize 'set storage external;'

+1. Fixed.

PSA new patch set.

Best regards,
Hayato Kuroda
FUJITSU LIMITED

Attachments:

t254034_15
nocfbot-v7-PG14-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=nocfbot-v7-PG14-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+138-30
nocfbot-v7-PG15-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=nocfbot-v7-PG15-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+138-30
nocfbot-v7-PG16-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=nocfbot-v7-PG16-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+140-30
nocfbot-v7-PG17-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=nocfbot-v7-PG17-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+139-30
nocfbot-v7-PG18-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=nocfbot-v7-PG18-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+139-30
nocfbot-v7-PG19-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=nocfbot-v7-PG19-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+80-39
v7-0001-Track-the-depth-of-scans-of-system-tables.patchapplication/octet-stream; name=v7-0001-Track-the-depth-of-scans-of-system-tables.patchDownload+84-42
#16Shlok Kyal
shlok.kyal.oss@gmail.com
In reply to: Hayato Kuroda (Fujitsu) (#15)

PSA new patch set.

Hi Kuroda-san,

I have reviewed the patches and it looks good to me.

Thanks,
Shlok Kyal