Yifan Guan

[YSQL] ysql_dump omits SPLIT INTO/SPLIT AT clause for an index after ALTER TABLE ADD UNIQUE constraint using the index

3

Jira Link: [DB-982](https://yugabyte.atlassian.net/browse/DB-982) ### Description For backup, ysql_dump omits the number of tablets specified by the SPLIT INTO/SPLIT AT clause for an index creation after ALTER TABLE ADD UNIQUE constraint...

[YSQL] Colocation: Create table partition fails with colocation option

1

Jira Link: [DB-9268](https://yugabyte.atlassian.net/browse/DB-9268) ### Description For colocation, `CREATE PARTITION OF ... WITH (COLOCATION=FALSE/TRUE)` fails. Example: ``` db1=# CREATE TABLE p4 PARTITION OF t FOR VALUES IN (4) WITH (COLOCATION=FALSE); ERROR:...

Jira Link: [DB-11225](https://yugabyte.atlassian.net/browse/DB-11225) ### Description For colocation regression tests, costs of query plan are irrelevant, so remove costs from test output to benefit PG15 upgrade. ### Issue Type kind/enhancement ###...

Jira Link: [DB-11260](https://yugabyte.atlassian.net/browse/DB-11260) ### Description `yb_get_range_split_clause` failed to decode GinNull in GIN Index partition bounds. It is used by `ysql_dump` to generate YSQL table and index `SPLIT AT` clause during...

Jira Link: [DB-2977](https://yugabyte.atlassian.net/browse/DB-2977) ### Description See the example below: ``` CREATE USER abcdefg; SET SESSION AUTHORIZATION abcdefg; // backup && restore SET SESSION AUTHORIZATION abcdefg; ERROR: role "abcdefg" does not...

Jira Link: [DB-11785](https://yugabyte.atlassian.net/browse/DB-11785) ### Description Auto-Analyze service should ignore and clean up entries corresponding to deleted tables (either due to DROP TABLE or DROP DATABASE). This is one enhancement. ###...

Jira Link: [DB-13415](https://yugabyte.atlassian.net/browse/DB-13415) ### Description This is one item to keep track of incremental catalog cache refresh for auto analyze. Incremental catalog cache refresh is a general optimization. It benefits...