[YSQL][Colocation] TRUNCATE TABLE breaks index consistency

[frozenspider]

Description

When using colocated database and tablegroup, TRUNCATE TABLE seem to only truncate the table, leaving index content intact.

Examples:

With colocated database:

CREATE DATABASE test_clc COLOCATED TRUE;
\c test_clc

CREATE TABLE tg1_table1(
  v1 int,
  v2 int UNIQUE,
  v3 text
);

INSERT INTO tg1_table1 VALUES (1, 1, 'v2'),  (1, 2, 'v2'), (3, 3, 'v2'), (4, 4, 'v2');
CREATE INDEX tg1_table1_v1_idx ON tg1_table1 (v1);

\d tg1_table1
             Table "public.tg1_table1"
 Column |  Type   | Collation | Nullable | Default
--------+---------+-----------+----------+---------
 v1     | integer |           |          |
 v2     | integer |           |          |
 v3     | text    |           |          |
Indexes:
    "tg1_table1_v2_key" UNIQUE CONSTRAINT, lsm (v2 ASC)
    "tg1_table1_v1_idx" lsm (v1 ASC)

SELECT v1 FROM tg1_table1 WHERE v1 IN (1, 2, 4);
 v1
----
  1
  1
  4
(3 rows)

SELECT v2 FROM tg1_table1 WHERE v2 IN (1, 2, 4);
 v2
----
  1
  2
  4
(3 rows)

SELECT * FROM tg1_table1 WHERE v2 IN (1, 2, 4);
 v1 | v2 | v3
----+----+----
  1 |  1 | v2
  1 |  2 | v2
  4 |  4 | v2
(3 rows)

TRUNCATE TABLE tg1_table1;

SELECT v1 FROM tg1_table1 WHERE v1 IN (1, 2, 4);
 v1
----
  1
  1
  4
(3 rows)

SELECT v2 FROM tg1_table1 WHERE v2 IN (1, 2, 4);
 v2
----
  1
  2
  4
(3 rows)

SELECT * FROM tg1_table1 WHERE v2 IN (1, 2, 4);
ERROR:  Query error: ybctid DocKey([], ["l\x07S{\xcb\xaeF_\xb6\x93,\xbd\xd3\x0c\x15\xeb"]) not found in indexed table

With tablegroup:

CREATE TABLEGROUP tg1;
CREATE TABLE tg1_table1(
  v1 int,
  v2 int UNIQUE,
  v3 text
) TABLEGROUP tg1;

INSERT INTO tg1_table1 VALUES (1, 1, 'v2'),  (1, 2, 'v2'), (3, 3, 'v2'), (4, 4, 'v2');
CREATE INDEX tg1_table1_v1_idx ON tg1_table1 (v1);

SELECT v1 FROM tg1_table1 WHERE v1 IN (1, 2, 4);
 v1
----
  1
  1
  4
(3 rows)

SELECT v2 FROM tg1_table1 WHERE v2 IN (1, 2, 4);
 v2
----
  1
  2
  4
(3 rows)

SELECT * FROM tg1_table1 WHERE v2 IN (1, 2, 4);
 v1 | v2 | v3
----+----+----
  1 |  1 | v2
  1 |  2 | v2
  4 |  4 | v2
(3 rows)

TRUNCATE TABLE tg1_table1;

SELECT v1 FROM tg1_table1 WHERE v1 IN (1, 2, 4);
 v1
----
  1
  1
  4
(3 rows)

SELECT v2 FROM tg1_table1 WHERE v2 IN (1, 2, 4);
 v2
----
  1
  2
  4
(3 rows)

SELECT * FROM tg1_table1 WHERE v2 IN (1, 2, 4);
ERROR:  Query error: ybctid DocKey([], ["\x99_U?\x85\xfaO\x7f\xabz\xe2\x8e\x0b:uM"]) not found in indexed table

[kripasreenivasan]

@lnguyen-yugabyte
Please backport this fix to 2.12