cockroach-teamcity
commented
3 years ago (compose).TestComposeCompare failed on master@89c379950cb4ca77c5d25e45aac4008b1f1758d9:
postgres_1 | You can change this by editing pg_hba.conf or using the option -A, or
postgres_1 | --auth-local and --auth-host, the next time you run initdb.
postgres_1 | waiting for server to start....2021-03-09 06:11:23.311 UTC [48] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
postgres_1 | 2021-03-09 06:11:23.329 UTC [49] LOG: database system was shut down at 2021-03-09 06:11:23 UTC
postgres_1 | 2021-03-09 06:11:23.334 UTC [48] LOG: database system is ready to accept connections
postgres_1 | done
postgres_1 | server started
postgres_1 |
postgres_1 | /usr/local/bin/docker-entrypoint.sh: sourcing /docker-entrypoint-initdb.d/10_postgis.sh
postgres_1 | CREATE DATABASE
postgres_1 | Loading PostGIS extensions into template_postgis
postgres_1 | CREATE EXTENSION
postgres_1 | CREATE EXTENSION
postgres_1 | CREATE EXTENSION
test_1 | --- FAIL: TestCompare (1.46s)
test_1 | --- FAIL: TestCompare/postgres (0.42s)
test_1 | compare_test.go:119: pgx conn: dial tcp 172.18.0.4:5432: connect: connection refused
test_1 | --- FAIL: TestCompare/mutators (1.04s)
test_1 | compare_test.go:129: SET CLUSTER SETTING "sql.stats.automatic_collection.enabled" = false;
test_1 | SET CLUSTER SETTING "sql.stats.histogram_collection.enabled" = false;
test_1 | SET CLUSTER SETTING "sql.defaults.interleaved_tables.enabled" = true;
test_1 | CREATE TABLE table1 (col1_0 UUID NOT NULL, col1_1 INTERVAL NOT NULL, col1_2 INET NOT NULL, col1_3 REGCLASS, col1_4 INT8 NOT NULL, col1_5 BOOL NOT NULL, col1_6 TIMESTAMPTZ NOT NULL, col1_7 STRING NOT NULL, col1_8 TIMETZ, col1_9 UUID, col1_10 BOX2D, col1_11 NAME, col1_12 TIMESTAMPTZ, col1_13 REGCLASS NOT NULL, col1_14 REGPROC NULL, PRIMARY KEY (col1_7, col1_5 DESC), col1_15 STRING NULL AS (lower(CAST(col1_5 AS STRING))) VIRTUAL, col1_16 STRING NULL AS (lower(CAST(col1_1 AS STRING))) STORED, col1_17 STRING NOT NULL AS (lower(CAST(col1_13 AS STRING))) VIRTUAL, INDEX (col1_13, col1_10 DESC, col1_7 ASC, col1_8 ASC, col1_4 DESC) STORING (col1_2, col1_3, col1_6, col1_9, col1_11, col1_12) WHERE (table1.col1_11 = '':::STRING) AND (table1.col1_7 != e'\x00':::STRING), INDEX (col1_3 DESC, col1_1, col1_0, col1_17 ASC, col1_8 DESC, col1_12 DESC, col1_6 DESC, col1_10 ASC, col1_4 ASC, col1_5 ASC, col1_9, col1_16, col1_2 ASC, col1_14 DESC, col1_15, col1_13) STORING (col1_11) WHERE (((table1.col1_8 > '24:00:00-15:59:00':::TIMETZ) AND (table1.col1_15 <= 'X':::STRING)) AND (table1.col1_16 < e'\x00':::STRING)) OR table1.col1_5, INDEX (col1_0) STORING (col1_2, col1_3, col1_4, col1_8, col1_10, col1_11, col1_13, col1_14, col1_16) WHERE (((((table1.col1_11 <= 'X':::STRING) OR (table1.col1_6 != '-4713-11-24 00:00:00+00:00':::TIMESTAMPTZ)) AND (table1.col1_17 > '':::STRING)) OR (table1.col1_4 = 2147483647:::INT8)) OR (table1.col1_7 > e'\U00002603':::STRING)) AND (table1.col1_16 > '"':::STRING), INDEX (col1_7, col1_0 DESC, col1_11 ASC, col1_14, col1_16 ASC, col1_15 DESC, col1_8, col1_13 ASC, col1_12, col1_3 ASC, col1_2 ASC, col1_4, col1_6) STORING (col1_10), FAMILY (col1_4, col1_14), FAMILY (col1_0, col1_6), FAMILY (col1_2), FAMILY (col1_13, col1_3, col1_12, col1_9), FAMILY (col1_10), FAMILY (col1_11, col1_1), FAMILY (col1_8), FAMILY (col1_7), FAMILY (col1_5, col1_16));
test_1 | CREATE TABLE table2 (col1_7 STRING NOT NULL, col1_5 BOOL NOT NULL, col2_2 INT8 NULL, col2_3 INT4, col2_4 BOOL NULL, col2_5 INT4 NOT NULL, col2_6 DECIMAL NULL, col2_7 INT2 NOT NULL, col2_8 OID, col2_9 OID, col2_10 FLOAT8 NOT NULL, col2_11 UUID NULL, col2_12 TIME, col2_13 BYTES NULL, col2_14 DATE NOT NULL, col2_15 REGTYPE NULL, col2_16 BOX2D NOT NULL, col2_17 REGPROCEDURE NOT NULL, col2_18 BYTES NULL, col2_19 BOOL, col2_20 UUID, PRIMARY KEY (col1_7, col1_5 DESC, col2_2 ASC, col2_16 ASC, col2_12 DESC, col2_4 ASC, col2_11), FAMILY (col1_7, col2_8), FAMILY (col2_18, col2_17), FAMILY (col2_19), FAMILY (col2_10), FAMILY (col2_3), FAMILY (col1_5, col2_9, col2_12, col2_5), FAMILY (col2_11, col2_14), FAMILY (col2_6), FAMILY (col2_20, col2_15), FAMILY (col2_13, col2_2, col2_16), FAMILY (col2_7), FAMILY (col2_4)) INTERLEAVE IN PARENT table1 (col1_7, col1_5);
test_1 | CREATE TABLE table3 (col3_0 INT2 NULL, col3_1 INT2 NOT NULL, col3_2 INT4 NOT NULL, col3_3 BOX2D NOT NULL, col3_4 DATE NOT NULL, col3_5 DECIMAL, col3_6 DECIMAL NOT NULL, col3_7 CHAR NOT NULL, col3_8 OID NOT NULL, col3_9 BIT(39) NOT NULL, col3_10 TIME NOT NULL, col3_11 TIME, PRIMARY KEY (col3_7 ASC, col3_3 DESC, col3_6, col3_9 DESC, col3_4 ASC, col3_8, col3_2 ASC, col3_10 ASC), col3_12 INT2 AS (col3_0 + (-5432):::INT8) VIRTUAL, UNIQUE (col3_4, col3_10, col3_5 DESC, col3_1 ASC, col3_7 DESC, col3_11 ASC) WHERE ((table3.col3_5 >= 'NaN':::DECIMAL) AND (table3.col3_0 > 0:::INT8)) AND (table3.col3_12 > (-1):::INT8), UNIQUE (col3_4 DESC, col3_9, col3_10 DESC, col3_3, col3_12 DESC, col3_5, col3_0, col3_11 ASC, col3_6 ASC) STORING (col3_1) WHERE (((((((((table3.col3_12 >= (-1):::INT8) AND (table3.col3_11 != '24:00:00':::TIME)) OR (table3.col3_1 >= 0:::INT8)) OR (table3.col3_7 = '':::STRING)) AND (table3.col3_0 >= (-1):::INT8)) AND (table3.col3_5 = 1:::DECIMAL)) OR (table3.col3_2 <= (-1):::INT8)) OR (table3.col3_10 = '00:00:00':::TIME)) OR (table3.col3_6 <= 1:::DECIMAL)) OR (table3.col3_4 <= '-infinity':::DATE), INDEX (col3_2 ASC, col3_9 ASC, col3_11, col3_10 ASC, col3_12 ASC, col3_3 ASC, col3_5, col3_6, col3_1, col3_4 DESC, col3_8) WHERE (((table3.col3_7 != e'\'':::STRING) AND (table3.col3_1 < 1:::INT8)) AND (table3.col3_12 > (-1):::INT8)) OR (table3.col3_6 < '-Infinity':::DECIMAL), INDEX (col3_0 ASC, col3_6 ASC, col3_9 DESC, col3_8, col3_7 DESC, col3_11 DESC, col3_5, col3_2 ASC, col3_10 ASC), UNIQUE (col3_3 DESC, col3_11 ASC, col3_9 ASC, col3_12 DESC, col3_7 DESC) WHERE (((((table3.col3_1 = (-32768):::INT8) AND (table3.col3_7 > '"':::STRING)) OR (table3.col3_11 >= '24:00:00':::TIME)) OR (table3.col3_6 <= (-1.234E+401):::DECIMAL)) AND (table3.col3_4 >= '1970-01-01':::DATE)) AND (table3.col3_0 < 127:::INT8), UNIQUE (col3_0) STORING (col3_1) WHERE (((((((table3.col3_2 != 2147483647) OR (table3.col3_5 <= NaN)) OR (table3.col3_1 < 0)) AND (table3.col3_7 >= '"')) AND (table3.col3_11 > '24:00:00')) OR (table3.col3_12 < -128)) AND (table3.col3_4 = 'infinity')) OR (table3.col3_6 < 1), FAMILY (col3_10), FAMILY (col3_4), FAMILY (col3_3), FAMILY (col3_8, col3_7, col3_2), FAMILY (col3_5, col3_9), FAMILY (col3_6, col3_0), FAMILY (col3_1), FAMILY (col3_11));
test_1 | ALTER TABLE table1 INJECT STATISTICS e'[{"columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5252522633127418678, "histo_buckets": [{"distinct_range": 0, "num_eq": 1566826249963425442, "num_range": 0, "upper_bound": "00000000-0000-0000-0000-000000000000"}, {"distinct_range": 54922.3281750524, "num_eq": 2603343692948982412, "num_range": 90000, "upper_bound": "0bce971d-8a2f-4174-903e-e329c4594a1f"}, {"distinct_range": 0, "num_eq": 3229207734588124075, "num_range": 70000000000, "upper_bound": "27aa06b2-23b0-4657-bf1a-868c2caa4267"}, {"distinct_range": 6250490.203857712, "num_eq": 9000, "num_range": 8000000, "upper_bound": "2adf3522-a923-4e7f-b195-0d87f94f6db3"}, {"distinct_range": 0, "num_eq": 400000000, "num_range": 1000000, "upper_bound": "2b6bdabd-4d3d-4398-9e2b-e91c00db922d"}, {"distinct_range": 0, "num_eq": 6901762048339736075, "num_range": 300000000, "upper_bound": "5e9314c2-3e6e-4ada-99f4-de63d53539b3"}, {"distinct_range": 0, "num_eq": 700, "num_range": 0, "upper_bound": "7637fe0c-fc1a-4100-8d38-ce60fee73f4a"}, {"distinct_range": 5452118470231646000, "num_eq": 30, "num_range": 5950706832199024340, "upper_bound": "db9c01ee-ca83-4cd9-a8e4-fb63545fbeaf"}], "histo_col_type": "UUID", "name": "__auto__", "null_count": 0, "row_count": 5264773068629512561}, {"columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1617510120016612513, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 5264773068629512561}, {"columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2373548466731433415, "histo_buckets": [{"distinct_range": 0, "num_eq": 0, "num_range": 0, "upper_bound": "0"}, {"distinct_range": 1170562097425503500, "num_eq": 60000000000, "num_range": 3374604166267251746, "upper_bound": "2408116281"}, {"distinct_range": 7053.003687852531, "num_eq": 90000, "num_range": 9000, "upper_bound": "2697176809"}], "histo_col_type": "REGCLASS", "name": "__auto__", "null_count": 307390625408134312, "row_count": 5264773068629512561}, {"columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3235456448938197027, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 5264773068629512561}, {"columns": ["col1_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4146689860839378297, "histo_col_type": "", "name": "__auto__", "null_count": 1575928143738560249, "row_count": 5264773068629512561}, {"columns": ["col1_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1077391898672556377, "histo_col_type": "", "name": "__auto__", "null_count": 3888091711992327439, "row_count": 5264773068629512561}, {"columns": ["col1_12"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4694106640063611410, "histo_col_type": "", "name": "__auto__", "null_count": 3536021012379154036, "row_count": 5264773068629512561}, {"columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 150630480523201899, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 5264773068629512561}, {"columns": ["col1_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3140973219383891661, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 5264773068629512561}, {"columns": ["col1_16"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2761215638782107736, "histo_col_type": "", "name": "__auto__", "null_count": 1716409782566935870, "row_count": 5264773068629512561}, {"columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2503032092598807648, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 5264773068629512561}, {"columns": ["col1_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3466774420260489958, "histo_buckets": [{"distinct_range": 0, "num_eq": 6167840909367221526, "num_range": 0, "upper_bound": "\\u0010+\\\\\\u00119\\u001fx\\u001a\\u0013"}, {"distinct_range": 109655612631351250, "num_eq": 200000000, "num_range": 109655612631351251, "upper_bound": "\\u0013\\"XXx"}, {"distinct_range": 2782593633653293000, "num_eq": 10, "num_range": 8013407933529129428, "upper_bound": "("}, {"distinct_range": 5000000, "num_eq": 600000000, "num_range": 5000000, "upper_bound": ",g"}, {"distinct_range": 7000, "num_eq": 5000000000, "num_range": 7000, "upper_bound": "-wGW\\u0013"}, {"distinct_range": 5191.7051612499, "num_eq": 1594205357511693941, "num_range": 10000, "upper_bound": "^8V|"}, {"distinct_range": 8636596115089288000, "num_eq": 3000000000, "num_range": 8636596115089287753, "upper_bound": "al\\u0011G&"}, {"distinct_range": 5855712511529231000, "num_eq": 8660650487161941817, "num_range": 5855712511529231142, "upper_bound": "h;h]l"}, {"distinct_range": 80000000000, "num_eq": 6419716486793675035, "num_range": 80000000000, "upper_bound": "i"}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 0, "row_count": 5264773068629512561}, {"columns": ["col1_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3803773540353696747, "histo_col_type": "", "name": "__auto__", "null_count": 2047662578572271410, "row_count": 5264773068629512561}, {"columns": ["col1_13"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3451049609541250519, "histo_buckets": [{"distinct_range": 0, "num_eq": 5000000000, "num_range": 0, "upper_bound": "514561561"}, {"distinct_range": 0, "num_eq": 3741918705345740299, "num_range": 6232716396626965961, "upper_bound": "2580603870"}], "histo_col_type": "REGCLASS", "name": "__auto__", "null_count": 0, "row_count": 5264773068629512561}, {"columns": ["col1_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1481180118622691609, "histo_col_type": "", "name": "__auto__", "null_count": 3064988769034632803, "row_count": 5264773068629512561}, {"columns": ["col1_14"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2678455511722050700, "histo_col_type": "", "name": "__auto__", "null_count": 4346267631527407850, "row_count": 5264773068629512561}, {"columns": ["col1_15"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 626341303612084165, "histo_col_type": "", "name": "__auto__", "null_count": 1519484172729407089, "row_count": 5264773068629512561}, {"columns": ["col1_17"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 617440104189040949, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 5264773068629512561}]':::JSONB;
test_1 | ALTER TABLE table2 INJECT STATISTICS e'[{"columns": ["col2_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 531089262, "histo_col_type": "", "name": "__auto__", "null_count": 2269638, "row_count": 800000000}, {"columns": ["col2_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 271861981, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000000}, {"columns": ["col2_15"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 536033038, "histo_col_type": "", "name": "__auto__", "null_count": 229706442, "row_count": 800000000}, {"columns": ["col2_16"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 188291910, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000000}, {"columns": ["col2_20"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 199445986, "histo_col_type": "", "name": "__auto__", "null_count": 566394165, "row_count": 800000000}, {"columns": ["col2_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 660007258, "histo_col_type": "", "name": "__auto__", "null_count": 739896283, "row_count": 800000000}, {"columns": ["col2_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 550818419, "histo_col_type": "", "name": "__auto__", "null_count": 609868552, "row_count": 800000000}, {"columns": ["col2_13"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 294267466, "histo_col_type": "", "name": "__auto__", "null_count": 731088392, "row_count": 800000000}, {"columns": ["col2_14"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 30885417, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000000}, {"columns": ["col2_19"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 92983406, "histo_col_type": "", "name": "__auto__", "null_count": 609807474, "row_count": 800000000}, {"columns": ["col2_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 9314345, "histo_col_type": "", "name": "__auto__", "null_count": 31679545, "row_count": 800000000}, {"columns": ["col2_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 535578442, "histo_col_type": "", "name": "__auto__", "null_count": 18626456, "row_count": 800000000}, {"columns": ["col2_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 140017543, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000000}, {"columns": ["col2_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 693771245, "histo_col_type": "", "name": "__auto__", "null_count": 772411988, "row_count": 800000000}, {"columns": ["col2_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 640022028, "histo_col_type": "", "name": "__auto__", "null_count": 592275350, "row_count": 800000000}, {"columns": ["col2_17"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 350207829, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000000}, {"columns": ["col1_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 521067760, "histo_buckets": [{"distinct_range": 0, "num_eq": 5323064433386738059, "num_range": 0, "upper_bound": "#\' \\u000f/"}, {"distinct_range": 123962575015661950, "num_eq": 4027352301738067254, "num_range": 5165920094039635167, "upper_bound": "\'"}, {"distinct_range": 0, "num_eq": 1281779291145931977, "num_range": 1288796926818053314, "upper_bound": "X"}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 0, "row_count": 800000000}, {"columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 268215915, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000000}, {"columns": ["col2_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 703864061, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000000}, {"columns": ["col2_12"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 602795172, "histo_col_type": "", "name": "__auto__", "null_count": 129285361, "row_count": 800000000}, {"columns": ["col2_18"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 105508335, "histo_col_type": "", "name": "__auto__", "null_count": 281705123, "row_count": 800000000}]':::JSONB;
test_1 | ALTER TABLE table3 INJECT STATISTICS '[{"columns": ["col3_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 106485118579108618, "histo_buckets": [{"distinct_range": 0, "num_eq": 4295214875267173268, "num_range": 0, "upper_bound": "BOX(-10 -10,10 10)"}, {"distinct_range": 5451331042291738000, "num_eq": 0, "num_range": 5451331042291738037, "upper_bound": "BOX(-1.1560556094792798 0.5554612352952838,-1.0813831601844792 1.127071637161125)"}, {"distinct_range": 800000, "num_eq": 2730370645043636915, "num_range": 800000, "upper_bound": "BOX(-0.7718028655548825 0.8603337445586313,-0.5511990021736679 1.3867727756854478)"}, {"distinct_range": 300, "num_eq": 1000000000, "num_range": 300, "upper_bound": "BOX(0.39466094932671947 0.8112609160356898,1.797528663129175 1.167319836345842)"}, {"distinct_range": 1708445049.2811863, "num_eq": 6597420025174528477, "num_range": 5000000000, "upper_bound": "BOX(0.5871827925238902 0.23570585999199672,2.638185941921372 2.077831238724916)"}], "histo_col_type": "BOX2D", "name": "__auto__", "null_count": 0, "row_count": 1090549937514315425}, {"columns": ["col3_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1042821497425230013, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1090549937514315425}, {"columns": ["col3_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 376764956841085688, "histo_buckets": [{"distinct_range": 0, "num_eq": 80000, "num_range": 0, "upper_bound": "!"}, {"distinct_range": 0, "num_eq": 900000000, "num_range": 0, "upper_bound": "X"}, {"distinct_range": 374857415025553900, "num_eq": 4000, "num_range": 374857415025553920, "upper_bound": "a"}, {"distinct_range": 0, "num_eq": 300000000, "num_range": 40000000000, "upper_bound": "w"}], "histo_col_type": "CHAR", "name": "__auto__", "null_count": 0, "row_count": 1090549937514315425}, {"columns": ["col3_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 310162863140125791, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1090549937514315425}, {"columns": ["col3_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 666583995914946756, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1090549937514315425}, {"columns": ["col3_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 808149738396816397, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1090549937514315425}, {"columns": ["col3_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 475604084811959176, "histo_buckets": [{"distinct_range": 0, "num_eq": 4255230894560249795, "num_range": 0, "upper_bound": "-1515982082"}, {"distinct_range": 100000000, "num_eq": 40000000, "num_range": 100000000, "upper_bound": "-129513251"}, {"distinct_range": 0, "num_eq": 800000, "num_range": 4000000, "upper_bound": "-8911161"}, {"distinct_range": 728878782880375200, "num_eq": 900000000, "num_range": 728878782880375215, "upper_bound": "32767"}, {"distinct_range": 997234692213603600, "num_eq": 0, "num_range": 997234692213603538, "upper_bound": "1400708496"}, {"distinct_range": 900000000, "num_eq": 90, "num_range": 900000000, "upper_bound": "1500822183"}, {"distinct_range": 134026.87573663535, "num_eq": 8000, "num_range": 1000000, "upper_bound": "2081425215"}, {"distinct_range": 70000000, "num_eq": 3689024650722625091, "num_range": 70000000, "upper_bound": "2101606374"}], "histo_col_type": "INT4", "name": "__auto__", "null_count": 0, "row_count": 1090549937514315425}, {"columns": ["col3_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 968798266367716372, "histo_buckets": [{"distinct_range": 0, "num_eq": 40000000, "num_range": 0, "upper_bound": "-infinity"}, {"distinct_range": 0, "num_eq": 7000000, "num_range": 20000000000, "upper_bound": "1973-04-05"}, {"distinct_range": 0, "num_eq": 175214908726920441, "num_range": 2000000, "upper_bound": "1973-12-12"}], "histo_col_type": "DATE", "name": "__auto__", "null_count": 0, "row_count": 1090549937514315425}, {"columns": ["col3_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 93827233301117453, "histo_col_type": "", "name": "__auto__", "null_count": 1083965211798778518, "row_count": 1090549937514315425}, {"columns": ["col3_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 476069407410322681, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1090549937514315425}, {"columns": ["col3_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 21183968205422253, "histo_col_type": "", "name": "__auto__", "null_count": 27691542826758430, "row_count": 1090549937514315425}, {"columns": ["col3_12"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 711691957902665380, "histo_col_type": "", "name": "__auto__", "null_count": 474329234129622264, "row_count": 1090549937514315425}, {"columns": ["col3_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 501284723197204143, "histo_buckets": [{"distinct_range": 0, "num_eq": 6817406700735719482, "num_range": 0, "upper_bound": "-23967"}, {"distinct_range": 0, "num_eq": 700000000, "num_range": 600000000, "upper_bound": "-8212"}, {"distinct_range": 717307880.2815169, "num_eq": 7084754744759234073, "num_range": 800000000, "upper_bound": "-2442"}, {"distinct_range": 8356559417012031000, "num_eq": 9000000, "num_range": 8356559417012031887, "upper_bound": "30577"}], "histo_col_type": "INT2", "name": "__auto__", "null_count": 770566015322324505, "row_count": 1090549937514315425}]':::JSONB;
test_1 | ALTER TABLE table2 ADD FOREIGN KEY (col2_3) REFERENCES table3 (col3_0) ON UPDATE RESTRICT;
test_1 | CREATE TYPE rand_typ_0 AS ENUM ('bzkh', 'fglpoz', 'gqvbi', 'ild');
test_1 | CREATE TYPE rand_typ_1 AS ENUM ('a', 'zdnsg', 'gbsinb', 'ocd');
test_1 | CREATE TYPE rand_typ_2 AS ENUM ('hlgln', 'yroqd', 'arlsr', 'dcsrah', 'vc');
test_1 | ALTER TABLE table1 INJECT STATISTICS e'[{"columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 426004, "histo_buckets": [{"distinct_range": 0, "num_eq": 3382444488765919265, "num_range": 0, "upper_bound": "01a9cc68-507c-4e96-ad07-e30bf80fbdab"}, {"distinct_range": 169692.90066975378, "num_eq": 400000000, "num_range": 200000, "upper_bound": "24ed2fa8-56b0-4013-bbaa-e57b6eeda3c7"}, {"distinct_range": 146.66512579643683, "num_eq": 4751721683157134156, "num_range": 200, "upper_bound": "365f63a7-b56d-4da0-9fcb-935d5188e4fe"}, {"distinct_range": 2863705922311953400, "num_eq": 90, "num_range": 2863705922311953497, "upper_bound": "56b05ace-f338-495c-953b-7a70359572b5"}, {"distinct_range": 900000000, "num_eq": 8882809679768753170, "num_range": 900000000, "upper_bound": "56bb5cf0-c982-4810-b24a-806b5527d462"}, {"distinct_range": 3140256248969680400, "num_eq": 100000000, "num_range": 6766848730377890536, "upper_bound": "666b6c1a-26c9-4ead-a6f7-c23a45319acc"}, {"distinct_range": 0, "num_eq": 40, "num_range": 100000, "upper_bound": "7542b57d-d608-4749-8d04-4cf0d907b6d0"}, {"distinct_range": 4617328793388384000, "num_eq": 7425501027677313569, "num_range": 7180578257923336726, "upper_bound": "c45c19fd-05c6-4f26-87b2-edab54eeb71f"}, {"distinct_range": 1139981032069843500, "num_eq": 9000000, "num_range": 1665121001851189577, "upper_bound": "fdf213d4-4d0d-4374-a947-5b7d38708200"}], "histo_col_type": "UUID", "name": "__auto__", "null_count": 0, "row_count": 700000}, {"columns": ["col1_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 280247, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 700000}, {"columns": ["col1_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 33226, "histo_buckets": [{"distinct_range": 0, "num_eq": 60, "num_range": 0, "upper_bound": "\\u0001\\u0006]D\\u0006k\\u001dm!"}, {"distinct_range": 202.46500730435213, "num_eq": 50, "num_range": 300, "upper_bound": "\\u0006N$)@1"}, {"distinct_range": 413534.4517663274, "num_eq": 50000, "num_range": 500000, "upper_bound": "1"}, {"distinct_range": 0, "num_eq": 7366843779918102567, "num_range": 125058300274987810, "upper_bound": "GF\\u0001_V)Z"}, {"distinct_range": 0, "num_eq": 1849759022243482064, "num_range": 0, "upper_bound": "KEs`S"}, {"distinct_range": 20.06922565075464, "num_eq": 4621381862321914516, "num_range": 70, "upper_bound": "kcH"}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 0, "row_count": 700000}, {"columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 604743, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 700000}, {"columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 157055, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 700000}, {"columns": ["col1_16"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 613597, "histo_col_type": "", "name": "__auto__", "null_count": 252540, "row_count": 700000}, {"columns": ["col1_12"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 449850, "histo_col_type": "", "name": "__auto__", "null_count": 429352, "row_count": 700000}, {"columns": ["col1_15"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 513624, "histo_col_type": "", "name": "__auto__", "null_count": 36982, "row_count": 700000}, {"columns": ["col1_17"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 402022, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 700000}, {"columns": ["col1_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 30744, "histo_col_type": "", "name": "__auto__", "null_count": 324887, "row_count": 700000}, {"columns": ["col1_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 136886, "histo_col_type": "", "name": "__auto__", "null_count": 76749, "row_count": 700000}, {"columns": ["col1_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 163606, "histo_col_type": "", "name": "__auto__", "null_count": 444150, "row_count": 700000}, {"columns": ["col1_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 34274, "histo_col_type": "", "name": "__auto__", "null_count": 460428, "row_count": 700000}, {"columns": ["col1_13"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 607066, "histo_buckets": [{"distinct_range": 0, "num_eq": 1881295185818142844, "num_range": 0, "upper_bound": "571379023"}, {"distinct_range": 5517947237039390000, "num_eq": 10000000000, "num_range": 5517947237039390163, "upper_bound": "588899118"}, {"distinct_range": 517164566306246500, "num_eq": 1705159521765596740, "num_range": 7380226828250081984, "upper_bound": "606089268"}, {"distinct_range": 8000000, "num_eq": 6090412277292793048, "num_range": 8000000, "upper_bound": "3237715084"}], "histo_col_type": "REGCLASS", "name": "__auto__", "null_count": 0, "row_count": 700000}, {"columns": ["col1_14"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 549050, "histo_col_type": "", "name": "__auto__", "null_count": 124766, "row_count": 700000}, {"columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 266030, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 700000}, {"columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 181163, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 700000}, {"columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 160989, "histo_buckets": [{"distinct_range": 0, "num_eq": 2435450366863008153, "num_range": 0, "upper_bound": "0"}, {"distinct_range": 389343980995123400, "num_eq": 6205187655087112057, "num_range": 2152389883637377381, "upper_bound": "1188769870"}, {"distinct_range": 0, "num_eq": 0, "num_range": 20000000000, "upper_bound": "1400962437"}, {"distinct_range": 4782548267466028000, "num_eq": 10000000, "num_range": 4782548267466028091, "upper_bound": "1543871154"}, {"distinct_range": 70736806217816010, "num_eq": 0, "num_range": 5214023905636213078, "upper_bound": "1899698790"}, {"distinct_range": 474335585902644100, "num_eq": 40000, "num_range": 4043942782539384481, "upper_bound": "4269574496"}, {"distinct_range": 0, "num_eq": 5107801431075877468, "num_range": 10000000, "upper_bound": "4294333048"}], "histo_col_type": "REGCLASS", "name": "__auto__", "null_count": 658003, "row_count": 700000}]';
test_1 | ALTER TABLE table2 INJECT STATISTICS e'[{"columns": ["col1_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 872468022778873836, "histo_buckets": [{"distinct_range": 0, "num_eq": 1966195584511315207, "num_range": 0, "upper_bound": ""}, {"distinct_range": 4815339145108044000, "num_eq": 1363924749826115120, "num_range": 4815339145108044209, "upper_bound": "\\u0006v\\u001d"}, {"distinct_range": 700, "num_eq": 6000000, "num_range": 700, "upper_bound": "\'"}, {"distinct_range": 0, "num_eq": 3925721276046262476, "num_range": 2440506595738460006, "upper_bound": "3\\u001d\\u0001)(="}, {"distinct_range": 2611447829.393381, "num_eq": 6375282633033861916, "num_range": 10000000000, "upper_bound": ">D"}, {"distinct_range": 0, "num_eq": 7430726011271457020, "num_range": 234215950594991989, "upper_bound": "E"}, {"distinct_range": 1983875680941752000, "num_eq": 800000, "num_range": 7734958462715336938, "upper_bound": "H("}, {"distinct_range": 8027266122705661000, "num_eq": 30000000, "num_range": 8027266122705661328, "upper_bound": "J%\\u0016@J>~\\u0010"}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 0, "row_count": 1323678561550484512}, {"columns": ["col2_12"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 257029671881995510, "histo_col_type": "", "name": "__auto__", "null_count": 783383180789221471, "row_count": 1323678561550484512}, {"columns": ["col2_18"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 286846226650547868, "histo_col_type": "", "name": "__auto__", "null_count": 1087244624979969041, "row_count": 1323678561550484512}, {"columns": ["col2_19"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 347398917641345222, "histo_col_type": "", "name": "__auto__", "null_count": 607504919381385762, "row_count": 1323678561550484512}, {"columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1302723782286317954, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1323678561550484512}, {"columns": ["col2_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1077653085753666305, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1323678561550484512}, {"columns": ["col2_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 804710074556017480, "histo_col_type": "", "name": "__auto__", "null_count": 278579946435981407, "row_count": 1323678561550484512}, {"columns": ["col2_13"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 751531238569614692, "histo_col_type": "", "name": "__auto__", "null_count": 751817266361118660, "row_count": 1323678561550484512}, {"columns": ["col2_16"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 304448975003032246, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1323678561550484512}, {"columns": ["col2_17"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 83059344709546157, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1323678561550484512}, {"columns": ["col2_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 397091310782812777, "histo_col_type": "", "name": "__auto__", "null_count": 24892413009243577, "row_count": 1323678561550484512}, {"columns": ["col2_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 820593997933422695, "histo_col_type": "", "name": "__auto__", "null_count": 1279603701973992412, "row_count": 1323678561550484512}, {"columns": ["col2_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1182627181836164043, "histo_col_type": "", "name": "__auto__", "null_count": 549481653734402478, "row_count": 1323678561550484512}, {"columns": ["col2_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 428122249000195612, "histo_col_type": "", "name": "__auto__", "null_count": 486303518930046368, "row_count": 1323678561550484512}, {"columns": ["col2_14"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 201112583813925674, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1323678561550484512}, {"columns": ["col2_15"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 948016955261094601, "histo_col_type": "", "name": "__auto__", "null_count": 773962716552022616, "row_count": 1323678561550484512}, {"columns": ["col2_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 826262456430552930, "histo_col_type": "", "name": "__auto__", "null_count": 1176544853907403414, "row_count": 1323678561550484512}, {"columns": ["col2_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 709823785733567980, "histo_col_type": "", "name": "__auto__", "null_count": 485889156970972139, "row_count": 1323678561550484512}, {"columns": ["col2_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 836670731699766424, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1323678561550484512}, {"columns": ["col2_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 468728709433940270, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 1323678561550484512}, {"columns": ["col2_20"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 887903098004445525, "histo_col_type": "", "name": "__auto__", "null_count": 230569023965545209, "row_count": 1323678561550484512}]';
test_1 | ALTER TABLE table3 INJECT STATISTICS '[{"columns": ["col3_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5, "histo_col_type": "", "name": "__auto__", "null_count": 4, "row_count": 10}, {"columns": ["col3_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 8, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 10}, {"columns": ["col3_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 10}, {"columns": ["col3_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 9, "row_count": 10}, {"columns": ["col3_12"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5, "histo_col_type": "", "name": "__auto__", "null_count": 4, "row_count": 10}, {"columns": ["col3_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5, "histo_buckets": [{"distinct_range": 0, "num_eq": 5932628388188399925, "num_range": 0, "upper_bound": "19491"}], "histo_col_type": "INT2", "name": "__auto__", "null_count": 8, "row_count": 10}, {"columns": ["col3_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 5, "histo_buckets": [{"distinct_range": 0, "num_eq": 20, "num_range": 0, "upper_bound": "-2113780066"}, {"distinct_range": 0, "num_eq": 30000000000, "num_range": 100, "upper_bound": "-2044825271"}, {"distinct_range": 42347.56566870703, "num_eq": 4115252640736049529, "num_range": 50000, "upper_bound": "-1990249582"}, {"distinct_range": 0, "num_eq": 3992199889491903704, "num_range": 5554098136404371134, "upper_bound": "-1532769302"}, {"distinct_range": 3000000, "num_eq": 2021148089167473169, "num_range": 3000000, "upper_bound": "-1474935780"}, {"distinct_range": 4703.275478724117, "num_eq": 5540744886541192291, "num_range": 5000, "upper_bound": "-1432603466"}, {"distinct_range": 200000, "num_eq": 10000000, "num_range": 200000, "upper_bound": "-1090148609"}, {"distinct_range": 7277345139136295000, "num_eq": 4464728382761925420, "num_range": 7277345139136295259, "upper_bound": "1"}], "histo_col_type": "INT4", "name": "__auto__", "null_count": 0, "row_count": 10}, {"columns": ["col3_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 8, "histo_col_type": "DATE", "name": "__auto__", "null_count": 0, "row_count": 10}, {"columns": ["col3_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 9, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 10}, {"columns": ["col3_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 8, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 10}, {"columns": ["col3_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 8, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 10}, {"columns": ["col3_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 6, "histo_buckets": [{"distinct_range": 0, "num_eq": 5000000, "num_range": 0, "upper_bound": "BOX(-2.2846407862085845 0.19474031957669347,-0.37682776482752 2.5117600233612474)"}, {"distinct_range": 0, "num_eq": 8000000, "num_range": 300000000, "upper_bound": "BOX(-1.6746664837787995 1.0568925048406288,-0.2080320132309085 1.2917486611057685)"}, {"distinct_range": 8000000000, "num_eq": 20, "num_range": 8000000000, "upper_bound": "BOX(-0.2566329151471063 0.8178470023938447,0.5722267281205795 1.2233775508869438)"}, {"distinct_range": 0, "num_eq": 50000000000, "num_range": 25823384120326362, "upper_bound": "BOX(1.1423731531237546 0.5836297803240313,1.1466489809394076 0.9390560337724602)"}], "histo_col_type": "BOX2D", "name": "__auto__", "null_count": 0, "row_count": 10}, {"columns": ["col3_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 8, "histo_col_type": "CHAR", "name": "__auto__", "null_count": 0, "row_count": 10}]';
test_1 | ALTER TABLE table1 INJECT STATISTICS e'[{"columns": ["col1_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_buckets": [{"distinct_range": 0, "num_eq": 8000, "num_range": 0, "upper_bound": "00000000-0000-0000-0000-000000000000"}, {"distinct_range": 7307706540470971000, "num_eq": 40000000, "num_range": 7307706540470971496, "upper_bound": "18512cf6-c4c5-4250-a223-6e710c1f351c"}, {"distinct_range": 5215913.639961826, "num_eq": 20000, "num_range": 20000000, "upper_bound": "852a0c30-89fc-47e1-9d2e-4dc9128e9a1c"}, {"distinct_range": 0, "num_eq": 5558854056798136852, "num_range": 0, "upper_bound": "ac070a06-2cb6-4f56-b88d-09bdef890576"}, {"distinct_range": 290.8731961476783, "num_eq": 0, "num_range": 300, "upper_bound": "b4877642-a10d-4849-9295-1a6cb1298ed3"}, {"distinct_range": 0, "num_eq": 5000000, "num_range": 0, "upper_bound": "e9c48676-697a-4b66-b95d-f106b27685b2"}, {"distinct_range": 0, "num_eq": 4975097636351845490, "num_range": 8804777811395790123, "upper_bound": "ebc79460-0c9b-40db-847e-ef25c93192c7"}, {"distinct_range": 200344690.87579966, "num_eq": 70000, "num_range": 600000000, "upper_bound": "fb8cdb83-5e9b-4b56-b6ab-148b76d1b59d"}], "histo_col_type": "UUID", "name": "__auto__", "null_count": 0, "row_count": 0}, {"columns": ["col1_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}, {"columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}, {"columns": ["col1_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}, {"columns": ["col1_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}, {"columns": ["col1_13"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_buckets": [{"distinct_range": 0, "num_eq": 20000000000, "num_range": 0, "upper_bound": "15617840"}, {"distinct_range": 0, "num_eq": 2622348327210885604, "num_range": 5000000000, "upper_bound": "55603561"}, {"distinct_range": 0, "num_eq": 451272090181646398, "num_range": 1000, "upper_bound": "667744454"}, {"distinct_range": 0, "num_eq": 200, "num_range": 7710904950572256703, "upper_bound": "707417430"}, {"distinct_range": 0, "num_eq": 7000000000, "num_range": 20000000, "upper_bound": "3587153437"}, {"distinct_range": 173869543.84134007, "num_eq": 5538454736856108353, "num_range": 1000000000, "upper_bound": "4050614957"}, {"distinct_range": 339305382000619400, "num_eq": 2000000000, "num_range": 3363983503310453134, "upper_bound": "4095221558"}], "histo_col_type": "REGCLASS", "name": "__auto__", "null_count": 0, "row_count": 0}, {"columns": ["col1_14"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}, {"columns": ["col1_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}, {"columns": ["col1_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}, {"columns": ["col1_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}, {"columns": ["col1_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}, {"columns": ["col1_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_buckets": [{"distinct_range": 0, "num_eq": 1369683240850839637, "num_range": 0, "upper_bound": "\\r\'\\"\\u000f\\u0018"}, {"distinct_range": 68.73364619508057, "num_eq": 600000, "num_range": 80, "upper_bound": " \\u001d\\u0013&\\\\q]"}, {"distinct_range": 26105775257786116, "num_eq": 2823837873752997562, "num_range": 2246530268041301071, "upper_bound": "$CR\'dr\\u0007"}, {"distinct_range": 5953442203138612000, "num_eq": 8951604878274315010, "num_range": 5953442203138612701, "upper_bound": "\'"}, {"distinct_range": 2287730449886233000, "num_eq": 493587146170651277, "num_range": 8206876941010919958, "upper_bound": "WZX"}, {"distinct_range": 1268360009120247600, "num_eq": 0, "num_range": 1268360009120247509, "upper_bound": "]&/<IB\\"\\t\\\\"}, {"distinct_range": 179372487.00942084, "num_eq": 7100634498329853529, "num_range": 200000000, "upper_bound": "a9.\\u00162=\\u000e"}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 0, "row_count": 0}, {"columns": ["col1_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}, {"columns": ["col1_12"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}, {"columns": ["col1_15"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}, {"columns": ["col1_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_buckets": [{"distinct_range": 0, "num_eq": 10000, "num_range": 0, "upper_bound": "1241278531"}, {"distinct_range": 8907992604018941000, "num_eq": 8428029467629366274, "num_range": 8907992604018940672, "upper_bound": "1831791674"}, {"distinct_range": 0, "num_eq": 30000000000, "num_range": 4781423049920232006, "upper_bound": "2812928161"}, {"distinct_range": 318035053789377860, "num_eq": 600, "num_range": 318035053789377868, "upper_bound": "2982143431"}, {"distinct_range": 2105497018831626200, "num_eq": 50000000, "num_range": 2105497018831626348, "upper_bound": "3924008383"}], "histo_col_type": "REGCLASS", "name": "__auto__", "null_count": 0, "row_count": 0}, {"columns": ["col1_16"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}, {"columns": ["col1_17"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 0, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 0}]';
test_1 | ALTER TABLE table2 INJECT STATISTICS e'[{"columns": ["col1_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 27418, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000}, {"columns": ["col2_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 744176, "histo_col_type": "", "name": "__auto__", "null_count": 472626, "row_count": 800000}, {"columns": ["col2_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 99037, "histo_col_type": "", "name": "__auto__", "null_count": 20337, "row_count": 800000}, {"columns": ["col2_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 690282, "histo_col_type": "", "name": "__auto__", "null_count": 461445, "row_count": 800000}, {"columns": ["col2_12"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 108359, "histo_col_type": "", "name": "__auto__", "null_count": 46870, "row_count": 800000}, {"columns": ["col2_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 349914, "histo_col_type": "", "name": "__auto__", "null_count": 355887, "row_count": 800000}, {"columns": ["col2_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 231521, "histo_col_type": "", "name": "__auto__", "null_count": 243551, "row_count": 800000}, {"columns": ["col2_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 350611, "histo_col_type": "", "name": "__auto__", "null_count": 344769, "row_count": 800000}, {"columns": ["col2_19"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 689237, "histo_col_type": "", "name": "__auto__", "null_count": 376293, "row_count": 800000}, {"columns": ["col2_20"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 69300, "histo_col_type": "", "name": "__auto__", "null_count": 303188, "row_count": 800000}, {"columns": ["col2_18"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 558840, "histo_col_type": "", "name": "__auto__", "null_count": 472260, "row_count": 800000}, {"columns": ["col1_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 514712, "histo_buckets": [{"distinct_range": 0, "num_eq": 2000000, "num_range": 0, "upper_bound": "\\u0018qT\\u0014"}, {"distinct_range": 12068616471.459253, "num_eq": 7409861834614368316, "num_range": 50000000000, "upper_bound": "5"}, {"distinct_range": 0, "num_eq": 9000000000, "num_range": 5038002525183865602, "upper_bound": "F\\u0017u.G5="}, {"distinct_range": 9773.956387953367, "num_eq": 10000, "num_range": 10000, "upper_bound": "SEvSL"}, {"distinct_range": 39.52746847091306, "num_eq": 7210075054460087553, "num_range": 100, "upper_bound": "{>"}, {"distinct_range": 507.0288794819432, "num_eq": 30000000000, "num_range": 10000, "upper_bound": "\U00002603"}], "histo_col_type": "STRING", "name": "__auto__", "null_count": 0, "row_count": 800000}, {"columns": ["col2_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 29515, "histo_col_type": "", "name": "__auto__", "null_count": 94544, "row_count": 800000}, {"columns": ["col2_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 379785, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000}, {"columns": ["col2_13"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 502826, "histo_col_type": "", "name": "__auto__", "null_count": 680491, "row_count": 800000}, {"columns": ["col2_14"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 752199, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000}, {"columns": ["col2_15"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 365119, "histo_col_type": "", "name": "__auto__", "null_count": 361068, "row_count": 800000}, {"columns": ["col2_17"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 36563, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000}, {"columns": ["col2_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 126032, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000}, {"columns": ["col2_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 256599, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000}, {"columns": ["col2_16"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 329222, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 800000}]';
test_1 | ALTER TABLE table3 INJECT STATISTICS e'[{"columns": ["col3_10"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2886770669, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 5000000000}, {"columns": ["col3_0"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2419362460, "histo_buckets": [{"distinct_range": 0, "num_eq": 4335322686129013613, "num_range": 0, "upper_bound": "-10730"}, {"distinct_range": 2791340093643325000, "num_eq": 8173522266466955453, "num_range": 2791340093643324686, "upper_bound": "1"}, {"distinct_range": 8112374419516151000, "num_eq": 5123249980787520558, "num_range": 8343013248614723004, "upper_bound": "7347"}, {"distinct_range": 6894661663.882664, "num_eq": 3827909458329179610, "num_range": 10000000000, "upper_bound": "23132"}, {"distinct_range": 2284502335939307500, "num_eq": 5889826207702530592, "num_range": 2284502335939307562, "upper_bound": "30015"}, {"distinct_range": 0, "num_eq": 7015479025848403723, "num_range": 4000000, "upper_bound": "31631"}], "histo_col_type": "INT2", "name": "__auto__", "null_count": 409386635, "row_count": 5000000000}, {"columns": ["col3_2"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 889449164, "histo_buckets": [{"distinct_range": 0, "num_eq": 600000, "num_range": 0, "upper_bound": "-1582275995"}, {"distinct_range": 4.517892674659306, "num_eq": 3231978976451520882, "num_range": 70, "upper_bound": "-1264658024"}, {"distinct_range": 511524290.7951955, "num_eq": 9000000, "num_range": 700000000, "upper_bound": "-369330645"}, {"distinct_range": 6989876.698913743, "num_eq": 90, "num_range": 400000000, "upper_bound": "0"}, {"distinct_range": 3848730378067843600, "num_eq": 300000000, "num_range": 4864331594071624162, "upper_bound": "1035692445"}, {"distinct_range": 0, "num_eq": 60000, "num_range": 10, "upper_bound": "1207754670"}], "histo_col_type": "INT4", "name": "__auto__", "null_count": 0, "row_count": 5000000000}, {"columns": ["col3_3"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 4333019819, "histo_buckets": [{"distinct_range": 0, "num_eq": 2815644812641322167, "num_range": 0, "upper_bound": "BOX(-10 -10,10 10)"}, {"distinct_range": 68934.01758273788, "num_eq": 90, "num_range": 7000000, "upper_bound": "BOX(-1.1027617627555455 -0.5825046025802,-0.7502101940392464 -0.009010387274344389)"}, {"distinct_range": 0, "num_eq": 100000000, "num_range": 4744080144226022410, "upper_bound": "BOX(-0.5010530313251625 -0.2900578339808031,-0.2299315115964978 0.8661248653853795)"}, {"distinct_range": 2322551984390779400, "num_eq": 8000, "num_range": 9118391946680557679, "upper_bound": "BOX(-0.23343913268632174 -0.41941819099833444,0.7926274405375598 2.2243137477947283)"}, {"distinct_range": 0, "num_eq": 10000, "num_range": 70, "upper_bound": "BOX(-0.16724035445347216 -0.42974522759144995,0.201550196650498 -0.009211708730002321)"}, {"distinct_range": 50, "num_eq": 5000, "num_range": 50, "upper_bound": "BOX(0.20794066631961228 0.4505853262135555,1.043126007625896 0.5247073060067733)"}, {"distinct_range": 6379229080940591000, "num_eq": 4000000000, "num_range": 7197899241021107095, "upper_bound": "BOX(0.3424108031451659 -0.9954818783367446,1.4190264056139323 1.2756574312847548)"}, {"distinct_range": 0, "num_eq": 2000000000, "num_range": 1000000000, "upper_bound": "BOX(0.5479753230963027 -0.1858023417962869,0.74314778866965 1.0080039206094595)"}, {"distinct_range": 568153376325433800, "num_eq": 700, "num_range": 568153376325433766, "upper_bound": "BOX(0.9997507910863201 -0.041188765395610005,1.509640608092882 2.3511877185465346)"}], "histo_col_type": "BOX2D", "name": "__auto__", "null_count": 0, "row_count": 5000000000}, {"columns": ["col3_8"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1035547830, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 5000000000}, {"columns": ["col3_9"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3331422419, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 5000000000}, {"columns": ["col3_11"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3343997387, "histo_col_type": "", "name": "__auto__", "null_count": 455757341, "row_count": 5000000000}, {"columns": ["col3_12"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1180243885, "histo_col_type": "", "name": "__auto__", "null_count": 1766027436, "row_count": 5000000000}, {"columns": ["col3_1"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1685711784, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 5000000000}, {"columns": ["col3_4"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 2247001554, "histo_buckets": [{"distinct_range": 0, "num_eq": 600000000, "num_range": 0, "upper_bound": "1976-09-18"}, {"distinct_range": 770841701.1784762, "num_eq": 308721326854641563, "num_range": 1000000000, "upper_bound": "1983-08-27"}, {"distinct_range": 1000000000, "num_eq": 70, "num_range": 1000000000, "upper_bound": "1992-12-25"}], "histo_col_type": "DATE", "name": "__auto__", "null_count": 0, "row_count": 5000000000}, {"columns": ["col3_5"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 660163853, "histo_col_type": "", "name": "__auto__", "null_count": 741463140, "row_count": 5000000000}, {"columns": ["col3_6"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 1484341185, "histo_col_type": "", "name": "__auto__", "null_count": 0, "row_count": 5000000000}, {"columns": ["col3_7"], "created_at": "2000-01-01 00:00:00+00:00", "distinct_count": 3195337586, "histo_buckets": [{"distinct_range": 0, "num_eq": 40, "num_range": 0, "upper_bound": "\\u0000"}, {"distinct_range": 0, "num_eq": 10000000000, "num_range": 0, "upper_bound": "\\u0001"}, {"distinct_range": 185852941414546720, "num_eq": 100, "num_range": 299292903024414318, "upper_bound": "\\u000c"}, {"distinct_range": 0, "num_eq": 20000000000, "num_range": 300, "upper_bound": "\\""}, {"distinct_range": 723931194966117900, "num_eq": 8000000, "num_range": 7036741686676286919, "upper_bound": "`"}, {"distinct_range": 200000000, "num_eq": 10, "num_range": 200000000, "upper_bound": "u"}], "histo_col_type": "CHAR", "name": "__auto__", "null_count": 0, "row_count": 5000000000}]';
test_1 |
test_1 | compare_test.go:130: cockroach2: exec: ERROR: column "nan" does not exist (SQLSTATE 42703)
test_1 | FAIL
compare_test_1 exited with code 1
Stopping compare_postgres_1 ...
Stopping compare_cockroach1_1 ...
Stopping compare_cockroach2_1 ...
Stopping compare_cockroach2_1 ... done
Stopping compare_cockroach1_1 ... done
Stopping compare_postgres_1 ... done
Aborting on container exit...
compose_test.go:49: exit status 1
More
``` make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1 ``` Related: - #61683 compose: TestComposeCompare failed [C-test-failure](https://api.github.com/repos/cockroachdb/cockroach/labels/C-test-failure) [O-robot](https://api.github.com/repos/cockroachdb/cockroach/labels/O-robot) [branch-release-21.1](https://api.github.com/repos/cockroachdb/cockroach/labels/branch-release-21.1) [See this test on roachdash](https://roachdash.crdb.dev/?filter=status%3Aopen+t%3A.%2ATestComposeCompare.%2A&sort=title&restgroup=false&display=lastcommented+project) powered by [pkg/cmd/internal/issues](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/internal/issues)
(compose).TestComposeCompare failed on master@06944cb1996ed9ccfa036118b810e46673fe0ff4:
More
``` make stressrace TESTS=TestComposeCompare PKG=./pkg/compose TESTTIMEOUT=5m STRESSFLAGS='-timeout 5m' 2>&1 ``` [See this test on roachdash](https://roachdash.crdb.dev/?filter=status%3Aopen+t%3A.%2ATestComposeCompare.%2A&sort=title&restgroup=false&display=lastcommented+project) powered by [pkg/cmd/internal/issues](https://github.com/cockroachdb/cockroach/tree/master/pkg/cmd/internal/issues)