--
-- MULTI_MX_CREATE_TABLE
--
ALTER SEQUENCE pg_catalog.pg_dist_shardid_seq RESTART 1220000;
ALTER SEQUENCE pg_catalog.pg_dist_colocationid_seq RESTART 1220000;
SET client_min_messages TO WARNING;
SELECT start_metadata_sync_to_node('localhost', :worker_1_port);
 start_metadata_sync_to_node
---------------------------------------------------------------------

(1 row)

SELECT start_metadata_sync_to_node('localhost', :worker_2_port);
 start_metadata_sync_to_node
---------------------------------------------------------------------

(1 row)

-- cannot drop them at the end of the test file as other tests depend on them
DROP SCHEMA IF EXISTS citus_mx_test_schema, citus_mx_test_schema_join_1, citus_mx_test_schema_join_2 CASCADE;
DROP TABLE IF EXISTS nation_hash, lineitem_mx, orders_mx, customer_mx, nation_mx, part_mx, supplier_mx, mx_ddl_table, limit_orders_mx, multiple_hash_mx, app_analytics_events_mx, researchers_mx, labs_mx, objects_mx, articles_hash_mx, articles_single_shard_hash_mx, company_employees_mx;
-- create schema to test schema support
CREATE SCHEMA citus_mx_test_schema;
CREATE SCHEMA citus_mx_test_schema_join_1;
CREATE SCHEMA citus_mx_test_schema_join_2;
-- create UDFs that we're going to use in our tests
SET search_path TO public;
CREATE OR REPLACE FUNCTION simpleTestFunction(theValue integer)
    RETURNS text AS
$$
DECLARE
    strresult text;
BEGIN
    RETURN theValue * 3 / 2 + 1;
END;
$$
LANGUAGE 'plpgsql' IMMUTABLE;
SET search_path TO citus_mx_test_schema;
CREATE OR REPLACE FUNCTION simpleTestFunction2(theValue integer)
    RETURNS text AS
$$
DECLARE
    strresult text;
BEGIN
    RETURN theValue * 3 / 2 + 1;
END;
$$
LANGUAGE 'plpgsql' IMMUTABLE;
CREATE OR REPLACE FUNCTION public.immutable_append_mx(old_values int[], new_value int)
RETURNS int[] AS $$ SELECT old_values || new_value $$ LANGUAGE SQL IMMUTABLE;
CREATE OPERATOR citus_mx_test_schema.=== (
    LEFTARG = int,
    RIGHTARG = int,
    PROCEDURE = int4eq,
    COMMUTATOR = ===,
    NEGATOR = !==,
    HASHES, MERGES
);
SET search_path TO public;
SHOW server_version \gset
SELECT substring(:'server_version', '\d+')::int >= 16 AS server_version_ge_16
\gset
SELECT substring(:'server_version', '\d+')::int >= 17 AS server_version_ge_17
\gset
\if :server_version_ge_17
-- PG17 renamed colliculocale to colllocale
-- Relevant PG commit:
-- https://github.com/postgres/postgres/commit/f696c0cd5f299f1b51e214efc55a22a782cc175d
SELECT quote_ident((SELECT CASE WHEN datlocprovider='i' THEN datlocale ELSE datcollate END FROM pg_database WHERE datname = current_database())) as current_locale \gset
\elif :server_version_ge_16
-- In PG16, read-only server settings lc_collate and lc_ctype are removed
-- Relevant PG commit: b0f6c437160db640d4ea3e49398ebc3ba39d1982
SELECT quote_ident((SELECT CASE WHEN datlocprovider='i' THEN daticulocale ELSE datcollate END FROM pg_database WHERE datname = current_database())) as current_locale \gset
\else
SELECT quote_ident(current_setting('lc_collate')) as current_locale \gset
\endif
CREATE COLLATION citus_mx_test_schema.english (LOCALE=:current_locale);
CREATE TYPE citus_mx_test_schema.new_composite_type as (key1 text, key2 text);
CREATE TYPE citus_mx_test_schema.order_side_mx AS ENUM ('buy', 'sell');
-- now create required stuff in the worker 1
\c - - - :worker_1_port
SET client_min_messages TO WARNING;
-- show that we do not support creating citus local tables from mx workers for now
CREATE TABLE citus_local_table(a int);
SELECT citus_add_local_table_to_metadata('citus_local_table');
ERROR:  operation is not allowed on this node
HINT:  Connect to the coordinator and run it again.
DROP TABLE citus_local_table;
SET search_path TO citus_mx_test_schema;
-- create operator
CREATE OPERATOR citus_mx_test_schema.=== (
    LEFTARG = int,
    RIGHTARG = int,
    PROCEDURE = int4eq,
    COMMUTATOR = ===,
    NEGATOR = !==,
    HASHES, MERGES
);
-- now create required stuff in the worker 2
\c - - - :worker_2_port
SET client_min_messages TO WARNING;
SET search_path TO citus_mx_test_schema;
-- create operator
CREATE OPERATOR citus_mx_test_schema.=== (
    LEFTARG = int,
    RIGHTARG = int,
    PROCEDURE = int4eq,
    COMMUTATOR = ===,
    NEGATOR = !==,
    HASHES, MERGES
);
-- connect back to the master, and do some more tests
\c - - - :master_port
SET client_min_messages TO WARNING;
SET citus.shard_replication_factor TO 1;
SET search_path TO public;
CREATE TABLE nation_hash(
    n_nationkey integer not null,
    n_name char(25) not null,
    n_regionkey integer not null,
    n_comment varchar(152)
);
SET citus.shard_count TO 16;
SELECT create_distributed_table('nation_hash', 'n_nationkey');
 create_distributed_table
---------------------------------------------------------------------

