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