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(-)