(1 row)

SET search_path TO citus_mx_test_schema;
-- create mx tables that we're going to use for our tests
CREATE TABLE citus_mx_test_schema.nation_hash(
    n_nationkey integer not null,
    n_name char(25) not null,
    n_regionkey integer not null,
    n_comment varchar(152)
);
SELECT create_distributed_table('nation_hash', 'n_nationkey');
 create_distributed_table
---------------------------------------------------------------------

(1 row)

CREATE TABLE citus_mx_test_schema_join_1.nation_hash (
    n_nationkey integer not null,
    n_name char(25) not null,
    n_regionkey integer not null,
    n_comment varchar(152));
SET citus.shard_count TO 4;
SELECT create_distributed_table('citus_mx_test_schema_join_1.nation_hash', 'n_nationkey');
 create_distributed_table
---------------------------------------------------------------------

(1 row)

CREATE TABLE citus_mx_test_schema_join_1.nation_hash_2 (
    n_nationkey integer not null,
    n_name char(25) not null,
    n_regionkey integer not null,
    n_comment varchar(152));
SELECT create_distributed_table('citus_mx_test_schema_join_1.nation_hash_2', 'n_nationkey');
 create_distributed_table
---------------------------------------------------------------------

(1 row)

SET search_path TO citus_mx_test_schema_join_2;
CREATE TABLE nation_hash (
    n_nationkey integer not null,
    n_name char(25) not null,
    n_regionkey integer not null,
    n_comment varchar(152));
SELECT create_distributed_table('nation_hash', 'n_nationkey');
 create_distributed_table
---------------------------------------------------------------------

(1 row)

SET search_path TO citus_mx_test_schema;
CREATE TABLE nation_hash_collation_search_path(
    n_nationkey integer not null,
    n_name char(25) not null COLLATE english,
    n_regionkey integer not null,
    n_comment varchar(152)
);
SELECT create_distributed_table('nation_hash_collation_search_path', 'n_nationkey');
 create_distributed_table
---------------------------------------------------------------------

(1 row)

\COPY nation_hash_collation_search_path FROM STDIN with delimiter '|';
CREATE TABLE citus_mx_test_schema.nation_hash_composite_types(
    n_nationkey integer not null,
    n_name char(25) not null,
    n_regionkey integer not null,
    n_comment varchar(152),
    test_col citus_mx_test_schema.new_composite_type
);
SELECT create_distributed_table('citus_mx_test_schema.nation_hash_composite_types', 'n_nationkey');
 create_distributed_table
---------------------------------------------------------------------

(1 row)

-- insert some data to verify composite type queries
\COPY citus_mx_test_schema.nation_hash_composite_types FROM STDIN with delimiter '|';
-- now create tpch tables
-- Create new table definitions for use in testing in distributed planning and
-- execution functionality. Also create indexes to boost performance.
SET search_path TO public;
CREATE TABLE lineitem_mx (
    l_orderkey bigint not null,
    l_partkey integer not null,
    l_suppkey integer not null,
    l_linenumber integer not null,
    l_quantity decimal(15, 2) not null,
    l_extendedprice decimal(15, 2) not null,
    l_discount decimal(15, 2) not null,
    l_tax decimal(15, 2) not null,
    l_returnflag char(1) not null,
    l_linestatus char(1) not null,
    l_shipdate date not null,
    l_commitdate date not null,
    l_receiptdate date not null,
    l_shipinstruct char(25) not null,
    l_shipmode char(10) not null,
    l_comment varchar(44) not null,
    PRIMARY KEY(l_orderkey, l_linenumber) );
SET citus.shard_count TO 16;
SELECT create_distributed_table('lineitem_mx', 'l_orderkey');
 create_distributed_table
---------------------------------------------------------------------

(1 row)

CREATE INDEX lineitem_mx_time_index ON lineitem_mx (l_shipdate);
CREATE TABLE orders_mx (
    o_orderkey bigint not null,
    o_custkey integer not null,
    o_orderstatus char(1) not null,
    o_totalprice decimal(15,2) not null,
    o_orderdate date not null,
    o_orderpriority char(15) not null,
    o_clerk char(15) not null,
    o_shippriority integer not null,
    o_comment varchar(79) not null,
    PRIMARY KEY(o_orderkey) );
SELECT create_distributed_table('orders_mx', 'o_orderkey');
 create_distributed_table
---------------------------------------------------------------------

(1 row)

CREATE TABLE customer_mx (
    c_custkey integer not null,
    c_name varchar(25) not null,
    c_address varchar(40) not null,
    c_nationkey integer not null,
    c_phone char(15) not null,
    c_acctbal decimal(15,2) not null,
    c_mktsegment char(10) not null,
    c_comment varchar(117) not null);
SELECT create_reference_table('customer_mx');
 create_reference_table
---------------------------------------------------------------------

(1 row)

CREATE TABLE nation_mx (
    n_nationkey integer not null,
    n_name char(25) not null,
    n_regionkey integer not null,
    n_comment varchar(152));
SELECT create_reference_table('nation_mx');
 create_reference_table
---------------------------------------------------------------------

(1 row)

CREATE TABLE part_mx (
    p_partkey integer not null,
    p_name varchar(55) not null,
    p_mfgr char(25) not null,
    p_brand char(10) not null,
    p_type varchar(25) not null,
    p_size integer not null,
    p_container char(10) not null,
    p_retailprice decimal(15,2) not null,
    p_comment varchar(23) not null);
SELECT create_reference_table('part_mx');
 create_reference_table
---------------------------------------------------------------------

(1 row)

