1) Add Reverse Engineered and Modified SQL tests for Indexes. Fixes #4621 2) Fix modified SQL for Index when reset the value of Fill factor and Clustered?. Fixes #4702 3) Fix reversed engineered SQL for btree Index when provided sort order and NULLs. Fixes #4703
Branch ------ master Details ------- https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=8e4e8b3e5ae134eab50cec94c7e05caf63de872f Modified Files -------------- docs/en_US/release_notes_4_13.rst | 5 +- .../databases/schemas/tables/indexes/__init__.py | 23 +- .../default/alter_name_fillfactor_comment.sql | 15 ++ .../default/alter_name_fillfactor_comment_msql.sql | 11 + .../default/alter_reset_fillfactor_cluster.sql | 11 + .../alter_reset_fillfactor_cluster_msql.sql | 5 + .../tests/default/create_btree_asc_null_first.sql | 13 ++ .../default/create_btree_asc_null_first_msql.sql | 9 + .../tests/default/create_btree_asc_null_last.sql | 13 ++ .../default/create_btree_asc_null_last_msql.sql | 9 + .../tests/default/create_btree_desc_null_first.sql | 8 + .../default/create_btree_desc_null_first_msql.sql | 4 + .../tests/default/create_btree_desc_null_last.sql | 13 ++ .../default/create_btree_desc_null_last_msql.sql | 9 + .../indexes/tests/default/create_hash_index.sql | 8 + .../tests/default/create_hash_index_msql.sql | 4 + .../tables/indexes/tests/default/test_indexes.json | 251 +++++++++++++++++++++ .../indexes/sql/11_plus/column_details.sql | 4 +- .../templates/indexes/sql/11_plus/create.sql | 4 +- .../indexes/sql/default/column_details.sql | 4 +- .../templates/indexes/sql/default/create.sql | 4 +- .../templates/indexes/sql/default/update.sql | 16 +- 22 files changed, 429 insertions(+), 14 deletions(-)
