pgsql: Fix CREATE TABLE LIKE INCLUDING GENERATED column order issue
| От | Peter Eisentraut |
|---|---|
| Тема | pgsql: Fix CREATE TABLE LIKE INCLUDING GENERATED column order issue |
| Дата | |
| Msg-id | E1jMYNd-00087S-63@gemulon.postgresql.org обсуждение исходный текст |
| Список | pgsql-committers |
Fix CREATE TABLE LIKE INCLUDING GENERATED column order issue CREATE TABLE LIKE INCLUDING GENERATED would fail if a generated column referred to a column with a higher attribute number. This is because the column mapping mechanism created the mapping incrementally as columns are added. This was sufficient for previous uses of that mechanism (omitting dropped columns), and it also happened to work if generated columns only referred to columns with lower attribute numbers, but here it failed. This fix is to build the attribute mapping in a separate loop before processing the columns in detail. Bug: #16342 Reported-by: Ethan Waldo <ewaldo@healthetechs.com> Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us> Branch ------ REL_12_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/f06d583c5ad7a6a129d846103225448861f2df0d Modified Files -------------- src/backend/parser/parse_utilcmd.c | 25 ++++++++++++++++++--- src/test/regress/expected/create_table_like.out | 29 +++++++++++++------------ src/test/regress/sql/create_table_like.sql | 19 ++++++++-------- 3 files changed, 47 insertions(+), 26 deletions(-)
В списке pgsql-committers по дате отправления: