pgAdmin 4 commit: Add Reverse Engineered and Modified SQL tests for Mat - Mailing list pgadmin-hackers

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.shirsat@enterprisedb.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(-)