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