pgAdmin 4 commit: Add Reverse Engineered and Modified SQL tests for Mat

Add Reverse Engineered and Modified SQL tests for Materialized Views. Fixes #4696.

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=1a39dedc62d15e15977e43a6a73a391d803d453f
Author: Rahul Shirsat <rahul(dot)shirsat(at)enterprisedb(dot)com>

Modified Files
--------------
docs/en_US/release_notes_4_16.rst | 1 +
.../templates/mviews/pg/9.3_plus/sql/create.sql | 7 +-
.../templates/mviews/pg/9.4_plus/sql/create.sql | 7 +-
.../templates/mviews/pg/9.4_plus/sql/update.sql | 25 +-
.../templates/mviews/ppas/9.3_plus/sql/acl.sql | 1 +
.../templates/mviews/ppas/9.3_plus/sql/create.sql | 7 +-
.../templates/mviews/ppas/9.3_plus/sql/update.sql | 22 +-
.../templates/views/ppas/9.4_plus/sql/acl.sql | 1 +
.../views/tests/pg/9.4_plus/alter_mview.sql | 19 +-
.../pg/9.4_plus/alter_mview_add_fillfactor.sql | 16 +
.../9.4_plus/alter_mview_add_fillfactor_msql.sql | 6 +
.../9.4_plus/alter_mview_add_table_parameter.sql | 17 +
.../alter_mview_add_table_parameter_msql.sql | 4 +
.../tests/pg/9.4_plus/alter_mview_definition.sql | 12 +
.../pg/9.4_plus/alter_mview_definition_msql.sql | 4 +
.../pg/9.4_plus/alter_mview_drop_all_priv.sql | 17 +
.../pg/9.4_plus/alter_mview_drop_all_priv_msql.sql | 1 +
.../views/tests/pg/9.4_plus/alter_mview_msql.sql | 1 +
.../alter_mview_remove_table_parameter.sql | 16 +
.../alter_mview_remove_table_parameter_msql.sql | 6 +
.../schemas/views/tests/pg/9.4_plus/alter_view.sql | 2 -
.../tests/pg/9.4_plus/alter_view_add_some_priv.sql | 19 ++
.../pg/9.4_plus/alter_view_add_some_priv_msql.sql | 1 +
.../tests/pg/9.4_plus/alter_view_definition.sql | 18 ++
.../pg/9.4_plus/alter_view_definition_msql.sql | 4 +
.../tests/pg/9.4_plus/alter_view_delete_priv.sql | 18 ++
.../pg/9.4_plus/alter_view_delete_priv_msql.sql | 1 +
.../views/tests/pg/9.4_plus/alter_view_msql.sql | 7 +
.../views/tests/pg/9.4_plus/create_mview.sql | 16 +-
.../views/tests/pg/9.4_plus/create_mview_msql.sql | 11 +
.../views/tests/pg/9.4_plus/create_view_msql.sql | 12 +
.../views/tests/pg/9.4_plus/test_mview.json | 341 +++++++++++++++------
.../schemas/views/tests/pg/9.4_plus/tests.json | 106 ++++++-
.../views/tests/ppas/11_plus/alter_mview.sql | 18 ++
.../ppas/11_plus/alter_mview_add_fillfactor.sql | 16 +
.../11_plus/alter_mview_add_fillfactor_msql.sql | 6 +
.../11_plus/alter_mview_add_table_parameter.sql | 17 +
.../alter_mview_add_table_parameter_msql.sql | 4 +
.../tests/ppas/11_plus/alter_mview_definition.sql | 12 +
.../ppas/11_plus/alter_mview_definition_msql.sql | 4 +
.../ppas/11_plus/alter_mview_drop_all_priv.sql | 17 +
.../11_plus/alter_mview_drop_all_priv_msql.sql | 1 +
.../views/tests/ppas/11_plus/alter_mview_msql.sql | 1 +
.../11_plus/alter_mview_remove_table_parameter.sql | 16 +
.../alter_mview_remove_table_parameter_msql.sql | 6 +
.../views/tests/ppas/11_plus/alter_view.sql | 18 ++
.../ppas/11_plus/alter_view_add_some_priv.sql | 19 ++
.../ppas/11_plus/alter_view_add_some_priv_msql.sql | 1 +
.../tests/ppas/11_plus/alter_view_definition.sql | 18 ++
.../ppas/11_plus/alter_view_definition_msql.sql | 4 +
.../tests/ppas/11_plus/alter_view_delete_priv.sql | 18 ++
.../ppas/11_plus/alter_view_delete_priv_msql.sql | 1 +
.../views/tests/ppas/11_plus/alter_view_msql.sql | 7 +
.../views/tests/ppas/11_plus/create_mview.sql | 15 +
.../views/tests/ppas/11_plus/create_mview_msql.sql | 11 +
.../views/tests/ppas/11_plus/create_view.sql | 17 +
.../views/tests/ppas/11_plus/create_view_msql.sql | 12 +
.../views/tests/ppas/11_plus/test_mview.json | 256 ++++++++++++++++
.../schemas/views/tests/ppas/11_plus/tests.json | 178 +++++++++++
.../views/tests/ppas/9.4_plus/alter_mview.sql | 19 +-
.../ppas/9.4_plus/alter_mview_add_fillfactor.sql | 16 +
.../9.4_plus/alter_mview_add_fillfactor_msql.sql | 6 +
.../9.4_plus/alter_mview_add_table_parameter.sql | 17 +
.../alter_mview_add_table_parameter_msql.sql | 4 +
.../tests/ppas/9.4_plus/alter_mview_definition.sql | 12 +
.../ppas/9.4_plus/alter_mview_definition_msql.sql | 4 +
.../ppas/9.4_plus/alter_mview_drop_all_priv.sql | 17 +
.../9.4_plus/alter_mview_drop_all_priv_msql.sql | 1 +
.../views/tests/ppas/9.4_plus/alter_mview_msql.sql | 1 +
.../alter_mview_remove_table_parameter.sql | 16 +
.../alter_mview_remove_table_parameter_msql.sql | 6 +
.../views/tests/ppas/9.4_plus/alter_view.sql | 12 +-
.../ppas/9.4_plus/alter_view_add_some_priv.sql | 19 ++
.../9.4_plus/alter_view_add_some_priv_msql.sql | 1 +
.../tests/ppas/9.4_plus/alter_view_definition.sql | 18 ++
.../ppas/9.4_plus/alter_view_definition_msql.sql | 4 +
.../tests/ppas/9.4_plus/alter_view_delete_priv.sql | 18 ++
.../ppas/9.4_plus/alter_view_delete_priv_msql.sql | 1 +
.../views/tests/ppas/9.4_plus/alter_view_msql.sql | 7 +
.../views/tests/ppas/9.4_plus/create_mview.sql | 16 +-
.../tests/ppas/9.4_plus/create_mview_msql.sql | 11 +
.../views/tests/ppas/9.4_plus/create_view.sql | 4 -
.../views/tests/ppas/9.4_plus/create_view_msql.sql | 12 +
.../views/tests/ppas/9.4_plus/test_mview.json | 341 +++++++++++++++------
.../schemas/views/tests/ppas/9.4_plus/tests.json | 138 +++++++--
85 files changed, 1878 insertions(+), 282 deletions(-)