CREATE TABLE supplier_mx
(
    s_suppkey integer not null,
    s_name char(25) not null,
    s_address varchar(40) not null,
    s_nationkey integer,
    s_phone char(15) not null,
    s_acctbal decimal(15,2) not null,
    s_comment varchar(101) not null
);
SELECT create_reference_table('supplier_mx');
 create_reference_table
---------------------------------------------------------------------

(1 row)

-- Create test table for ddl
CREATE TABLE mx_ddl_table (
    key int primary key,
    value int
);
SET citus.shard_count TO 4;
SELECT create_distributed_table('mx_ddl_table', 'key', 'hash');
 create_distributed_table
---------------------------------------------------------------------

(1 row)

-- Load some test data
COPY mx_ddl_table (key, value) FROM STDIN WITH (FORMAT 'csv');
-- test table for modifications
CREATE TABLE limit_orders_mx (
    id bigint PRIMARY KEY,
    symbol text NOT NULL,
    bidder_id bigint NOT NULL,
    placed_at timestamp NOT NULL,
    kind citus_mx_test_schema.order_side_mx NOT NULL,
    limit_price decimal NOT NULL DEFAULT 0.00 CHECK (limit_price >= 0.00)
);
SET citus.shard_count TO 2;
SELECT create_distributed_table('limit_orders_mx', 'id');
 create_distributed_table
---------------------------------------------------------------------

(1 row)

-- test table for modifications
CREATE TABLE multiple_hash_mx (
    category text NOT NULL,
    data text NOT NULL
);
SELECT create_distributed_table('multiple_hash_mx', 'category');
 create_distributed_table
---------------------------------------------------------------------

(1 row)

SET citus.shard_count TO 4;
CREATE TABLE app_analytics_events_mx (id bigserial, app_id integer, name text);
SELECT create_distributed_table('app_analytics_events_mx', 'app_id');
 create_distributed_table
---------------------------------------------------------------------

(1 row)

CREATE TABLE researchers_mx (
    id bigint NOT NULL,
    lab_id int NOT NULL,
    name text NOT NULL
);
SET citus.shard_count TO 2;
SELECT create_distributed_table('researchers_mx', 'lab_id');
 create_distributed_table
---------------------------------------------------------------------

(1 row)

CREATE TABLE labs_mx (
    id bigint NOT NULL,
    name text NOT NULL
);
SET citus.shard_count TO 1;
SELECT create_distributed_table('labs_mx', 'id');
 create_distributed_table
---------------------------------------------------------------------

(1 row)

-- now, for some special failures...
CREATE TABLE objects_mx (
    id bigint PRIMARY KEY,
    name text NOT NULL
);
SELECT create_distributed_table('objects_mx', 'id', 'hash');
 create_distributed_table
---------------------------------------------------------------------

(1 row)

CREATE TABLE articles_hash_mx (
    id bigint NOT NULL,
    author_id bigint NOT NULL,
    title varchar(20) NOT NULL,
    word_count integer
);
-- this table is used in router executor tests
CREATE TABLE articles_single_shard_hash_mx (LIKE articles_hash_mx);
SET citus.shard_count TO 2;
SELECT create_distributed_table('articles_hash_mx', 'author_id');
 create_distributed_table
---------------------------------------------------------------------

(1 row)

SET citus.shard_count TO 1;
SELECT create_distributed_table('articles_single_shard_hash_mx', 'author_id');
 create_distributed_table
---------------------------------------------------------------------

(1 row)

SET citus.shard_count TO 4;
CREATE TABLE company_employees_mx (company_id int, employee_id int, manager_id int);
SELECT create_distributed_table('company_employees_mx', 'company_id');
 create_distributed_table
---------------------------------------------------------------------

(1 row)

WITH shard_counts AS (
	SELECT logicalrelid, count(*) AS shard_count FROM pg_dist_shard GROUP BY logicalrelid
	)
SELECT logicalrelid, colocationid, shard_count, partmethod, repmodel
FROM pg_dist_partition NATURAL JOIN shard_counts
ORDER BY colocationid, logicalrelid;
                      logicalrelid                      | colocationid | shard_count | partmethod | repmodel
---------------------------------------------------------------------
 nation_hash                                            |      1220000 |          16 | h          | s
 citus_mx_test_schema.nation_hash                       |      1220000 |          16 | h          | s
 citus_mx_test_schema_join_1.nation_hash                |      1220001 |           4 | h          | s
 citus_mx_test_schema_join_1.nation_hash_2              |      1220001 |           4 | h          | s
 citus_mx_test_schema_join_2.nation_hash                |      1220001 |           4 | h          | s
 citus_mx_test_schema.nation_hash_collation_search_path |      1220001 |           4 | h          | s
 citus_mx_test_schema.nation_hash_composite_types       |      1220001 |           4 | h          | s
 mx_ddl_table                                           |      1220001 |           4 | h          | s
 app_analytics_events_mx                                |      1220001 |           4 | h          | s
 company_employees_mx                                   |      1220001 |           4 | h          | s
 lineitem_mx                                            |      1220002 |          16 | h          | s
 orders_mx                                              |      1220002 |          16 | h          | s
 customer_mx                                            |      1220003 |           1 | n          | t
 nation_mx                                              |      1220003 |           1 | n          | t
 part_mx                                                |      1220003 |           1 | n          | t
 supplier_mx                                            |      1220003 |           1 | n          | t
 limit_orders_mx                                        |      1220004 |           2 | h          | s
 articles_hash_mx                                       |      1220004 |           2 | h          | s
 multiple_hash_mx                                       |      1220005 |           2 | h          | s
 researchers_mx                                         |      1220006 |           2 | h          | s
 labs_mx                                                |      1220007 |           1 | h          | s
 objects_mx                                             |      1220007 |           1 | h          | s
 articles_single_shard_hash_mx                          |      1220007 |           1 | h          | s
