# ---------- # $Id$ # # Regression tests that exercise distributed planning/execution functionality. # # All new regression tests are expected to be run by this schedule. Tests that # do not set specific task executor type should also be added to # multi_task_tracker_extra_schedule. # # Note that we use variant comparison files to test version dependent regression # test results. For more information: # http://www.postgresql.org/docs/current/static/regress-variant.html # ---------- # --- # Tests around schema changes, these are run first, so there's no preexisting objects. # # propagate_extension_commands lies just after multi_cluster_management as we do # remove / add node operations, we do not want any preexisting objects before # propagate_extension_commands # --- test: multi_test_helpers multi_test_helpers_superuser test: multi_test_catalog_views test: multi_name_lengths test: multi_name_resolution test: multi_metadata_access # ---------- # The following distributed tests depend on creating a partitioned table and # uploading data to it. # ---------- test: multi_create_table test: multi_create_table_superuser test: multi_create_table_constraints multi_master_protocol multi_load_data multi_load_data_superuser multi_behavioral_analytics_create_table test: recursive_dml_with_different_planners_executors multi_behavioral_analytics_create_table_superuser test: insert_select_repartition dml_recursive multi_insert_select_window test: multi_insert_select_conflict # following should not run in parallel because it relies on connection counts to workers test: insert_select_connection_leak # --------- # at the end of the regression tests regaring recursively planned modifications # ensure that we don't leak any intermediate results # This test should not run in parallel with any other tests # --------- test: ensure_no_intermediate_data_leak # ---------- # Tests for partitioning support # ---------- test: multi_partitioning_utils # ---------- # Tests for recursive subquery planning # ---------- test: subquery_local_tables subquery_executors subquery_and_cte set_operations set_operation_and_local_tables test: subqueries_deep subquery_view subquery_partitioning subqueries_not_supported subquery_in_where test: non_colocated_leaf_subquery_joins non_colocated_subquery_joins non_colocated_join_order test: subquery_prepared_statements pg12 cte_inline # ---------- # Miscellaneous tests to check our query planning behavior # ---------- test: multi_deparse_shard_query multi_distributed_transaction_id limit_intermediate_size test: hyperscale_tutorial test: multi_basic_queries multi_subquery multi_subquery_complex_queries multi_subquery_behavioral_analytics test: multi_subquery_complex_reference_clause multi_subquery_window_functions multi_sql_function test: multi_function_in_join row_types materialized_view test: multi_subquery_in_where_reference_clause join adaptive_executor propagate_set_commands test: multi_subquery_union multi_subquery_in_where_clause multi_subquery_misc test: multi_agg_distinct multi_limit_clause_approximate multi_outer_join_reference test: multi_select_for_update relation_access_tracking pg13_with_ties test: multi_working_columns multi_having_pushdown test: bool_agg ch_bench_having ch_bench_subquery_repartition chbenchmark_all_queries expression_reference_join test: multi_agg_type_conversion multi_count_type_conversion test: multi_partition_pruning test: multi_join_pruning multi_hash_pruning intermediate_result_pruning test: multi_query_directory_cleanup test: multi_cross_shard test: multi_dropped_column_aliases foreign_key_restriction_enforcement # ---------- # Parallel TPC-H tests to check our distributed execution behavior # ---------- test: multi_tpch_query3 multi_tpch_query6 multi_tpch_query10 test: multi_tpch_query12 multi_tpch_query14 multi_tpch_query19 test: multi_tpch_query7 multi_tpch_query7_nested # ---------- # Parallel tests to check our join order planning logic. Note that we load data # below; and therefore these tests should come after the execution tests. # ---------- test: multi_join_order_tpch_small multi_join_order_additional test: multi_load_more_data test: multi_join_order_tpch_repartition # ---------- # Tests for repartition join planning and execution. Be careful when creating # new shards before these tests, as they expect specific shard identifiers in # the output. # ---------- test: multi_repartition_join_planning multi_repartition_join_pruning multi_repartition_join_task_assignment multi_repartition_join_ref test: adaptive_executor_repartition # --------- # Tests that modify data should run sequentially # --------- # --------- # Tests for recursive planning. # --------- test: with_where test: cte_prepared_modify cte_nested_modification test: ensure_no_intermediate_data_leak test: with_executors with_partitioning with_dml # ---------- # Tests to check our large record loading and shard deletion behavior # ---------- test: multi_load_large_records test: multi_master_delete_protocol test: multi_shard_modify # ---------- # Tests around DDL statements run on distributed tables # ---------- test: multi_alter_table_add_constraints # ---------- # multi_create_schema tests creation, loading, and querying of a table in a new # schema (namespace). # ---------- test: multi_create_schema # ---------- # Tests to check the sequential and parallel executions of DDL and modification # commands # Should not be executed in parallel with other tests # ---------- test: sequential_modifications # --------- # multi_outer_join loads data to create shards to test outer join mappings # --------- test: multi_outer_join # --- # Tests covering mostly modification queries and required preliminary # functionality related to metadata, shard creation, shard pruning and # "hacky" copy script for hash partitioned tables. # Note that the order of the following tests are important. multi_complex_count_distinct # is independent from the rest of the group, it is added to increase parallelism. # --- test: multi_create_fdw test: multi_generate_ddl_commands multi_create_shards multi_prune_shard_list test: multi_upsert multi_simple_queries multi_data_types test: multi_utilities foreign_key_to_reference_table validate_constraint test: multi_repartition_udt multi_repartitioned_subquery_udf # --------- # multi_copy creates hash and range-partitioned tables and performs COPY # multi_router_planner creates hash partitioned tables. # --------- test: fast_path_router_modify test: null_parameters # ---------- # multi_truncate tests truncate functionality for distributed tables # ---------- test: multi_truncate # ---------- # multi_foreign_key tests foreign key push down on distributed tables # ---------- test: multi_foreign_key multi_foreign_key_relation_graph # -------- # Replicating reference tables to coordinator. Add coordinator to pg_dist_node # and rerun some of the tests. # -------- test: foreign_key_to_reference_table # --------- # multi_cache_invalidation tests for an obscure crash citus used to exhibit when shardids # changed the table they belonged to during a session # -------- test: multi_cache_invalidation # --------- # multi_task_string_size tests task string size checks # --------- test: multi_task_string_size # --------- # object distribution tests # --------- test: distributed_types_conflict disable_object_propagation distributed_types_xact_add_enum_value # --------- # deparsing logic tests # --------- test: multi_deparse_function # --------- # test that no tests leaked intermediate results. This should always be last # Causes random test failures so commented out for now # --------- # test: ensure_no_intermediate_data_leak