pgsql: pg_stat_statements: Fix handling of duplicate constant locations - Mailing list pgsql-committers

From Álvaro Herrera
Subject pgsql: pg_stat_statements: Fix handling of duplicate constant locations
Date
Msg-id E1vE4Sz-0044Ua-01@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
pg_stat_statements: Fix handling of duplicate constant locations

Two or more constants can have the same location.  We handled this
correctly for non squashed constants, but failed to do it if squashed
(resulting in out-of-bounds memory access), because the code structure
became broken by commit 0f65f3eec478: we failed to update 'last_loc'
correctly when skipping these squashed constants.

The simplest fix seems to be to get rid of 'last_loc' altogether -- in
hindsight, it's quite pointless.  Also, when ignoring a constant because
of this, make sure to fulfill fill_in_constant_lengths's duty of setting
its length to -1.

Lastly, we can use == instead of <= because the locations have been
sorted beforehand, so the < case cannot arise.

Co-authored-by: Sami Imseih <samimseih@gmail.com>
Co-authored-by: Dmitry Dolgov <9erthalion6@gmail.com>
Reported-by: Konstantin Knizhnik <knizhnik@garret.ru>
Backpatch-through: 18
Discussion: https://www.postgresql.org/message-id/2b91e358-0d99-43f7-be44-d2d4dbce37b3%40garret.ru

Branch
------
REL_18_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/b1635c166698a2b70aa3f397d0f7ca6844872dce

Modified Files
--------------
contrib/pg_stat_statements/expected/squashing.out | 80 +++++++++++++++++++++++
contrib/pg_stat_statements/pg_stat_statements.c   | 33 +++++-----
contrib/pg_stat_statements/sql/squashing.sql      | 26 ++++++++
3 files changed, 123 insertions(+), 16 deletions(-)


pgsql-committers by date:

Previous
From: Álvaro Herrera
Date:
Subject: pgsql: pg_stat_statements: Fix handling of duplicate constant locations
Next
From: Masahiko Sawada
Date:
Subject: Re: pgsql: Add mem_exceeded_count column to pg_stat_replication_slots.