(23 rows)

-- check the citus_tables view
SELECT table_name, citus_table_type, distribution_column, shard_count, table_owner
FROM citus_tables
ORDER BY table_name::text;
                       table_name                       | citus_table_type | distribution_column | shard_count | table_owner
---------------------------------------------------------------------
 app_analytics_events_mx                                | distributed      | app_id              |           4 | postgres
 articles_hash_mx                                       | distributed      | author_id           |           2 | postgres
 articles_single_shard_hash_mx                          | distributed      | author_id           |           1 | postgres
 citus_mx_test_schema.nation_hash                       | distributed      | n_nationkey         |          16 | postgres
 citus_mx_test_schema.nation_hash_collation_search_path | distributed      | n_nationkey         |           4 | postgres
 citus_mx_test_schema.nation_hash_composite_types       | distributed      | n_nationkey         |           4 | postgres
 citus_mx_test_schema_join_1.nation_hash                | distributed      | n_nationkey         |           4 | postgres
 citus_mx_test_schema_join_1.nation_hash_2              | distributed      | n_nationkey         |           4 | postgres
 citus_mx_test_schema_join_2.nation_hash                | distributed      | n_nationkey         |           4 | postgres
 company_employees_mx                                   | distributed      | company_id          |           4 | postgres
 customer_mx                                            | reference        | <none>              |           1 | postgres
 labs_mx                                                | distributed      | id                  |           1 | postgres
 limit_orders_mx                                        | distributed      | id                  |           2 | postgres
 lineitem_mx                                            | distributed      | l_orderkey          |          16 | postgres
 multiple_hash_mx                                       | distributed      | category            |           2 | postgres
 mx_ddl_table                                           | distributed      | key                 |           4 | postgres
 nation_hash                                            | distributed      | n_nationkey         |          16 | postgres
 nation_mx                                              | reference        | <none>              |           1 | postgres
 objects_mx                                             | distributed      | id                  |           1 | postgres
 orders_mx                                              | distributed      | o_orderkey          |          16 | postgres
 part_mx                                                | reference        | <none>              |           1 | postgres
 researchers_mx                                         | distributed      | lab_id              |           2 | postgres
 supplier_mx                                            | reference        | <none>              |           1 | postgres
(23 rows)

\c - - - :worker_1_port
SET client_min_messages TO WARNING;
SELECT table_name, citus_table_type, distribution_column, shard_count, table_owner
FROM citus_tables
ORDER BY table_name::text;
                       table_name                       | citus_table_type | distribution_column | shard_count | table_owner
---------------------------------------------------------------------
 app_analytics_events_mx                                | distributed      | app_id              |           4 | postgres
 articles_hash_mx                                       | distributed      | author_id           |           2 | postgres
 articles_single_shard_hash_mx                          | distributed      | author_id           |           1 | postgres
 citus_mx_test_schema.nation_hash                       | distributed      | n_nationkey         |          16 | postgres
 citus_mx_test_schema.nation_hash_collation_search_path | distributed      | n_nationkey         |           4 | postgres
 citus_mx_test_schema.nation_hash_composite_types       | distributed      | n_nationkey         |           4 | postgres
 citus_mx_test_schema_join_1.nation_hash                | distributed      | n_nationkey         |           4 | postgres
 citus_mx_test_schema_join_1.nation_hash_2              | distributed      | n_nationkey         |           4 | postgres
 citus_mx_test_schema_join_2.nation_hash                | distributed      | n_nationkey         |           4 | postgres
 company_employees_mx                                   | distributed      | company_id          |           4 | postgres
 customer_mx                                            | reference        | <none>              |           1 | postgres
 labs_mx                                                | distributed      | id                  |           1 | postgres
 limit_orders_mx                                        | distributed      | id                  |           2 | postgres
 lineitem_mx                                            | distributed      | l_orderkey          |          16 | postgres
 multiple_hash_mx                                       | distributed      | category            |           2 | postgres
 mx_ddl_table                                           | distributed      | key                 |           4 | postgres
 nation_hash                                            | distributed      | n_nationkey         |          16 | postgres
 nation_mx                                              | reference        | <none>              |           1 | postgres
 objects_mx                                             | distributed      | id                  |           1 | postgres
 orders_mx                                              | distributed      | o_orderkey          |          16 | postgres
 part_mx                                                | reference        | <none>              |           1 | postgres
 researchers_mx                                         | distributed      | lab_id              |           2 | postgres
 supplier_mx                                            | reference        | <none>              |           1 | postgres
(23 rows)

SELECT shard_name, table_name, citus_table_type, shard_size FROM citus_shards ORDER BY shard_name::text;
                           shard_name                           |                       table_name                       | citus_table_type | shard_size
