pgAdmin 4 commit: Added RESQL/MSQL test cases for Table and its child n

Added RESQL/MSQL test cases for Table and its child nodes. Fixes #4622

Branch
------
master

Details
-------
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=b2042f48cd18ea6dbd42aeadc0742835cca9421d
Author: Yogesh Mahajan <yogesh(dot)mahajan(at)enterprisedb(dot)com>

Modified Files
--------------
docs/en_US/release_notes_5_4.rst | 1 +
.../alter_column_text_with_default_value.msql | 4 +
.../alter_column_text_with_default_value.sql | 11 +
...imestamp_with_default_value_using_function.msql | 7 +
...timestamp_with_default_value_using_function.sql | 9 +
...ter_column_with_interger_array_and_options.msql | 3 +
...lter_column_with_interger_array_and_options.sql | 13 +
.../tests/pg/10_plus/create_column_char.msql | 4 +-
.../create_column_identity_for_restart_seq.msql | 2 +-
.../tests/pg/10_plus/create_column_int.msql | 4 +-
.../pg/10_plus/create_column_int_identity.msql | 4 +-
.../create_column_int_identity_by_default.msql | 4 +-
.../create_column_text_with_default_value.msql | 5 +
.../create_column_text_with_default_value.sql | 9 +
...imestamp_with_default_value_using_function.msql | 5 +
...timestamp_with_default_value_using_function.sql | 9 +
...ate_column_with_interger_array_and_options.msql | 9 +
...eate_column_with_interger_array_and_options.sql | 13 +
.../tables/columns/tests/pg/10_plus/test.json | 189 +-
.../tests/pg/12_plus/alter_column_char.msql | 4 +-
.../alter_column_text_with_default_value.msql | 4 +
.../alter_column_text_with_default_value.sql | 11 +
...imestamp_with_default_value_using_function.msql | 7 +
...timestamp_with_default_value_using_function.sql | 9 +
...ter_column_with_interger_array_and_options.msql | 3 +
...lter_column_with_interger_array_and_options.sql | 13 +
.../tests/pg/12_plus/create_column_char.msql | 4 +-
.../tests/pg/12_plus/create_column_int.msql | 4 +-
.../pg/12_plus/create_column_int_generated.msql | 4 +-
...column_int_generated_with_existing_columns.msql | 4 +-
.../pg/12_plus/create_column_int_identity.msql | 4 +-
.../create_column_int_identity_by_default.msql | 4 +-
.../create_column_text_with_default_value.msql | 5 +
.../create_column_text_with_default_value.sql | 9 +
...imestamp_with_default_value_using_function.msql | 5 +
...timestamp_with_default_value_using_function.sql | 9 +
...ate_column_with_interger_array_and_options.msql | 9 +
...eate_column_with_interger_array_and_options.sql | 13 +
.../tables/columns/tests/pg/12_plus/test.json | 587 ++++--
.../tests/pg/default/create_column_char.msql | 4 +-
.../tests/pg/default/create_column_int.msql | 4 +-
.../tables/columns/tests/pg/default/test.json | 182 +-
.../alter_column_text_with_default_value.msql | 13 +
.../alter_column_text_with_default_value.sql | 11 +
.../tests/ppas/10_plus/create_column_char.msql | 4 +-
.../create_column_identity_for_restart_seq.msql | 2 +-
.../tests/ppas/10_plus/create_column_int.msql | 4 +-
.../ppas/10_plus/create_column_int_identity.msql | 4 +-
.../create_column_int_identity_by_default.msql | 4 +-
.../tables/columns/tests/ppas/10_plus/test.json | 21 +-
.../tests/ppas/12_plus/create_column_char.msql | 4 +-
.../create_column_identity_for_restart_seq.msql | 2 +-
.../tests/ppas/12_plus/create_column_int.msql | 4 +-
.../ppas/12_plus/create_column_int_generated.msql | 4 +-
...column_int_generated_with_existing_columns.msql | 4 +-
.../ppas/12_plus/create_column_int_identity.msql | 4 +-
.../create_column_int_identity_by_default.msql | 4 +-
.../tables/columns/tests/ppas/12_plus/test.json | 421 +++--
.../tests/ppas/default/create_column_char.msql | 4 +-
.../tests/ppas/default/create_column_int.msql | 4 +-
.../tables/columns/tests/ppas/default/test.json | 182 +-
...straint.sql => alter_check_constraint_msql.sql} | 0
.../tests/Default/create_check_constraint_msql.sql | 6 +
.../Default/create_check_constraint_with_valid.sql | 9 +
.../create_check_constraint_with_valid_msql.sql | 5 +
.../check_constraint/tests/Default/test.json | 20 +-
...int.sql => alter_exclusion_constraint_msql.sql} | 0
.../create_exclusion_constraint_exp_msql.sql | 10 +
.../11_plus/create_exclusion_constraint_msql.sql | 10 +
.../exclusion_constraint/tests/11_plus/test.json | 101 +-
...int.sql => alter_exclusion_constraint_msql.sql} | 0
...actor.sql => alter_without_fillfactor_msql.sql} | 0
.../default/create_exclusion_constraint_msql.sql | 9 +
.../default/create_without_fillfactor_msql.sql | 7 +
.../default/exclusion_constraint_exp_msql.sql | 10 +
.../exclusion_constraint/tests/default/test.json | 98 +-
.../tables/indexes/tests/default/test_indexes.json | 36 +-
.../10_plus/alter_delete_policy_with_using.sql | 10 +
.../alter_delete_policy_with_using_msql.sql | 2 +
.../tests/10_plus/alter_select_policy.sql | 10 +
.../tests/10_plus/alter_select_policy_msql.sql | 2 +
.../tests/10_plus/alter_simple_all_policy.sql | 11 +
.../tests/10_plus/alter_simple_all_policy_msql.sql | 5 +
.../tests/10_plus/alter_simple_insert_policy.sql | 10 +
.../10_plus/alter_simple_insert_policy_msql.sql | 2 +
.../alter_update_policy_with_check_and_using.sql | 11 +
...ter_update_policy_with_check_and_using_msql.sql | 5 +
.../10_plus/create_delete_policy_with_using.sql | 10 +
.../create_delete_policy_with_using_msql.sql | 6 +
.../tests/10_plus/create_insert_policy.sql | 9 -
.../tests/10_plus/create_select_policy.sql | 6 +-
.../tests/10_plus/create_select_policy_msql.sql | 5 +
.../tests/10_plus/create_simple_all_policy.sql | 9 +
.../10_plus/create_simple_all_policy_msql.sql | 5 +
.../tests/10_plus/create_simple_insert_policy.sql | 9 +
.../10_plus/create_simple_insert_policy_msql.sql | 5 +
.../create_update_policy_with_check_and_using.sql | 11 +
...ate_update_policy_with_check_and_using_msql.sql | 7 +
.../row_security_policies/tests/10_plus/test.json | 184 +-
.../tests/12_plus/alter_select_policy.sql | 10 +
.../tests/12_plus/alter_simple_insert_policy.sql | 10 +
.../alter_update_policy_with_check_and_using.sql | 11 +
.../12_plus/create_delete_policy_with_using.sql | 10 +
.../row_security_policies/tests/12_plus/test.json | 275 +++
.../default/alter_delete_policy_with_using.sql | 9 +
.../alter_delete_policy_with_using_msql.sql | 2 +
.../default/alter_insert_policy_with_check.sql | 9 +
.../alter_insert_policy_with_check_msql.sql | 5 +
.../tests/default/alter_policy.sql | 9 -
.../tests/default/alter_policy_msql.sql | 2 -
.../tests/default/alter_select_policy.sql | 9 +
.../tests/default/alter_select_policy_msql.sql | 2 +
.../tests/default/alter_simple_all_policy.sql | 10 +
.../tests/default/alter_simple_all_policy_msql.sql | 5 +
.../tests/default/alter_simple_insert_policy.sql | 9 +
.../default/alter_simple_insert_policy_msql.sql | 2 +
.../alter_update_policy_with_check_and_using.sql | 10 +
...ter_update_policy_with_check_and_using_msql.sql | 5 +
.../tests/default/create_all_event_policy.sql | 11 -
.../default/create_delete_policy_with_using.sql | 9 +
.../create_delete_policy_with_using_msql.sql | 5 +
.../tests/default/create_insert_policy.sql | 9 -
.../default/create_insert_policy_with_check.sql | 9 +
.../create_insert_policy_with_check_msql.sql | 5 +
.../tests/default/create_public_policy.sql | 9 -
.../tests/default/create_select_policy.sql | 7 +-
.../tests/default/create_select_policy_msql.sql | 4 +
.../tests/default/create_simple_all_policy.sql | 8 +
.../default/create_simple_all_policy_msql.sql | 4 +
.../tests/default/create_simple_insert_policy.sql | 8 +
.../default/create_simple_insert_policy_msql.sql | 4 +
.../create_update_policy_with_check_and_using.sql | 10 +
...ate_update_policy_with_check_and_using_msql.sql | 6 +
.../row_security_policies/tests/default/test.json | 162 +-
.../schemas/tables/rules/tests/default/test.json | 30 +-
.../pg/10_plus/alter_table_with_toast_table.sql | 33 +
.../10_plus/alter_table_with_toast_table_msql.sql | 15 +
.../pg/10_plus/create_table_with_partition.sql | 28 +
.../10_plus/create_table_with_partition_msql.sql | 18 +
.../10_plus/create_table_with_range_partition.sql | 25 +
.../create_table_with_range_partition_msql.sql | 15 +
.../schemas/tables/tests/pg/10_plus/test.json | 1836 ++++++++++++++++++
.../pg/11_plus/alter_table_with_toast_table.sql | 33 +
.../11_plus/alter_table_with_toast_table_msql.sql | 14 +
.../11_plus/create_table_with_hash_partition.sql | 28 +
.../create_table_with_hash_partition_msql.sql | 18 +
.../schemas/tables/tests/pg/11_plus/test.json | 1986 ++++++++++++++++++++
.../pg/12_plus/alter_table_add_another_fk.sql | 31 +
.../pg/12_plus/alter_table_add_another_fk_msql.sql | 6 +
.../tests/pg/12_plus/alter_table_add_cols.sql | 20 +
.../tests/pg/12_plus/alter_table_add_cols_msql.sql | 5 +
.../12_plus/alter_table_add_exclude_constraint.sql | 34 +
.../alter_table_add_exclude_constraint_msql.sql | 3 +
.../alter_table_add_null_constraint_rename_col.sql | 22 +
...r_table_add_null_constraint_rename_col_msql.sql | 5 +
.../tests/pg/12_plus/alter_table_add_partition.sql | 34 +
.../alter_table_add_pk_not_null_constraint.sql | 22 +
...alter_table_add_pk_not_null_constraint_msql.sql | 4 +
.../pg/12_plus/alter_table_add_unique_const.sql | 28 +
.../12_plus/alter_table_add_unique_const_msql.sql | 3 +
.../12_plus/alter_table_change_col_data_type.sql | 21 +
.../alter_table_change_col_data_type_msql.sql | 8 +
.../tests/pg/12_plus/alter_table_delete_cols.sql | 19 +
.../pg/12_plus/alter_table_delete_cols_msql.sql | 1 +
.../pg/12_plus/alter_table_delete_constraints.sql | 22 +
.../alter_table_delete_constraints_msql.sql | 2 +
.../tests/pg/12_plus/alter_table_update_grants.sql | 24 +
.../pg/12_plus/alter_table_update_grants2.sql | 26 +
.../pg/12_plus/alter_table_update_grants2_msql.sql | 7 +
.../pg/12_plus/alter_table_update_grants_msql.sql | 7 +
.../pg/12_plus/alter_table_with_toast_table.sql | 33 +
.../12_plus/alter_table_with_toast_table_msql.sql | 14 +
.../12_plus/create_table_with_advanced_options.sql | 26 +
.../create_table_with_advanced_options_msql.sql | 21 +
.../create_table_with_custom_autovacuum.sql | 29 +
.../create_table_with_custom_autovacuum_msql.sql | 24 +
.../tests/pg/12_plus/create_table_with_fk.sql | 26 +
.../tests/pg/12_plus/create_table_with_fk_msql.sql | 21 +
.../12_plus/create_table_with_hash_partition.sql | 24 +
.../create_table_with_hash_partition_msql.sql | 15 +
.../tests/pg/12_plus/create_table_with_lik_tbl.sql | 19 +
.../pg/12_plus/create_table_with_lik_tbl_msql.sql | 16 +
.../pg/12_plus/create_table_with_partition.sql | 24 +
.../12_plus/create_table_with_partition_msql.sql | 15 +
.../tests/pg/12_plus/create_table_with_pk.sql | 18 +
.../tests/pg/12_plus/create_table_with_pk_chk.sql | 26 +
.../pg/12_plus/create_table_with_pk_chk_msql.sql | 20 +
.../tests/pg/12_plus/create_table_with_pk_msql.sql | 12 +
.../12_plus/create_table_with_range_partition.sql | 21 +
.../create_table_with_range_partition_msql.sql | 12 +
.../12_plus/create_table_without_primary_key.sql | 21 +
.../create_table_without_primary_key_msql.sql | 15 +
.../schemas/tables/tests/pg/12_plus/test.json | 1986 ++++++++++++++++++++
.../pg/default/alter_table_add_another_fk.sql | 33 +
.../pg/default/alter_table_add_another_fk_msql.sql | 6 +
.../tests/pg/default/alter_table_add_cols.sql | 22 +
.../tests/pg/default/alter_table_add_cols_msql.sql | 5 +
.../default/alter_table_add_exclude_constraint.sql | 36 +
.../alter_table_add_exclude_constraint_msql.sql | 3 +
.../alter_table_add_null_constraint_rename_col.sql | 24 +
...r_table_add_null_constraint_rename_col_msql.sql | 5 +
.../alter_table_add_pk_not_null_constraint.sql | 24 +
...alter_table_add_pk_not_null_constraint_msql.sql | 4 +
.../pg/default/alter_table_add_unique_const.sql | 30 +
.../default/alter_table_add_unique_const_msql.sql | 3 +
.../default/alter_table_change_col_data_type.sql | 23 +
.../alter_table_change_col_data_type_msql.sql | 8 +
.../tests/pg/default/alter_table_delete_cols.sql | 21 +
.../pg/default/alter_table_delete_cols_msql.sql | 1 +
.../pg/default/alter_table_delete_constraints.sql | 24 +
.../alter_table_delete_constraints_msql.sql | 2 +
.../tests/pg/default/alter_table_update_grants.sql | 24 +
.../pg/default/alter_table_update_grants2.sql | 26 +
.../pg/default/alter_table_update_grants2_msql.sql | 7 +
.../pg/default/alter_table_update_grants_msql.sql | 7 +
.../pg/default/alter_table_with_toast_table.sql | 33 +
.../default/alter_table_with_toast_table_msql.sql | 14 +
.../default/create_table_with_advanced_options.sql | 26 +
.../create_table_with_advanced_options_msql.sql | 21 +
.../create_table_with_custom_autovacuum.sql | 29 +
.../create_table_with_custom_autovacuum_msql.sql | 24 +
.../tests/pg/default/create_table_with_fk.sql | 28 +
.../tests/pg/default/create_table_with_fk_msql.sql | 24 +
.../tests/pg/default/create_table_with_lik_tbl.sql | 21 +
.../pg/default/create_table_with_lik_tbl_msql.sql | 19 +
.../tests/pg/default/create_table_with_pk.sql | 20 +
.../tests/pg/default/create_table_with_pk_chk.sql | 28 +
.../pg/default/create_table_with_pk_chk_msql.sql | 23 +
.../tests/pg/default/create_table_with_pk_msql.sql | 15 +
.../default/create_table_without_primary_key.sql | 23 +
.../create_table_without_primary_key_msql.sql | 18 +
.../schemas/tables/tests/pg/default/test.json | 1538 +++++++++++++++
.../ppas/10_plus/alter_table_with_toast_table.sql | 33 +
.../10_plus/alter_table_with_toast_table_msql.sql | 15 +
.../ppas/10_plus/create_table_with_partition.sql | 28 +
.../10_plus/create_table_with_partition_msql.sql | 18 +
.../10_plus/create_table_with_range_partition.sql | 25 +
.../create_table_with_range_partition_msql.sql | 15 +
.../schemas/tables/tests/ppas/10_plus/test.json | 1836 ++++++++++++++++++
.../ppas/11_plus/alter_table_with_toast_table.sql | 33 +
.../11_plus/alter_table_with_toast_table_msql.sql | 14 +
.../11_plus/create_table_with_hash_partition.sql | 28 +
.../create_table_with_hash_partition_msql.sql | 18 +
.../schemas/tables/tests/ppas/11_plus/test.json | 1986 ++++++++++++++++++++
.../ppas/12_plus/alter_table_add_another_fk.sql | 31 +
.../12_plus/alter_table_add_another_fk_msql.sql | 6 +
.../tests/ppas/12_plus/alter_table_add_cols.sql | 20 +
.../ppas/12_plus/alter_table_add_cols_msql.sql | 5 +
.../12_plus/alter_table_add_exclude_constraint.sql | 34 +
.../alter_table_add_exclude_constraint_msql.sql | 3 +
.../alter_table_add_null_constraint_rename_col.sql | 22 +
...r_table_add_null_constraint_rename_col_msql.sql | 5 +
.../ppas/12_plus/alter_table_add_partition.sql | 34 +
.../alter_table_add_pk_not_null_constraint.sql | 22 +
...alter_table_add_pk_not_null_constraint_msql.sql | 4 +
.../ppas/12_plus/alter_table_add_unique_const.sql | 28 +
.../12_plus/alter_table_add_unique_const_msql.sql | 3 +
.../12_plus/alter_table_change_col_data_type.sql | 21 +
.../alter_table_change_col_data_type_msql.sql | 8 +
.../tests/ppas/12_plus/alter_table_delete_cols.sql | 19 +
.../ppas/12_plus/alter_table_delete_cols_msql.sql | 1 +
.../12_plus/alter_table_delete_constraints.sql | 22 +
.../alter_table_delete_constraints_msql.sql | 2 +
.../ppas/12_plus/alter_table_update_grants.sql | 24 +
.../ppas/12_plus/alter_table_update_grants2.sql | 26 +
.../12_plus/alter_table_update_grants2_msql.sql | 7 +
.../12_plus/alter_table_update_grants_msql.sql | 7 +
.../ppas/12_plus/alter_table_with_toast_table.sql | 33 +
.../12_plus/alter_table_with_toast_table_msql.sql | 14 +
.../12_plus/create_table_with_advanced_options.sql | 26 +
.../create_table_with_advanced_options_msql.sql | 21 +
.../create_table_with_custom_autovacuum.sql | 29 +
.../create_table_with_custom_autovacuum_msql.sql | 24 +
.../tests/ppas/12_plus/create_table_with_fk.sql | 26 +
.../ppas/12_plus/create_table_with_fk_msql.sql | 21 +
.../12_plus/create_table_with_hash_partition.sql | 24 +
.../create_table_with_hash_partition_msql.sql | 15 +
.../ppas/12_plus/create_table_with_lik_tbl.sql | 19 +
.../12_plus/create_table_with_lik_tbl_msql.sql | 16 +
.../ppas/12_plus/create_table_with_partition.sql | 24 +
.../12_plus/create_table_with_partition_msql.sql | 15 +
.../tests/ppas/12_plus/create_table_with_pk.sql | 18 +
.../ppas/12_plus/create_table_with_pk_chk.sql | 26 +
.../ppas/12_plus/create_table_with_pk_chk_msql.sql | 20 +
.../ppas/12_plus/create_table_with_pk_msql.sql | 12 +
.../12_plus/create_table_with_range_partition.sql | 21 +
.../create_table_with_range_partition_msql.sql | 12 +
.../12_plus/create_table_without_primary_key.sql | 21 +
.../create_table_without_primary_key_msql.sql | 15 +
.../schemas/tables/tests/ppas/12_plus/test.json | 1986 ++++++++++++++++++++
.../ppas/default/alter_table_add_another_fk.sql | 33 +
.../default/alter_table_add_another_fk_msql.sql | 6 +
.../tests/ppas/default/alter_table_add_cols.sql | 22 +
.../ppas/default/alter_table_add_cols_msql.sql | 5 +
.../default/alter_table_add_exclude_constraint.sql | 36 +
.../alter_table_add_exclude_constraint_msql.sql | 3 +
.../alter_table_add_null_constraint_rename_col.sql | 24 +
...r_table_add_null_constraint_rename_col_msql.sql | 5 +
.../alter_table_add_pk_not_null_constraint.sql | 24 +
...alter_table_add_pk_not_null_constraint_msql.sql | 4 +
.../ppas/default/alter_table_add_unique_const.sql | 30 +
.../default/alter_table_add_unique_const_msql.sql | 3 +
.../default/alter_table_change_col_data_type.sql | 23 +
.../alter_table_change_col_data_type_msql.sql | 8 +
.../tests/ppas/default/alter_table_delete_cols.sql | 21 +
.../ppas/default/alter_table_delete_cols_msql.sql | 1 +
.../default/alter_table_delete_constraints.sql | 24 +
.../alter_table_delete_constraints_msql.sql | 2 +
.../ppas/default/alter_table_update_grants.sql | 24 +
.../ppas/default/alter_table_update_grants2.sql | 26 +
.../default/alter_table_update_grants2_msql.sql | 7 +
.../default/alter_table_update_grants_msql.sql | 7 +
.../ppas/default/alter_table_with_toast_table.sql | 33 +
.../default/alter_table_with_toast_table_msql.sql | 14 +
.../default/create_table_with_advanced_options.sql | 26 +
.../create_table_with_advanced_options_msql.sql | 21 +
.../create_table_with_custom_autovacuum.sql | 29 +
.../create_table_with_custom_autovacuum_msql.sql | 24 +
.../tests/ppas/default/create_table_with_fk.sql | 28 +
.../ppas/default/create_table_with_fk_msql.sql | 24 +
.../ppas/default/create_table_with_lik_tbl.sql | 21 +
.../default/create_table_with_lik_tbl_msql.sql | 19 +
.../tests/ppas/default/create_table_with_pk.sql | 20 +
.../ppas/default/create_table_with_pk_chk.sql | 28 +
.../ppas/default/create_table_with_pk_chk_msql.sql | 23 +
.../ppas/default/create_table_with_pk_msql.sql | 15 +
.../default/create_table_without_primary_key.sql | 23 +
.../create_table_without_primary_key_msql.sql | 18 +
.../schemas/tables/tests/ppas/default/test.json | 1538 +++++++++++++++
..._after_delete_event_trigger_with_transition.sql | 16 +
...r_delete_event_trigger_with_transition_msql.sql | 2 +
..._after_insert_event_trigger_with_transition.sql | 16 +
...r_insert_event_trigger_with_transition_msql.sql | 2 +
...er_after_update_event_trigger_enable_always.sql | 16 +
...ter_update_event_trigger_enable_always_msql.sql | 2 +
..._before_update_event_trigger_enable_replica.sql | 16 +
..._after_delete_event_trigger_with_transition.sql | 13 +
...r_delete_event_trigger_with_transition_msql.sql | 9 +
..._after_insert_event_trigger_with_transition.sql | 13 +
...r_insert_event_trigger_with_transition_msql.sql | 9 +
.../10_plus/create_after_update_event_trigger.sql | 13 +
.../create_after_update_event_trigger_msql.sql | 9 +
...r_update_event_trigger_with_transition_msql.sql | 10 +
.../10_plus/create_before_update_event_trigger.sql | 13 +
.../tables/triggers/tests/pg/10_plus/test.json | 312 +++
..._after_delete_event_trigger_with_transition.sql | 16 +
...r_delete_event_trigger_with_transition_msql.sql | 2 +
..._after_insert_event_trigger_with_transition.sql | 16 +
...r_insert_event_trigger_with_transition_msql.sql | 2 +
...er_after_update_event_trigger_enable_always.sql | 16 +
...ter_update_event_trigger_enable_always_msql.sql | 2 +
.../11_plus/alter_before_insert_event_trigger.sql | 15 +
.../alter_before_insert_event_trigger_msql.sql | 2 +
..._before_update_event_trigger_enable_replica.sql | 16 +
...re_update_event_trigger_enable_replica_msql.sql | 2 +
.../11_plus/create_after_delete_event_trigger.sql | 13 +
.../create_after_delete_event_trigger_msql.sql | 9 +
..._after_delete_event_trigger_with_transition.sql | 13 +
...r_delete_event_trigger_with_transition_msql.sql | 9 +
..._after_insert_event_trigger_with_transition.sql | 13 +
...r_insert_event_trigger_with_transition_msql.sql | 9 +
.../11_plus/create_after_update_event_trigger.sql | 13 +
.../create_after_update_event_trigger_msql.sql | 9 +
.../create_b4r_update_multiple_event_trigger.sql | 12 +
...eate_b4r_update_multiple_event_trigger_msql.sql | 8 +
.../create_before_insert_event_at_statement.sql | 12 +
...reate_before_insert_event_at_statement_msql.sql | 8 +
.../11_plus/create_before_insert_event_trigger.sql | 12 +
.../create_before_insert_event_trigger_msql.sql | 8 +
.../11_plus/create_before_update_event_trigger.sql | 13 +
.../create_before_update_event_trigger_msql.sql | 9 +
.../tables/triggers/tests/pg/11_plus/test.json | 312 +++
...er_after_update_event_trigger_enable_always.sql | 16 +
...ter_update_event_trigger_enable_always_msql.sql | 2 +
.../default/alter_before_insert_event_trigger.sql | 15 +
.../alter_before_insert_event_trigger_msql.sql | 2 +
..._before_update_event_trigger_enable_replica.sql | 16 +
...re_update_event_trigger_enable_replica_msql.sql | 2 +
.../default/create_after_delete_event_trigger.sql | 13 +
.../create_after_delete_event_trigger_msql.sql | 9 +
..._after_insert_event_trigger_with_transition.sql | 13 +
...r_insert_event_trigger_with_transition_msql.sql | 9 +
.../default/create_after_update_event_trigger.sql | 13 +
.../create_after_update_event_trigger_msql.sql | 9 +
.../create_b4r_update_multiple_event_trigger.sql | 12 +
...eate_b4r_update_multiple_event_trigger_msql.sql | 8 +
.../create_before_insert_event_at_statement.sql | 12 +
...reate_before_insert_event_at_statement_msql.sql | 8 +
.../default/create_before_insert_event_trigger.sql | 12 +
.../create_before_insert_event_trigger_msql.sql | 8 +
.../default/create_before_update_event_trigger.sql | 13 +
.../create_before_update_event_trigger_msql.sql | 9 +
.../pg/default/create_plain_trigger_function.sql | 17 +
.../tables/triggers/tests/pg/default/test.json | 241 +++
..._after_delete_event_trigger_with_transition.sql | 16 +
...r_delete_event_trigger_with_transition_msql.sql | 2 +
..._after_insert_event_trigger_with_transition.sql | 16 +
...r_insert_event_trigger_with_transition_msql.sql | 2 +
...er_after_update_event_trigger_enable_always.sql | 16 +
...ter_update_event_trigger_enable_always_msql.sql | 2 +
..._before_update_event_trigger_enable_replica.sql | 16 +
..._after_delete_event_trigger_with_transition.sql | 13 +
...r_delete_event_trigger_with_transition_msql.sql | 9 +
..._after_insert_event_trigger_with_transition.sql | 13 +
...r_insert_event_trigger_with_transition_msql.sql | 9 +
.../10_plus/create_after_update_event_trigger.sql | 13 +
.../create_after_update_event_trigger_msql.sql | 9 +
...r_update_event_trigger_with_transition_msql.sql | 10 +
.../10_plus/create_before_update_event_trigger.sql | 13 +
.../tables/triggers/tests/ppas/10_plus/test.json | 312 +++
..._after_delete_event_trigger_with_transition.sql | 16 +
...r_delete_event_trigger_with_transition_msql.sql | 2 +
..._after_insert_event_trigger_with_transition.sql | 16 +
...r_insert_event_trigger_with_transition_msql.sql | 2 +
...er_after_update_event_trigger_enable_always.sql | 16 +
...ter_update_event_trigger_enable_always_msql.sql | 2 +
.../11_plus/alter_before_insert_event_trigger.sql | 15 +
.../alter_before_insert_event_trigger_msql.sql | 2 +
..._before_update_event_trigger_enable_replica.sql | 16 +
...re_update_event_trigger_enable_replica_msql.sql | 2 +
.../11_plus/create_after_delete_event_trigger.sql | 13 +
.../create_after_delete_event_trigger_msql.sql | 9 +
..._after_delete_event_trigger_with_transition.sql | 13 +
...r_delete_event_trigger_with_transition_msql.sql | 9 +
..._after_insert_event_trigger_with_transition.sql | 13 +
...r_insert_event_trigger_with_transition_msql.sql | 9 +
.../11_plus/create_after_update_event_trigger.sql | 13 +
.../create_after_update_event_trigger_msql.sql | 9 +
.../create_b4r_update_multiple_event_trigger.sql | 12 +
...eate_b4r_update_multiple_event_trigger_msql.sql | 8 +
.../create_before_insert_event_at_statement.sql | 12 +
...reate_before_insert_event_at_statement_msql.sql | 8 +
.../11_plus/create_before_insert_event_trigger.sql | 12 +
.../create_before_insert_event_trigger_msql.sql | 8 +
.../11_plus/create_before_update_event_trigger.sql | 13 +
.../create_before_update_event_trigger_msql.sql | 9 +
.../tables/triggers/tests/ppas/11_plus/test.json | 312 +++
...er_after_update_event_trigger_enable_always.sql | 16 +
...ter_update_event_trigger_enable_always_msql.sql | 2 +
.../default/alter_before_insert_event_trigger.sql | 15 +
.../alter_before_insert_event_trigger_msql.sql | 2 +
..._before_update_event_trigger_enable_replica.sql | 16 +
...re_update_event_trigger_enable_replica_msql.sql | 2 +
.../default/create_after_delete_event_trigger.sql | 13 +
.../create_after_delete_event_trigger_msql.sql | 9 +
.../default/create_after_update_event_trigger.sql | 13 +
.../create_after_update_event_trigger_msql.sql | 9 +
.../create_b4r_update_multiple_event_trigger.sql | 12 +
...eate_b4r_update_multiple_event_trigger_msql.sql | 8 +
.../create_before_insert_event_at_statement.sql | 12 +
...reate_before_insert_event_at_statement_msql.sql | 8 +
.../default/create_before_insert_event_trigger.sql | 12 +
.../create_before_insert_event_trigger_msql.sql | 8 +
.../default/create_before_update_event_trigger.sql | 13 +
.../create_before_update_event_trigger_msql.sql | 9 +
.../ppas/default/create_plain_trigger_function.sql | 17 +
.../tables/triggers/tests/ppas/default/test.json | 241 +++
web/regression/python_test_utils/test_utils.py | 1 +
web/regression/re_sql/tests/test_resql.py | 44 +-
web/regression/runtests.py | 3 +
460 files changed, 23905 insertions(+), 555 deletions(-)