---------------------------------------------------------------------
 app_analytics_events_mx_1220096                                | app_analytics_events_mx                                | distributed      |       8192
 app_analytics_events_mx_1220096                                | app_analytics_events_mx                                | distributed      |       8192
 app_analytics_events_mx_1220096                                | app_analytics_events_mx                                | distributed      |       8192
 app_analytics_events_mx_1220096                                | app_analytics_events_mx                                | distributed      |       8192
 app_analytics_events_mx_1220096                                | app_analytics_events_mx                                | distributed      |       8192
 app_analytics_events_mx_1220096                                | app_analytics_events_mx                                | distributed      |       8192
 app_analytics_events_mx_1220096                                | app_analytics_events_mx                                | distributed      |       8192
 app_analytics_events_mx_1220097                                | app_analytics_events_mx                                | distributed      |       8192
 app_analytics_events_mx_1220098                                | app_analytics_events_mx                                | distributed      |       8192
 app_analytics_events_mx_1220098                                | app_analytics_events_mx                                | distributed      |       8192
 app_analytics_events_mx_1220098                                | app_analytics_events_mx                                | distributed      |       8192
 app_analytics_events_mx_1220098                                | app_analytics_events_mx                                | distributed      |       8192
 app_analytics_events_mx_1220098                                | app_analytics_events_mx                                | distributed      |       8192
 app_analytics_events_mx_1220098                                | app_analytics_events_mx                                | distributed      |       8192
 app_analytics_events_mx_1220098                                | app_analytics_events_mx                                | distributed      |       8192
 app_analytics_events_mx_1220099                                | app_analytics_events_mx                                | distributed      |       8192
 articles_hash_mx_1220104                                       | articles_hash_mx                                       | distributed      |          0
 articles_hash_mx_1220104                                       | articles_hash_mx                                       | distributed      |          0
 articles_hash_mx_1220104                                       | articles_hash_mx                                       | distributed      |          0
 articles_hash_mx_1220104                                       | articles_hash_mx                                       | distributed      |          0
 articles_hash_mx_1220104                                       | articles_hash_mx                                       | distributed      |          0
 articles_hash_mx_1220104                                       | articles_hash_mx                                       | distributed      |          0
 articles_hash_mx_1220104                                       | articles_hash_mx                                       | distributed      |          0
 articles_hash_mx_1220105                                       | articles_hash_mx                                       | distributed      |          0
 articles_single_shard_hash_mx_1220106                          | articles_single_shard_hash_mx                          | distributed      |          0
 articles_single_shard_hash_mx_1220106                          | articles_single_shard_hash_mx                          | distributed      |          0
 articles_single_shard_hash_mx_1220106                          | articles_single_shard_hash_mx                          | distributed      |          0
 articles_single_shard_hash_mx_1220106                          | articles_single_shard_hash_mx                          | distributed      |          0
 articles_single_shard_hash_mx_1220106                          | articles_single_shard_hash_mx                          | distributed      |          0
 articles_single_shard_hash_mx_1220106                          | articles_single_shard_hash_mx                          | distributed      |          0
 articles_single_shard_hash_mx_1220106                          | articles_single_shard_hash_mx                          | distributed      |          0
 citus_mx_test_schema.nation_hash_1220016                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220016                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220016                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220016                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220016                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220016                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220016                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220017                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220018                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220018                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220018                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220018                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220018                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220018                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220018                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220019                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220020                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220020                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220020                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220020                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220020                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220020                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220020                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220021                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220022                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220022                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220022                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220022                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220022                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220022                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220022                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220023                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220024                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220024                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220024                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220024                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220024                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220024                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220024                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220025                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220026                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220026                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220026                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220026                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220026                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220026                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220026                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220027                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220028                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220028                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220028                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220028                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220028                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220028                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220028                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220029                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220030                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220030                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220030                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220030                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220030                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220030                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220030                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_1220031                       | citus_mx_test_schema.nation_hash                       | distributed      |          0
 citus_mx_test_schema.nation_hash_collation_search_path_1220044 | citus_mx_test_schema.nation_hash_collation_search_path | distributed      |       8192
 citus_mx_test_schema.nation_hash_collation_search_path_1220044 | citus_mx_test_schema.nation_hash_collation_search_path | distributed      |       8192
 citus_mx_test_schema.nation_hash_collation_search_path_1220044 | citus_mx_test_schema.nation_hash_collation_search_path | distributed      |       8192
 citus_mx_test_schema.nation_hash_collation_search_path_1220044 | citus_mx_test_schema.nation_hash_collation_search_path | distributed      |       8192
 citus_mx_test_schema.nation_hash_collation_search_path_1220044 | citus_mx_test_schema.nation_hash_collation_search_path | distributed      |       8192
 citus_mx_test_schema.nation_hash_collation_search_path_1220044 | citus_mx_test_schema.nation_hash_collation_search_path | distributed      |       8192
 citus_mx_test_schema.nation_hash_collation_search_path_1220044 | citus_mx_test_schema.nation_hash_collation_search_path | distributed      |       8192
 citus_mx_test_schema.nation_hash_collation_search_path_1220045 | citus_mx_test_schema.nation_hash_collation_search_path | distributed      |       8192
 citus_mx_test_schema.nation_hash_collation_search_path_1220046 | citus_mx_test_schema.nation_hash_collation_search_path | distributed      |          0
 citus_mx_test_schema.nation_hash_collation_search_path_1220046 | citus_mx_test_schema.nation_hash_collation_search_path | distributed      |          0
 citus_mx_test_schema.nation_hash_collation_search_path_1220046 | citus_mx_test_schema.nation_hash_collation_search_path | distributed      |          0
 citus_mx_test_schema.nation_hash_collation_search_path_1220046 | citus_mx_test_schema.nation_hash_collation_search_path | distributed      |          0
 citus_mx_test_schema.nation_hash_collation_search_path_1220046 | citus_mx_test_schema.nation_hash_collation_search_path | distributed      |          0
 citus_mx_test_schema.nation_hash_collation_search_path_1220046 | citus_mx_test_schema.nation_hash_collation_search_path | distributed      |          0
 citus_mx_test_schema.nation_hash_collation_search_path_1220046 | citus_mx_test_schema.nation_hash_collation_search_path | distributed      |          0
 citus_mx_test_schema.nation_hash_collation_search_path_1220047 | citus_mx_test_schema.nation_hash_collation_search_path | distributed      |       8192
 citus_mx_test_schema.nation_hash_composite_types_1220048       | citus_mx_test_schema.nation_hash_composite_types       | distributed      |      16384
 citus_mx_test_schema.nation_hash_composite_types_1220048       | citus_mx_test_schema.nation_hash_composite_types       | distributed      |      16384
 citus_mx_test_schema.nation_hash_composite_types_1220048       | citus_mx_test_schema.nation_hash_composite_types       | distributed      |      16384
 citus_mx_test_schema.nation_hash_composite_types_1220048       | citus_mx_test_schema.nation_hash_composite_types       | distributed      |      16384
 citus_mx_test_schema.nation_hash_composite_types_1220048       | citus_mx_test_schema.nation_hash_composite_types       | distributed      |      16384
 citus_mx_test_schema.nation_hash_composite_types_1220048       | citus_mx_test_schema.nation_hash_composite_types       | distributed      |      16384
 citus_mx_test_schema.nation_hash_composite_types_1220048       | citus_mx_test_schema.nation_hash_composite_types       | distributed      |      16384
 citus_mx_test_schema.nation_hash_composite_types_1220049       | citus_mx_test_schema.nation_hash_composite_types       | distributed      |      16384
 citus_mx_test_schema.nation_hash_composite_types_1220050       | citus_mx_test_schema.nation_hash_composite_types       | distributed      |       8192
 citus_mx_test_schema.nation_hash_composite_types_1220050       | citus_mx_test_schema.nation_hash_composite_types       | distributed      |       8192
 citus_mx_test_schema.nation_hash_composite_types_1220050       | citus_mx_test_schema.nation_hash_composite_types       | distributed      |       8192
 citus_mx_test_schema.nation_hash_composite_types_1220050       | citus_mx_test_schema.nation_hash_composite_types       | distributed      |       8192
 citus_mx_test_schema.nation_hash_composite_types_1220050       | citus_mx_test_schema.nation_hash_composite_types       | distributed      |       8192
 citus_mx_test_schema.nation_hash_composite_types_1220050       | citus_mx_test_schema.nation_hash_composite_types       | distributed      |       8192
 citus_mx_test_schema.nation_hash_composite_types_1220050       | citus_mx_test_schema.nation_hash_composite_types       | distributed      |       8192
 citus_mx_test_schema.nation_hash_composite_types_1220051       | citus_mx_test_schema.nation_hash_composite_types       | distributed      |      16384
 citus_mx_test_schema_join_1.nation_hash_1220032                | citus_mx_test_schema_join_1.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_1220032                | citus_mx_test_schema_join_1.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_1220032                | citus_mx_test_schema_join_1.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_1220032                | citus_mx_test_schema_join_1.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_1220032                | citus_mx_test_schema_join_1.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_1220032                | citus_mx_test_schema_join_1.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_1220032                | citus_mx_test_schema_join_1.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_1220033                | citus_mx_test_schema_join_1.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_1220034                | citus_mx_test_schema_join_1.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_1220034                | citus_mx_test_schema_join_1.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_1220034                | citus_mx_test_schema_join_1.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_1220034                | citus_mx_test_schema_join_1.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_1220034                | citus_mx_test_schema_join_1.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_1220034                | citus_mx_test_schema_join_1.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_1220034                | citus_mx_test_schema_join_1.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_1220035                | citus_mx_test_schema_join_1.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_2_1220036              | citus_mx_test_schema_join_1.nation_hash_2              | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_2_1220036              | citus_mx_test_schema_join_1.nation_hash_2              | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_2_1220036              | citus_mx_test_schema_join_1.nation_hash_2              | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_2_1220036              | citus_mx_test_schema_join_1.nation_hash_2              | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_2_1220036              | citus_mx_test_schema_join_1.nation_hash_2              | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_2_1220036              | citus_mx_test_schema_join_1.nation_hash_2              | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_2_1220036              | citus_mx_test_schema_join_1.nation_hash_2              | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_2_1220037              | citus_mx_test_schema_join_1.nation_hash_2              | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_2_1220038              | citus_mx_test_schema_join_1.nation_hash_2              | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_2_1220038              | citus_mx_test_schema_join_1.nation_hash_2              | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_2_1220038              | citus_mx_test_schema_join_1.nation_hash_2              | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_2_1220038              | citus_mx_test_schema_join_1.nation_hash_2              | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_2_1220038              | citus_mx_test_schema_join_1.nation_hash_2              | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_2_1220038              | citus_mx_test_schema_join_1.nation_hash_2              | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_2_1220038              | citus_mx_test_schema_join_1.nation_hash_2              | distributed      |          0
 citus_mx_test_schema_join_1.nation_hash_2_1220039              | citus_mx_test_schema_join_1.nation_hash_2              | distributed      |          0
 citus_mx_test_schema_join_2.nation_hash_1220040                | citus_mx_test_schema_join_2.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_2.nation_hash_1220040                | citus_mx_test_schema_join_2.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_2.nation_hash_1220040                | citus_mx_test_schema_join_2.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_2.nation_hash_1220040                | citus_mx_test_schema_join_2.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_2.nation_hash_1220040                | citus_mx_test_schema_join_2.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_2.nation_hash_1220040                | citus_mx_test_schema_join_2.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_2.nation_hash_1220040                | citus_mx_test_schema_join_2.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_2.nation_hash_1220041                | citus_mx_test_schema_join_2.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_2.nation_hash_1220042                | citus_mx_test_schema_join_2.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_2.nation_hash_1220042                | citus_mx_test_schema_join_2.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_2.nation_hash_1220042                | citus_mx_test_schema_join_2.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_2.nation_hash_1220042                | citus_mx_test_schema_join_2.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_2.nation_hash_1220042                | citus_mx_test_schema_join_2.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_2.nation_hash_1220042                | citus_mx_test_schema_join_2.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_2.nation_hash_1220042                | citus_mx_test_schema_join_2.nation_hash                | distributed      |          0
 citus_mx_test_schema_join_2.nation_hash_1220043                | citus_mx_test_schema_join_2.nation_hash                | distributed      |          0
 company_employees_mx_1220107                                   | company_employees_mx                                   | distributed      |          0
 company_employees_mx_1220107                                   | company_employees_mx                                   | distributed      |          0
 company_employees_mx_1220107                                   | company_employees_mx                                   | distributed      |          0
 company_employees_mx_1220107                                   | company_employees_mx                                   | distributed      |          0
 company_employees_mx_1220107                                   | company_employees_mx                                   | distributed      |          0
 company_employees_mx_1220107                                   | company_employees_mx                                   | distributed      |          0
 company_employees_mx_1220107                                   | company_employees_mx                                   | distributed      |          0
 company_employees_mx_1220108                                   | company_employees_mx                                   | distributed      |          0
 company_employees_mx_1220109                                   | company_employees_mx                                   | distributed      |          0
 company_employees_mx_1220109                                   | company_employees_mx                                   | distributed      |          0
 company_employees_mx_1220109                                   | company_employees_mx                                   | distributed      |          0
 company_employees_mx_1220109                                   | company_employees_mx                                   | distributed      |          0
 company_employees_mx_1220109                                   | company_employees_mx                                   | distributed      |          0
 company_employees_mx_1220109                                   | company_employees_mx                                   | distributed      |          0
 company_employees_mx_1220109                                   | company_employees_mx                                   | distributed      |          0
 company_employees_mx_1220110                                   | company_employees_mx                                   | distributed      |          0
 customer_mx_1220084                                            | customer_mx                                            | reference        |          0
 customer_mx_1220084                                            | customer_mx                                            | reference        |          0
 customer_mx_1220084                                            | customer_mx                                            | reference        |          0
 customer_mx_1220084                                            | customer_mx                                            | reference        |          0
 customer_mx_1220084                                            | customer_mx                                            | reference        |          0
 customer_mx_1220084                                            | customer_mx                                            | reference        |          0
 customer_mx_1220084                                            | customer_mx                                            | reference        |          0
 customer_mx_1220084                                            | customer_mx                                            | reference        |          0
 labs_mx_1220102                                                | labs_mx                                                | distributed      |       8192
 labs_mx_1220102                                                | labs_mx                                                | distributed      |       8192
 labs_mx_1220102                                                | labs_mx                                                | distributed      |       8192
 labs_mx_1220102                                                | labs_mx                                                | distributed      |       8192
 labs_mx_1220102                                                | labs_mx                                                | distributed      |       8192
 labs_mx_1220102                                                | labs_mx                                                | distributed      |       8192
 labs_mx_1220102                                                | labs_mx                                                | distributed      |       8192
 limit_orders_mx_1220092                                        | limit_orders_mx                                        | distributed      |      16384
 limit_orders_mx_1220092                                        | limit_orders_mx                                        | distributed      |      16384
 limit_orders_mx_1220092                                        | limit_orders_mx                                        | distributed      |      16384
 limit_orders_mx_1220092                                        | limit_orders_mx                                        | distributed      |      16384
 limit_orders_mx_1220092                                        | limit_orders_mx                                        | distributed      |      16384
 limit_orders_mx_1220092                                        | limit_orders_mx                                        | distributed      |      16384
 limit_orders_mx_1220092                                        | limit_orders_mx                                        | distributed      |      16384
 limit_orders_mx_1220093                                        | limit_orders_mx                                        | distributed      |      16384
 lineitem_mx_1220052                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220052                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220052                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220052                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220052                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220052                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220052                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220053                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220054                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220054                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220054                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220054                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220054                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220054                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220054                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220055                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220056                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220056                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220056                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220056                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220056                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220056                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220056                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220057                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220058                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220058                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220058                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220058                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220058                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220058                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220058                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220059                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220060                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220060                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220060                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220060                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220060                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220060                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220060                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220061                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220062                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220062                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220062                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220062                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220062                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220062                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220062                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220063                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220064                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220064                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220064                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220064                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220064                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220064                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220064                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220065                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220066                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220066                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220066                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220066                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220066                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220066                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220066                                            | lineitem_mx                                            | distributed      |      16384
 lineitem_mx_1220067                                            | lineitem_mx                                            | distributed      |      16384
 multiple_hash_mx_1220094                                       | multiple_hash_mx                                       | distributed      |       8192
 multiple_hash_mx_1220094                                       | multiple_hash_mx                                       | distributed      |       8192
 multiple_hash_mx_1220094                                       | multiple_hash_mx                                       | distributed      |       8192
 multiple_hash_mx_1220094                                       | multiple_hash_mx                                       | distributed      |       8192
 multiple_hash_mx_1220094                                       | multiple_hash_mx                                       | distributed      |       8192
 multiple_hash_mx_1220094                                       | multiple_hash_mx                                       | distributed      |       8192
 multiple_hash_mx_1220094                                       | multiple_hash_mx                                       | distributed      |       8192
 multiple_hash_mx_1220095                                       | multiple_hash_mx                                       | distributed      |       8192
 mx_ddl_table_1220088                                           | mx_ddl_table                                           | distributed      |      24576
 mx_ddl_table_1220088                                           | mx_ddl_table                                           | distributed      |      24576
 mx_ddl_table_1220088                                           | mx_ddl_table                                           | distributed      |      24576
 mx_ddl_table_1220088                                           | mx_ddl_table                                           | distributed      |      24576
 mx_ddl_table_1220088                                           | mx_ddl_table                                           | distributed      |      24576
 mx_ddl_table_1220088                                           | mx_ddl_table                                           | distributed      |      24576
 mx_ddl_table_1220088                                           | mx_ddl_table                                           | distributed      |      24576
 mx_ddl_table_1220089                                           | mx_ddl_table                                           | distributed      |      24576
 mx_ddl_table_1220090                                           | mx_ddl_table                                           | distributed      |      24576
 mx_ddl_table_1220090                                           | mx_ddl_table                                           | distributed      |      24576
 mx_ddl_table_1220090                                           | mx_ddl_table                                           | distributed      |      24576
 mx_ddl_table_1220090                                           | mx_ddl_table                                           | distributed      |      24576
 mx_ddl_table_1220090                                           | mx_ddl_table                                           | distributed      |      24576
 mx_ddl_table_1220090                                           | mx_ddl_table                                           | distributed      |      24576
 mx_ddl_table_1220090                                           | mx_ddl_table                                           | distributed      |      24576
 mx_ddl_table_1220091                                           | mx_ddl_table                                           | distributed      |      24576
 nation_hash_1220000                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220000                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220000                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220000                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220000                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220000                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220000                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220001                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220002                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220002                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220002                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220002                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220002                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220002                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220002                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220003                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220004                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220004                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220004                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220004                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220004                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220004                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220004                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220005                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220006                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220006                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220006                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220006                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220006                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220006                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220006                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220007                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220008                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220008                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220008                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220008                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220008                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220008                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220008                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220009                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220010                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220010                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220010                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220010                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220010                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220010                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220010                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220011                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220012                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220012                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220012                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220012                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220012                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220012                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220012                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220013                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220014                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220014                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220014                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220014                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220014                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220014                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220014                                            | nation_hash                                            | distributed      |          0
 nation_hash_1220015                                            | nation_hash                                            | distributed      |          0
 nation_mx_1220085                                              | nation_mx                                              | reference        |          0
 nation_mx_1220085                                              | nation_mx                                              | reference        |          0
 nation_mx_1220085                                              | nation_mx                                              | reference        |          0
 nation_mx_1220085                                              | nation_mx                                              | reference        |          0
 nation_mx_1220085                                              | nation_mx                                              | reference        |          0
 nation_mx_1220085                                              | nation_mx                                              | reference        |          0
 nation_mx_1220085                                              | nation_mx                                              | reference        |          0
 nation_mx_1220085                                              | nation_mx                                              | reference        |          0
 objects_mx_1220103                                             | objects_mx                                             | distributed      |      16384
 objects_mx_1220103                                             | objects_mx                                             | distributed      |      16384
 objects_mx_1220103                                             | objects_mx                                             | distributed      |      16384
 objects_mx_1220103                                             | objects_mx                                             | distributed      |      16384
 objects_mx_1220103                                             | objects_mx                                             | distributed      |      16384
 objects_mx_1220103                                             | objects_mx                                             | distributed      |      16384
 objects_mx_1220103                                             | objects_mx                                             | distributed      |      16384
 orders_mx_1220068                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220068                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220068                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220068                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220068                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220068                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220068                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220069                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220070                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220070                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220070                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220070                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220070                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220070                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220070                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220071                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220072                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220072                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220072                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220072                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220072                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220072                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220072                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220073                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220074                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220074                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220074                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220074                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220074                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220074                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220074                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220075                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220076                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220076                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220076                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220076                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220076                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220076                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220076                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220077                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220078                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220078                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220078                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220078                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220078                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220078                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220078                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220079                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220080                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220080                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220080                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220080                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220080                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220080                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220080                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220081                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220082                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220082                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220082                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220082                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220082                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220082                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220082                                              | orders_mx                                              | distributed      |       8192
 orders_mx_1220083                                              | orders_mx                                              | distributed      |       8192
 part_mx_1220086                                                | part_mx                                                | reference        |          0
 part_mx_1220086                                                | part_mx                                                | reference        |          0
 part_mx_1220086                                                | part_mx                                                | reference        |          0
 part_mx_1220086                                                | part_mx                                                | reference        |          0
 part_mx_1220086                                                | part_mx                                                | reference        |          0
 part_mx_1220086                                                | part_mx                                                | reference        |          0
 part_mx_1220086                                                | part_mx                                                | reference        |          0
 part_mx_1220086                                                | part_mx                                                | reference        |          0
 researchers_mx_1220100                                         | researchers_mx                                         | distributed      |       8192
 researchers_mx_1220100                                         | researchers_mx                                         | distributed      |       8192
 researchers_mx_1220100                                         | researchers_mx                                         | distributed      |       8192
 researchers_mx_1220100                                         | researchers_mx                                         | distributed      |       8192
 researchers_mx_1220100                                         | researchers_mx                                         | distributed      |       8192
 researchers_mx_1220100                                         | researchers_mx                                         | distributed      |       8192
 researchers_mx_1220100                                         | researchers_mx                                         | distributed      |       8192
 researchers_mx_1220101                                         | researchers_mx                                         | distributed      |       8192
 supplier_mx_1220087                                            | supplier_mx                                            | reference        |          0
 supplier_mx_1220087                                            | supplier_mx                                            | reference        |          0
 supplier_mx_1220087                                            | supplier_mx                                            | reference        |          0
 supplier_mx_1220087                                            | supplier_mx                                            | reference        |          0
 supplier_mx_1220087                                            | supplier_mx                                            | reference        |          0
 supplier_mx_1220087                                            | supplier_mx                                            | reference        |          0
 supplier_mx_1220087                                            | supplier_mx                                            | reference        |          0
 supplier_mx_1220087                                            | supplier_mx                                            | reference        |          0
(469 rows)

-- Show that altering type name is not supported from worker node
ALTER TYPE citus_mx_test_schema.order_side_mx RENAME TO temp_order_side_mx;
ERROR:  operation is not allowed on this node
HINT:  Connect to the coordinator and run it again.
