search

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.
https://www.cockroachlabs.com
Other
29.99k stars 3.79k forks source link

ccl/changefeedccl: TestChangefeedRandomExpressions failed #122507

Closed cockroach-teamcity closed 5 months ago

cockroach-teamcity commented 5 months ago

ccl/changefeedccl.TestChangefeedRandomExpressions failed on release-24.1 @ 963239b40f7faef787940c582b5e240cb076b71a:

        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-128):::INT8, 1937653005:::INT8, (-1524734012564707268):::INT8, 0.02735532633960247:::FLOAT8, (-0.0):::FLOAT8, 'infinity':::DATE, '294276-12-31 23:59:59.999999':::TIMESTAMP, '294276-12-31 23:59:59.999999+00':::TIMESTAMPTZ, '290 years':::INTERVAL, false, 1.0:::DECIMAL, e'\'':::STRING, '\x58':::BYTES, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '{}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (4018:::INT8, 1:::INT8, (-9223372036854775807):::INT8, (-0.8844200372695923):::FLOAT8, (-0.1944283907117461):::FLOAT8, '1976-10-13':::DATE, NULL, '1970-07-13 13:41:26.000382+00':::TIMESTAMPTZ, '-71 years -4 mons -915 days -18:39:59.547534':::INTERVAL, true, 'NaN':::DECIMAL, '{``CM':::STRING, '\x':::BYTES, '62270505-66fc-4ac1-85f5-792ccfb78dd3':::UUID, '119.113.197.208/12':::INET, NULL);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-11679):::INT8, 1117194343:::INT8, 9223372036854775807:::INT8, 0.5421541929244995:::FLOAT8, (-0.3469130180143585):::FLOAT8, '1994-11-10':::DATE, '1984-04-08 06:04:29.000898':::TIMESTAMP, '2026-04-18 23:46:01.000827+00':::TIMESTAMPTZ, '290 years':::INTERVAL, NULL, 0:::DECIMAL, '"':::STRING, '\xbb82':::BYTES, NULL, '0.0.0.0/0':::INET, '{"6nQYR": false, "7eYzPYUu": {"4NRTAx2": {"2Hb7Oo": [null], "a": "foo", "b": "foobar", "c": null}, "bar": 0.6354811929161959, "qDyE6ke": {"b": true, "baz": true, "c": "Uy", "qFsz": [true]}}, "baz": true, "nnVf": false}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-32768):::INT8, NULL, (-254125432534122281):::INT8, (-0.3579694926738739):::FLOAT8, 'NaN':::FLOAT8, '1976-12-24':::DATE, '294276-12-31 23:59:59.999999':::TIMESTAMP, '2001-01-01 00:00:00+00 BC':::TIMESTAMPTZ, '1 mon 1 day':::INTERVAL, true, (-5951.42510457525071):::DECIMAL, '':::STRING, NULL, '460f413c-0240-4ff4-9cbc-8ddef37103c4':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, 'true':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (32767:::INT8, (-1356350151):::INT8, (-9223372036854775807):::INT8, (-0.8169607520103455):::FLOAT8, (-1.0):::FLOAT8, '1974-02-23':::DATE, '294276-12-31 23:59:59.999999':::TIMESTAMP, '4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ, '24 years 2 mons 735 days 24:47:21.206988':::INTERVAL, true, (-1.0):::DECIMAL, '':::STRING, '\x22':::BYTES, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, '0.0.0.0/0':::INET, '{"test": "json"}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (127:::INT8, 58275229:::INT8, 127:::INT8, NULL, NULL, '1989-07-09':::DATE, '1989-10-01 14:33:46.000414':::TIMESTAMP, '0001-01-01 00:00:00+00':::TIMESTAMPTZ, '-5 years -6 mons -809 days -22:03:31.569259':::INTERVAL, true, 0:::DECIMAL, 'cVI':::STRING, NULL, '5e5efef8-44ed-4d10-9da0-b978f25b2b56':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '["Fo1COi", 1.3840232946096336]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (13692:::INT8, 1:::INT8, (-1):::INT8, (-0.13403494656085968):::FLOAT8, '-Inf':::FLOAT8, '1987-12-22':::DATE, '2018-03-16 18:06:19.000178':::TIMESTAMP, '1972-12-06 07:41:41.000914+00':::TIMESTAMPTZ, '23 years 2 mons 327 days 18:09:53.561313':::INTERVAL, false, (-4.514669304057132618E+24):::DECIMAL, e'\U00002603':::STRING, '\x27':::BYTES, '5f14ea85-6895-4653-983f-7308e3721401':::UUID, '101.169.25.162/2':::INET, '[{"Wm": ["LjD1qHjOf"], "pjLYGJ": "c"}, {"a": null}, true, null, false]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (0:::INT8, 136965638:::INT8, (-6364698901479551951):::INT8, 1.2417323589324951:::FLOAT8, 0.21946193790796015:::FLOAT8, '4714-11-24 BC':::DATE, '2001-01-01 00:00:00 BC':::TIMESTAMP, NULL, '-17 years -11 mons -949 days -15:29:12.822176':::INTERVAL, true, 9.141988564506293696:::DECIMAL, e'\x07LC\x14\\\x1c':::STRING, '\x':::BYTES, '0e2c6c6c-dd3a-4897-93f9-6bf025ef7ecd':::UUID, '833d:65c7:ad8d:b1b:43c4:6278:1ae8:b676/122':::INET, '{"test": "json"}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (32767:::INT8, (-32768):::INT8, 596483253221039597:::INT8, 0.8575220704078674:::FLOAT8, (-1.0):::FLOAT8, 'infinity':::DATE, '3000-01-01 00:00:00':::TIMESTAMP, '1973-02-09 08:24:38.000087+00':::TIMESTAMPTZ, '17 years 1 mon 604 days 15:47:07.463661':::INTERVAL, true, 765264978812.7034822:::DECIMAL, e'\U00002603':::STRING, '\x9bf2fd79':::BYTES, '6efb7c32-029e-4e89-937c-6a1e965f9888':::UUID, '135.197.44.253/14':::INET, '1':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (17815:::INT8, 127:::INT8, 2147483647:::INT8, 0.0:::FLOAT8, 1.7027388073306633:::FLOAT8, '5874897-12-31':::DATE, '294276-12-31 23:59:59.999999':::TIMESTAMP, '1978-03-05 03:19:03.000304+00':::TIMESTAMPTZ, '1 day':::INTERVAL, false, 'Infinity':::DECIMAL, '"':::STRING, '\x27':::BYTES, '4ef1ed30-223e-425f-831c-2897ddd951d5':::UUID, '79.40.222.36/18':::INET, '{"test": "json"}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (5659:::INT8, 32767:::INT8, 2843116169263002389:::INT8, 0.0:::FLOAT8, (-0.44079021781925065):::FLOAT8, '-infinity':::DATE, '1977-05-26 20:28:45.000988':::TIMESTAMP, '4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ, '00:00:00':::INTERVAL, false, 'NaN':::DECIMAL, e'\U00002603':::STRING, NULL, '00000000-0000-0000-0000-000000000000':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '{"foo": "a", "foobar": "foobar"}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (28820:::INT8, (-693804724):::INT8, (-8170459207478066225):::INT8, 0.0935012698173523:::FLOAT8, 0.45612524629977813:::FLOAT8, '1987-05-13':::DATE, '0001-01-01 00:00:00':::TIMESTAMP, '2003-10-04 07:08:48.000984+00':::TIMESTAMPTZ, '55 years 10 mons 197 days 09:35:36.610086':::INTERVAL, true, (-1.0):::DECIMAL, e'9Vm\x1ecs':::STRING, '\x31333ff99a3476':::BYTES, '55caaa11-5a77-4a15-9726-df4a7f850826':::UUID, '5897:2798:25f3:a603:d1b2:1283:fa52:6267/40':::INET, '[{"Ij": null, "rQ6eHCR3": "UXtpt"}, "b", null, "foobar"]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (8420:::INT8, 2147483647:::INT8, NULL, '+Inf':::FLOAT8, (-0.04836652574401423):::FLOAT8, '4714-11-24 BC':::DATE, '0001-01-01 00:00:00':::TIMESTAMP, '2000-03-25 23:07:20.000794+00':::TIMESTAMPTZ, '290 years':::INTERVAL, false, 0:::DECIMAL, e'\fb\x12L':::STRING, '\x3714bf5543':::BYTES, '504bc451-02e9-4eb3-bfc6-52c8ffca5569':::UUID, '21.142.57.233/13':::INET, '{"Bl3NTn2": null, "Cx14zF": "baz"}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (NULL, 2138534065:::INT8, NULL, 0.01594742015004158:::FLOAT8, (-0.0):::FLOAT8, 'infinity':::DATE, '2011-01-12 13:24:16.000276':::TIMESTAMP, '2001-01-01 00:00:00+00 BC':::TIMESTAMPTZ, '290 years':::INTERVAL, true, (-1):::DECIMAL, 'X':::STRING, '\x58':::BYTES, '6d2adb7e-b718-41ae-9389-7262b95e8eb0':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '1':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (32651:::INT8, (-2147483648):::INT8, 8337429032059312021:::INT8, 0.0:::FLOAT8, (-0.9284232234966427):::FLOAT8, '1991-04-02':::DATE, '1998-12-09 15:18:28.000508':::TIMESTAMP, '2028-04-11 03:48:35.000023+00':::TIMESTAMPTZ, '-16 years -9 mons -659 days -05:39:05.634493':::INTERVAL, false, (-3117.72713679932101):::DECIMAL, e'FG \x14Mi':::STRING, '\x':::BYTES, '82281c0a-f349-4b33-b742-3c1595a4ca45':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '{}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-1):::INT8, 1065483450:::INT8, 8157460318546155182:::INT8, (-0.5197738409042358):::FLOAT8, 1.824530909130916:::FLOAT8, '1983-10-17':::DATE, '2001-01-01 00:00:00 BC':::TIMESTAMP, '294276-12-31 23:59:59.999999+00':::TIMESTAMPTZ, '1 day':::INTERVAL, false, 7.690991291475525358E+26:::DECIMAL, e'V\'}3K':::STRING, '\x22':::BYTES, '29495ce3-335f-431b-8920-62978fcdc9e8':::UUID, '227.219.135.77/5':::INET, NULL);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (1:::INT8, 870433182:::INT8, 9223372036854775807:::INT8, (-1.1994972229003906):::FLOAT8, 'NaN':::FLOAT8, '1981-03-02':::DATE, '294276-12-31 23:59:59.999999':::TIMESTAMP, '2023-03-31 13:46:04.000569+00':::TIMESTAMPTZ, '39 years 5 mons 168 days 16:43:53.77988':::INTERVAL, false, 2932675590560.509984:::DECIMAL, e'y\x0byk{;\\Mg':::STRING, '\x':::BYTES, '1b9fdfbf-89da-47f2-90f6-d3a033df8fb9':::UUID, '121.35.7.216/17':::INET, '{"KCn0CatY": null}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (32767:::INT8, (-640045058):::INT8, (-6363828726280947754):::INT8, 3.4028234663852886e+38:::FLOAT8, 'NaN':::FLOAT8, '1970-01-01':::DATE, '1980-03-08 02:42:38.00057':::TIMESTAMP, '1995-07-26 09:42:04.000064+00':::TIMESTAMPTZ, '31 years 4 mons 574 days 08:41:34.5455':::INTERVAL, false, 1:::DECIMAL, e'\x1aX':::STRING, '\xe29883':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, '0.0.0.0/0':::INET, '{}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (23097:::INT8, 1512292463:::INT8, (-7121549057798779735):::INT8, (-2.497699737548828):::FLOAT8, 0.09740456739407555:::FLOAT8, '1982-08-01':::DATE, '0001-01-01 00:00:00':::TIMESTAMP, '1981-09-11 04:51:26.000169+00':::TIMESTAMPTZ, '00:00:00':::INTERVAL, false, 1:::DECIMAL, NULL, '\x':::BYTES, '1b4229db-c83c-4dec-89c1-7c84dd0df9fe':::UUID, '147.135.54.33/23':::INET, '{"JIcKaE": ["foo", false, 0.33671804521451], "Mv7GO": {"b": true, "c": 0.22353375878601633, "ylanLs": [false]}, "bar": null, "foo": [1.1075287076254474, {"baz": null}, null]}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-128):::INT8, (-1075935238):::INT8, NULL, (-0.7883026003837585):::FLOAT8, 0.5883539343455035:::FLOAT8, '1971-01-02':::DATE, '2000-08-19 09:37:36.000076':::TIMESTAMP, '4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ, '60 years 5 mons 566 days 06:06:38.323458':::INTERVAL, NULL, 5.802816123484960691E+27:::DECIMAL, e'\x00':::STRING, '\x22':::BYTES, 'db7fb82a-49eb-473f-8b6e-44fa746ec94b':::UUID, '0.0.0.0/0':::INET, '[[true, true], true, false, false]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-1):::INT8, (-173761664):::INT8, 4646313936932504092:::INT8, (-0.0):::FLOAT8, 1.401298464324817e-45:::FLOAT8, NULL, '2011-08-06 01:46:32.000067':::TIMESTAMP, '1987-06-08 06:00:53.000196+00':::TIMESTAMPTZ, '1 mon 1 day':::INTERVAL, false, (-66930.83416162256490):::DECIMAL, e'\x00':::STRING, '\x061d3fe3':::BYTES, 'b7e84d06-3ddd-4051-ac56-fc6804ef6f34':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '{"5118": [false, null], "Bwi0": null, "PJHz": 0.2723373315193681, "TCSS": "sNJe"}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (16842:::INT8, (-920024814):::INT8, 0:::INT8, NULL, (-0.1641669969990256):::FLOAT8, '1970-01-01':::DATE, '294276-12-31 23:59:59.999999':::TIMESTAMP, '4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ, '64 years 9 mons 964 days 14:32:10.091718':::INTERVAL, true, 'Infinity':::DECIMAL, '?':::STRING, '\xa647160f372e5bca':::BYTES, '4f8f81ee-58b4-4d1f-9015-eed22616cc48':::UUID, 'b29:759:1ced:b086:7658:d4c7:430:a1fd/65':::INET, '{"2hdIhttfr": true, "a": {"b": "0w9OXp"}, "b": ["PwRAN", null, false]}':::JSONB);
        DELETE FROM seed WHERE rowid NOT IN (SELECT rowid FROM seed ORDER BY rowid LIMIT 100);
        ALTER TABLE seed ADD COLUMN _enum greeting;
        UPDATE seed SET _enum = enum_range('hi'::greeting)[rowid%7];
    changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE NULL
    changefeed_test.go:1120: Skipping predicate NULL because it returned no rows
    changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE seed._bool
    changefeed_test.go:1124: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE seed._bool to emit 48 events
    changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE false
    changefeed_test.go:1120: Skipping predicate false because it returned no rows
    changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE true
    changefeed_test.go:1124: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE true to emit 100 events
    changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE ('e651:9e7e:b0b6:2118:5e1f:e75b:ff40:49ca/46':::INET::INET >> seed._inet::INET)::BOOL
    changefeed_test.go:1120: Skipping predicate ('e651:9e7e:b0b6:2118:5e1f:e75b:ff40:49ca/46':::INET::INET >> seed._inet::INET)::BOOL because it returned no rows
    changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (NOT true)
    changefeed_test.go:1120: Skipping predicate (NOT true) because it returned no rows
    changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE ((seed._inet::INET << 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET::INET)::BOOL AND (st_coveredby('0105000060E610000004000000010200004004000000046FD3FE59024640F8B06F1CCFD14F40C6A2C432FA0F00422083C2E0E4641E404629CFAB1A015440537923D7008302C29BC3AB7CF54952C0A80F370033DD4940E41E1293AA4602C2578B9CC2AB0152C038782EE6531F3340C8AB0FAAF563E241010200004003000000C81E8C7C00855B40C66F55B0943046C0C0E8DACA7AEFFF411C9BCD7A8DC15540383F708062C83FC0A4265BF3EE50E4415013FBACE6602BC0201C1C7B741455400012276377169141010200004002000000ECCFD0CEFB095840E0059BBF27633BC00850C02A2562D041BC8CB93B6C775E4098778DD893274340347805E9E87EF7C1010200004007000000F78EB4E035EE50C04C976995CB9735C0C0B7F3563454C6C19C70AC10060143C022F8E64CDA3652C034D1172B16C6ED4154EB150B8BFE5840D09F671E3BBA1C408017FC111973C1C1E89311D982FC3CC0A0952FB5DB9905408085A1A9AAC6FB410C12B22E4F944BC0F40E4D52DFD63040B00A40DF17F9E041986C45A5465F34C05C892BBB994C4E4016B045CA098EF5C126D548FBA8B54BC0F0296BF6D6BE344072420556270CFA41':::GEOGRAPHY::GEOGRAPHY, '0105000060E6100000020000000102000040030000000838F137853D3EC020B5F413975635C0344085D9E71602C264550929AF3E57C06CD50D948FD353C0EC20948299FBDEC1308078FCB6BC5C4060E7C114A93B0FC024423E22B707E8410102000040050000004CA9F1356ABA60408D94CFC81D3A4DC0010448E08E7BFBC1AA9A10E8AD1B6640087B5BED341A30C012FD36B48C57FBC14C4C191B41B45440E446D78FEBC43240DC1EF2437087FBC1B07AD27B43703E40984DDA30FC3832C038165AD8B9D8D7C190CC58BDDC465BC0ECF4AA846AF832C08A475FC988870242':::GEOGRAPHY::GEOGRAPHY)::BOOL AND (CASE WHEN seed._bool THEN '10:07:20.520754':::TIME ELSE '00:15:21.157657':::TIME END::TIME IN (SELECT '16:50:30.581912':::TIME::TIME AS col_128 FROM d.public.seed@[0] AS tab_39))))
    changefeed_test.go:1120: Skipping predicate ((seed._inet::INET << 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET::INET)::BOOL AND (st_coveredby('0105000060E610000004000000010200004004000000046FD3FE59024640F8B06F1CCFD14F40C6A2C432FA0F00422083C2E0E4641E404629CFAB1A015440537923D7008302C29BC3AB7CF54952C0A80F370033DD4940E41E1293AA4602C2578B9CC2AB0152C038782EE6531F3340C8AB0FAAF563E241010200004003000000C81E8C7C00855B40C66F55B0943046C0C0E8DACA7AEFFF411C9BCD7A8DC15540383F708062C83FC0A4265BF3EE50E4415013FBACE6602BC0201C1C7B741455400012276377169141010200004002000000ECCFD0CEFB095840E0059BBF27633BC00850C02A2562D041BC8CB93B6C775E4098778DD893274340347805E9E87EF7C1010200004007000000F78EB4E035EE50C04C976995CB9735C0C0B7F3563454C6C19C70AC10060143C022F8E64CDA3652C034D1172B16C6ED4154EB150B8BFE5840D09F671E3BBA1C408017FC111973C1C1E89311D982FC3CC0A0952FB5DB9905408085A1A9AAC6FB410C12B22E4F944BC0F40E4D52DFD63040B00A40DF17F9E041986C45A5465F34C05C892BBB994C4E4016B045CA098EF5C126D548FBA8B54BC0F0296BF6D6BE344072420556270CFA41':::GEOGRAPHY::GEOGRAPHY, '0105000060E6100000020000000102000040030000000838F137853D3EC020B5F413975635C0344085D9E71602C264550929AF3E57C06CD50D948FD353C0EC20948299FBDEC1308078FCB6BC5C4060E7C114A93B0FC024423E22B707E8410102000040050000004CA9F1356ABA60408D94CFC81D3A4DC0010448E08E7BFBC1AA9A10E8AD1B6640087B5BED341A30C012FD36B48C57FBC14C4C191B41B45440E446D78FEBC43240DC1EF2437087FBC1B07AD27B43703E40984DDA30FC3832C038165AD8B9D8D7C190CC58BDDC465BC0ECF4AA846AF832C08A475FC988870242':::GEOGRAPHY::GEOGRAPHY)::BOOL AND (CASE WHEN seed._bool THEN '10:07:20.520754':::TIME ELSE '00:15:21.157657':::TIME END::TIME IN (SELECT '16:50:30.581912':::TIME::TIME AS col_128 FROM d.public.seed@[0] AS tab_39)))) because it returned no rows
    changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT CASE WHEN true THEN NULL ELSE '':::VOID END AS "\\u9D5Dcol_139" FROM d.public.seed AS tab_43 JOIN d.public.seed AS "\\u869Dtab_44" ON (tab_43._int8) = ("\\u869Dtab_44"._int8) WHERE ((inet(NULL::INET)::INET::INET & '62c9:b804:3931:a221:db31:f50f:4fe2:8566/35':::INET::INET)::INET::INET << NULL::INET)::BOOL)
    changefeed_test.go:1120: Skipping predicate EXISTS (SELECT CASE WHEN true THEN NULL ELSE '':::VOID END AS "\\u9D5Dcol_139" FROM d.public.seed AS tab_43 JOIN d.public.seed AS "\\u869Dtab_44" ON (tab_43._int8) = ("\\u869Dtab_44"._int8) WHERE ((inet(NULL::INET)::INET::INET & '62c9:b804:3931:a221:db31:f50f:4fe2:8566/35':::INET::INET)::INET::INET << NULL::INET)::BOOL) because it returned no rows
    changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (NOT false)
    changefeed_test.go:1124: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (NOT false) to emit 100 events
    changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (true OR ('Na<JM':::STRING::STRING NOT IN (SELECT NULL::STRING AS col_160)))
    changefeed_test.go:1124: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (true OR ('Na<JM':::STRING::STRING NOT IN (SELECT NULL::STRING AS col_160))) to emit 100 events
    changefeed_test.go:1127: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC
    changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._bool AND ((seed._bool AND true) OR _st_dwithinexclusive('010200000000000000':::GEOMETRY::GEOMETRY, '0107000000080000000106000000050000000103000000010000000A000000193F725B551EF5C13CD0C105EA93DCC1B05C63410BF8E1410A2D97E220BC01C2208056BB1C1CEE4160CE57E8DFE601C2A4E56B437AF3FA4147776289DDB8FEC1E46241912B52E141BE95C129CB6BEAC15CCD01A00341EB419259A494EC25F8411E9CFC3098F6FBC1FABD37382C17F441EC82BD218A16FEC12AFF6A38A275F4419B8F3B96D02C01C25AA6B9417518F441193F725B551EF5C13CD0C105EA93DCC10103000000010000000C000000AB12C2D2877FFEC17CA44D53D3A8D5C1D17105624CCEF3C1C082C245DC22E9C19601C1BAD0E6F7418838D9365B2B01C22846BD63AF0EFD416857E88BBB6BE64156321D7E72A8F6417A2017F49B52F9415C4449FAF556E2C11478EBC5784E01423611E0883D82E8C10CBE1344691DF341A1C51D62A2EAF1C1107F44FD0DC6FA41FBE4D1AE6A1EF5C120F457B9F024F841125E335D4A0400C2E8C329BBB905FF41F7BECF6FC056F2C1A851C3661512EF41AB12C2D2877FFEC17CA44D53D3A8D5C10103000000010000000B0000005CE5E1DF1564D8C1E1C1A116BDC1FDC1C4DD530E6CE5D8C16DF63DCBBCD301C2FAF71CF7595D02423370DA3CD18802C228B6D6F3927B0042189E61226F62ECC1FCE1C34BDE70004290DE309B1528CCC12AA9009C2157F34124FC2EB06F97FB41FEABF3D06914F041D04511033FBCF941286E84E8978CD8419854D305EC3FFB41F159C76D926B00C26882F43770B7FF41F79561FEC76B00C268984DEBEE16E0415CE5E1DF1564D8C1E1C1A116BDC1FDC10103000000010000000D000000AA08781C42AB00C212344B0D82C6F7C1185134BCF50CE5C120DBB1502421E7C156263DCD961EE5C13ACD297BE2C0FCC1A05128FC08FBD5419CB8A8B0F07E02C2B4015EE7CE4CE4415F921A82E9E300C254ADED1FEC4AFC41E08E6BF07CC2CB4144D6ABE2A79100422430668A314AE441F040A86DFAD4E24158D8B123DB3EDE416A699A675CB1F2411EC7263EE4E1014220938860714ED841F0BB300EB9DFE2418C3DFFD9892BE04190B8371F12DBF441310FCA7D370000C202A579443EA0F941AA08781C42AB00C212344B0D82C6F7C10103000000010000000500000084760DFF822BFCC14454DC5521E2D5C1706C25DC26DAD0C13B0190FDD29101C2A8FB5B015D81F4414896D911FC1EDF413818D8623DA7F2416060FDEF30C1014284760DFF822BFCC14454DC5521E2D5C101060000000900000001030000000100000007000000E4459526509AF341A1A133CF0883F7C168932C599E9DE5416005982CCAF7DB41E48C6D16792BF0415477BE5CE821E941A486623FC983E741A8ED9FA69E0AEC41F0F60ABF38C0E2414A7D01EF1064F941C089B74BABF5EBC1DAF7D90E41C7F241E4459526509AF341A1A133CF0883F7C101030000000100000009000000D2388784CE79F4C16885CFE58D97EBC1641FE6097E3CE9C1F824DE4C4F65DA419E4311E87CE4E4C196A415335389F0C10673CAD19707F341985107BE84D5DDC1BC2255E65D49E041386FF11F9F2302425AF38D7C3D28EBC1DEC4F5821F8002429E1A8F3BDCA6F9C1FE0A9EB1DF790042E8F28D70BEF500C22E27353D78B4F441D2388784CE79F4C16885CFE58D97EBC101030000000100000008000000A2BFD0ACFECDFCC100901072719F95412847D75A0162D2C10063FF4DBC38F8C1D649F36A01C5F241780758914EA1D8C1BC96F4227597FB412CABA0ACEE2DE941F009FC8142DBCB41F85F625E86FEF041C01D0E7A16ADC2C100424C5AC46DE74186C82717C45CE7C1345C4CF84D6FE341A2BFD0ACFECDFCC100901072719F95410103000000010000000500000030DAB92137CCDB41FC4272C4ABD5EDC1E4E4DDBD6B3EF241EE3B7A2D14DCE5C14E076CC4E76201427E6036454D1EF7417E55F8CFC5C70042A6FBE29177E8014230DAB92137CCDB41FC4272C4ABD5EDC10103000000010000000A00000050CC6246E993F4C14C400782B0F9F7C1D41905927829E2C1B25115F359AB01C2B02D057E76AEF541EA464A9BB0E8EDC14AB424DA67F00042C26301CBE65BF641A4A469B9A813FC41F2997AFE8961FA4128349F8B8C83D941005C928BC0A1DE41B0B88F1BB800D8412ED79682473DF44164EE80DB8BB601C294A2A5DBE6CBE74172D02C4532C4EBC1A0E97FDC4B2DBE4150CC6246E993F4C14C400782B0F9F7C1010300000001000000040000004476EE4F44F5FE4123508211688CF5C1B240DE2241C2E1C186BFAF95CAD8F6419A637A84DAD3F1C10C01824F0586FE414476EE4F44F5FE4123508211688CF5C101030000000100000005000000C6FCD4FBAC4CF34170FB1CD05612C241642D5FD37429F141AC39413E94A5F24100B69D40B63AD341686AA7631617FE4160899675FD4EEBC12CB6640DD140FC41C6FCD4FBAC4CF34170FB1CD05612C241010300000001000000060000001EBA6333063701C29110A3D417CA01C22E151FEBF84EF941825879D21BCAF9C1749E704B1660F44132C135BFFECAF6C1009A348B42E5D2C1B664AC4FC96FF44148EA64EE8D6DFAC1C895C79A5529E0C11EBA6333063701C29110A3D417CA01C20103000000010000000B0000001158CCE43E07F3C182AE3E874ED0F6C160CACB66FF64BD4149219574CA6E01C2480E33E14B80DD41CB04EA460DBF00C2C4A30F0980FCF3413A24F0FA2F2000C292EC7FB87C38004224E10582AB0CE54182A9A0F07759F8418C7100B9D223FE4120008CA9688FBC41C0CF17BF14A9F54100706A13AD3474C130D8D4FB1683C241E8C309C0A637F1C15461F6D4B0FBF44130F6B6E1DCD1CEC18037A03AB0399F411158CCE43E07F3C182AE3E874ED0F6C101040000000600000001010000005D81B120E512F0C12C7410297304F041010100000080C448EF9E28B441A22129D6718100C20101000000C02C49F08633A541EDC54FF21BC7F8C1010100000020D1556414C8F04138F6F9538214E64101010000008BA97978A181F8C1C890CEDACF38DE410101000000B4455ECE54A8F7C1CC4E2071AA7EE8C10106000000030000000103000000010000000B000000954AE3D77B52FDC130B9CAF623A2C0C1EEDAF294E78EFCC1F98A594F555B00C2D6CB58CF6E3FEBC16A31259FA9C801C2E05ACB412CAEEE4100CCAEB3CDACCD410C0A85852026FD4198CB5F061278EB41B86615AFBD9AFD419A3CB712BFAEF4413CE78FE2D4EFFF4128A35A9B913FF741009EB76E02307CC14866B91CACECE441302CE753640EC9C118806289C13DE541F84AB11544E1F5C10882E20AE9B2E841954AE3D77B52FDC130B9CAF623A2C0C10103000000010000000C000000BA62B588CCEBFCC17B1D18A5BC22F5C1413AC7515302F4C175B81F6346E8FDC16720EE84480CF1C1D175DD3C74E600C24467FA2EEC2CE5C12408CFB5AA39E9C19E599D005BFEE2C1004DBEDF5A5B8941D8B0060D7E10F441DC783415DF73D5C19C0DA985F53DFD41D834ADEB6FCFF841967AFAF7976AE2C1B84A736E4E5401427A7B43624989E5C160489B9F605FE94101E3BC8353C900C24C61F5C5E8B6FE412296AF668702FFC19484DFE82623F841BA62B588CCEBFCC17B1D18A5BC22F5C10103000000010000000D0000005BFF876E879BFDC184B30174AB8FE1C1526C17341A4102C21DE008191F6BF8C11A299B4FC33DF7C1E094EADF5A51FEC19CECCE3FD049F64128245E943E5EF5C1781C41A74BDBFE41B01C9CC43E78EAC15E53A5144D75F941509DFAA3F7C2E7410C8F7FA1688CF541D8B4B1329356EE4160B3088DC61AFF41B01206794A05F84134225F44A277EF41DECDFB42245C0142B0EA22B0413EE041C01271F70EADF44160E4B7445060D141A0759DBFFED2DE41A8BDB30EBB28FFC1A09E86EAA078DF415BFF876E879BFDC184B30174AB8FE1C101010000001EA7FCABD9640142635E45EAC08502C201060000000700000001030000000100000006000000CA5F05DF79A4E4C16E805E45CE21FFC1124B6DCA48BEF3410897C07551F7E5C108478B9E5736F441203CC7B24AA0D34156A446A65F68F141126B088C9979F6417AC06AA05B34F1C14C820704A6AAEA41CA5F05DF79A4E4C16E805E45CE21FFC10103000000010000000D0000002AF8A4054169EFC104219A0F87B2F9C168E6731C5F13E3C155000D927B7D02C240DCD62CF7B3CC415AEF001FFB23E8C1B80CB80EDFE5F74157F04E591065F7C11C057BA0A414FD415070BC0D8086C0C14CB3660FEC7401422CEDBF17A98FFF41345DB5B02056EE414C4270671F71FA41A64C7BE7071EF14136F117D1BE120242606324CD1CD5B1414806F5758F23F7410096D70068BEC6C1D4E52661F6AFEA417218A9EB32A601C2084E8E8993EEFF410C2CD6A00C37FCC1F4B8AE5991D3F1412AF8A4054169EFC104219A0F87B2F9C101030000000100000006000000CA70143B86E6EEC14C433D29241FF2C1DC3C969328BDFF415A3922087011FFC1A82842625365D9C1007EB832CCA3E74182C1E23A7489F8C1247FDD443D3FFD4172F49FB80A24E9C134595B958AF2E341CA70143B86E6EEC14C433D29241FF2C10103000000010000000600000070D141466612FDC17A39B423A956F1C177B777DDA506F0C1ECBD5DB45DE0E6C112821D3D5F86F941C4719716F79DE441B0982D8F68ECC6C13A2E838B8792F641ECC7F0A89A50F0C19203B6A5D570024270D141466612FDC17A39B423A956F1C10103000000010000000C0000009B38AC335D70FAC1008C2EF7ED72BAC120B69C7CF10701C28C54354F7412E3C160EECF39EF01BFC19047D4CB2A43C0C1EAC66B90B922F3411C836D59C0C7DCC1802ADC9185D8EA41105CFA059699C241E4C3BEADF86E0242B0CE4F96C8D6C8C19CD8C6B60299FC41F4CECA35497DFD41A0F43BFC73C0B9C1E46B1F779FC6F241B0749FE7B7D0D9C1441EE63759F1F941A1A31B0AA4ECF3C1A21391A0C97FF4414064415B77ABFCC1AC9959A3797AE6419B38AC335D70FAC1008C2EF7ED72BAC101030000000100000009000000042E9EE36BDDF9C160625E101B85D7C1403BC92C1A59BF41209329503FE9CC41F24C2E1B2D38FA41C3DB37483EA5F8C15EA61D286E1BF641F4154368F109E241F6B5ABEFEBE9F841D0F0B941BB97FB41BE3F38557862F841AC6210FE1F71FD41A0C7F9D611A6D441922B150A349202422575DBE0234B01C24A8765B07A18F041042E9EE36BDDF9C160625E101B85D7C10103000000010000000A000000208EDFE81E52C6C1DA520337C196FCC1B0DF996D1FD6D341341A8F93F572EEC1446B1F0F51FEED41906318327680FCC12CD8CFDB06A4F041918673A29BB5F7C132F0228DC42FF541AC606E2E0DCCF5C1786273CB9C09D34170F4613FE9CAC5C160386B5D2571CAC18819CB0B9E9DE9415B4A99FB2463F2C190B2244A355FF341EAA66F5879A4E1C1C80415000207DCC1208EDFE81E52C6C1DA520337C196FCC10106000000050000000103000000010000000B000000CCB1FFA1B54AF2C1ECDAC956F75AE7C174B002BF08ACE6C12F7C320F3CAC01C2007C61640B8E66413061C311FC4EE2C11C226176BB0AF24180A2AD1A00CD91C13809FB279042E341907E8ED8354CE641006475822DF7AE41F0A1A149E819E94108105D961D48ECC1545DB7803F3BF041F43BAF70A0BAE5C11C7771E6DCA3E141B4F6F96A1588FBC1C0E30907F82EF4418007284F27A9EAC1889CEC1869CADB41CCB1FFA1B54AF2C1ECDAC956F75AE7C101030000000100000004000000F825CDCC150BFCC1DE26CB66FCC6EFC1B0A13165A416C44194F5A5A87559F9C1E858904C4144D8C12059132D24F4CA41F825CDCC150BFCC1DE26CB66FCC6EFC1010300000001000000070000006A6A4F50FBCBE7C187F3BD873D4F00C27805B41A0665DD41F813CF63ED92DCC1AA941B137847F94154B27B138F89024220D1112F854FB1C1500ECEAE738CEE41C0CB0559F16CB2C13A42F17AFFCCF341F2FA4F5FD132FDC1804A62895FA1EE416A6A4F50FBCBE7C187F3BD873D4F00C20103000000010000000B000000C2EB198012A4FCC1B208C762D561E0C1571559F2029501C25EBB1606DC9902C2C0E9E8E6856BF4C1D848B015EFEC01C218F035396A59E2C18A7878151F2CF4C1ECFF31E32C2AE9418640D78BC2ACFAC1B86CD2B83668EC4100AE272D4E217A41F8EE19C44681E4417C106C94E163ED410E3D9CF5025BF541801C4E631FE2FF4124B5ED8C18B3EFC1B6D2105DA156FA415462817436B5FCC1C8F6CBCB11D4EE41C2EB198012A4FCC1B208C762D561E0C10103000000010000000B0000002255BFB82612FBC1208B2F1E10A3D941137B799929EBF4C1E0C7024DE511E7C1885825031082F1C1634BD5EA8F7D01C28A484948A324E5C1AC0822C359C9F0C18C598F75C7F9FD4120936DF0C8B7B541A861E53C619AD84178C49469C917F141F859B9E7872EEAC12029B87C186E014214C243BE4E98F1C1B41FF380EE5A0142BD964F14D01300C2A8EA36B38A1602421E0D16DA93BF00C2C8AB5D668198F0412255BFB82612FBC1208B2F1E10A3D9410103000000010000000900000040771BCFF70FC341FE93DFA204B4FCC11C2B64C8AC58EE41F85996E1CE99F5C1DA0B7AD2AE960242B82DE803310EE9C18CAF9992AF75FD4140F1038004EAAE41E485B535A9EEF541BC7E1D2ED90802420086334B19D58D41D8F121D736E30042D8141BADE0FADA41E08F2B2B4809EA414035185C9ECFC94108B581514AB9E04140771BCFF70FC341FE93DFA204B4FCC1':::GEOMETRY::GEOMETRY, seed._float8::FLOAT8)::BOOL))
    changefeed_test.go:1124: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (seed._bool AND ((seed._bool AND true) OR _st_dwithinexclusive('010200000000000000':::GEOMETRY::GEOMETRY, '0107000000080000000106000000050000000103000000010000000A000000193F725B551EF5C13CD0C105EA93DCC1B05C63410BF8E1410A2D97E220BC01C2208056BB1C1CEE4160CE57E8DFE601C2A4E56B437AF3FA4147776289DDB8FEC1E46241912B52E141BE95C129CB6BEAC15CCD01A00341EB419259A494EC25F8411E9CFC3098F6FBC1FABD37382C17F441EC82BD218A16FEC12AFF6A38A275F4419B8F3B96D02C01C25AA6B9417518F441193F725B551EF5C13CD0C105EA93DCC10103000000010000000C000000AB12C2D2877FFEC17CA44D53D3A8D5C1D17105624CCEF3C1C082C245DC22E9C19601C1BAD0E6F7418838D9365B2B01C22846BD63AF0EFD416857E88BBB6BE64156321D7E72A8F6417A2017F49B52F9415C4449FAF556E2C11478EBC5784E01423611E0883D82E8C10CBE1344691DF341A1C51D62A2EAF1C1107F44FD0DC6FA41FBE4D1AE6A1EF5C120F457B9F024F841125E335D4A0400C2E8C329BBB905FF41F7BECF6FC056F2C1A851C3661512EF41AB12C2D2877FFEC17CA44D53D3A8D5C10103000000010000000B0000005CE5E1DF1564D8C1E1C1A116BDC1FDC1C4DD530E6CE5D8C16DF63DCBBCD301C2FAF71CF7595D02423370DA3CD18802C228B6D6F3927B0042189E61226F62ECC1FCE1C34BDE70004290DE309B1528CCC12AA9009C2157F34124FC2EB06F97FB41FEABF3D06914F041D04511033FBCF941286E84E8978CD8419854D305EC3FFB41F159C76D926B00C26882F43770B7FF41F79561FEC76B00C268984DEBEE16E0415CE5E1DF1564D8C1E1C1A116BDC1FDC10103000000010000000D000000AA08781C42AB00C212344B0D82C6F7C1185134BCF50CE5C120DBB1502421E7C156263DCD961EE5C13ACD297BE2C0FCC1A05128FC08FBD5419CB8A8B0F07E02C2B4015EE7CE4CE4415F921A82E9E300C254ADED1FEC4AFC41E08E6BF07CC2CB4144D6ABE2A79100422430668A314AE441F040A86DFAD4E24158D8B123DB3EDE416A699A675CB1F2411EC7263EE4E1014220938860714ED841F0BB300EB9DFE2418C3DFFD9892BE04190B8371F12DBF441310FCA7D370000C202A579443EA0F941AA08781C42AB00C212344B0D82C6F7C10103000000010000000500000084760DFF822BFCC14454DC5521E2D5C1706C25DC26DAD0C13B0190FDD29101C2A8FB5B015D81F4414896D911FC1EDF413818D8623DA7F2416060FDEF30C1014284760DFF822BFCC14454DC5521E2D5C101060000000900000001030000000100000007000000E4459526509AF341A1A133CF0883F7C168932C599E9DE5416005982CCAF7DB41E48C6D16792BF0415477BE5CE821E941A486623FC983E741A8ED9FA69E0AEC41F0F60ABF38C0E2414A7D01EF1064F941C089B74BABF5EBC1DAF7D90E41C7F241E4459526509AF341A1A133CF0883F7C101030000000100000009000000D2388784CE79F4C16885CFE58D97EBC1641FE6097E3CE9C1F824DE4C4F65DA419E4311E87CE4E4C196A415335389F0C10673CAD19707F341985107BE84D5DDC1BC2255E65D49E041386FF11F9F2302425AF38D7C3D28EBC1DEC4F5821F8002429E1A8F3BDCA6F9C1FE0A9EB1DF790042E8F28D70BEF500C22E27353D78B4F441D2388784CE79F4C16885CFE58D97EBC101030000000100000008000000A2BFD0ACFECDFCC100901072719F95412847D75A0162D2C10063FF4DBC38F8C1D649F36A01C5F241780758914EA1D8C1BC96F4227597FB412CABA0ACEE2DE941F009FC8142DBCB41F85F625E86FEF041C01D0E7A16ADC2C100424C5AC46DE74186C82717C45CE7C1345C4CF84D6FE341A2BFD0ACFECDFCC100901072719F95410103000000010000000500000030DAB92137CCDB41FC4272C4ABD5EDC1E4E4DDBD6B3EF241EE3B7A2D14DCE5C14E076CC4E76201427E6036454D1EF7417E55F8CFC5C70042A6FBE29177E8014230DAB92137CCDB41FC4272C4ABD5EDC10103000000010000000A00000050CC6246E993F4C14C400782B0F9F7C1D41905927829E2C1B25115F359AB01C2B02D057E76AEF541EA464A9BB0E8EDC14AB424DA67F00042C26301CBE65BF641A4A469B9A813FC41F2997AFE8961FA4128349F8B8C83D941005C928BC0A1DE41B0B88F1BB800D8412ED79682473DF44164EE80DB8BB601C294A2A5DBE6CBE74172D02C4532C4EBC1A0E97FDC4B2DBE4150CC6246E993F4C14C400782B0F9F7C1010300000001000000040000004476EE4F44F5FE4123508211688CF5C1B240DE2241C2E1C186BFAF95CAD8F6419A637A84DAD3F1C10C01824F0586FE414476EE4F44F5FE4123508211688CF5C101030000000100000005000000C6FCD4FBAC4CF34170FB1CD05612C241642D5FD37429F141AC39413E94A5F24100B69D40B63AD341686AA7631617FE4160899675FD4EEBC12CB6640DD140FC41C6FCD4FBAC4CF34170FB1CD05612C241010300000001000000060000001EBA6333063701C29110A3D417CA01C22E151FEBF84EF941825879D21BCAF9C1749E704B1660F44132C135BFFECAF6C1009A348B42E5D2C1B664AC4FC96FF44148EA64EE8D6DFAC1C895C79A5529E0C11EBA6333063701C29110A3D417CA01C20103000000010000000B0000001158CCE43E07F3C182AE3E874ED0F6C160CACB66FF64BD4149219574CA6E01C2480E33E14B80DD41CB04EA460DBF00C2C4A30F0980FCF3413A24F0FA2F2000C292EC7FB87C38004224E10582AB0CE54182A9A0F07759F8418C7100B9D223FE4120008CA9688FBC41C0CF17BF14A9F54100706A13AD3474C130D8D4FB1683C241E8C309C0A637F1C15461F6D4B0FBF44130F6B6E1DCD1CEC18037A03AB0399F411158CCE43E07F3C182AE3E874ED0F6C101040000000600000001010000005D81B120E512F0C12C7410297304F041010100000080C448EF9E28B441A22129D6718100C20101000000C02C49F08633A541EDC54FF21BC7F8C1010100000020D1556414C8F04138F6F9538214E64101010000008BA97978A181F8C1C890CEDACF38DE410101000000B4455ECE54A8F7C1CC4E2071AA7EE8C10106000000030000000103000000010000000B000000954AE3D77B52FDC130B9CAF623A2C0C1EEDAF294E78EFCC1F98A594F555B00C2D6CB58CF6E3FEBC16A31259FA9C801C2E05ACB412CAEEE4100CCAEB3CDACCD410C0A85852026FD4198CB5F061278EB41B86615AFBD9AFD419A3CB712BFAEF4413CE78FE2D4EFFF4128A35A9B913FF741009EB76E02307CC14866B91CACECE441302CE753640EC9C118806289C13DE541F84AB11544E1F5C10882E20AE9B2E841954AE3D77B52FDC130B9CAF623A2C0C10103000000010000000C000000BA62B588CCEBFCC17B1D18A5BC22F5C1413AC7515302F4C175B81F6346E8FDC16720EE84480CF1C1D175DD3C74E600C24467FA2EEC2CE5C12408CFB5AA39E9C19E599D005BFEE2C1004DBEDF5A5B8941D8B0060D7E10F441DC783415DF73D5C19C0DA985F53DFD41D834ADEB6FCFF841967AFAF7976AE2C1B84A736E4E5401427A7B43624989E5C160489B9F605FE94101E3BC8353C900C24C61F5C5E8B6FE412296AF668702FFC19484DFE82623F841BA62B588CCEBFCC17B1D18A5BC22F5C10103000000010000000D0000005BFF876E879BFDC184B30174AB8FE1C1526C17341A4102C21DE008191F6BF8C11A299B4FC33DF7C1E094EADF5A51FEC19CECCE3FD049F64128245E943E5EF5C1781C41A74BDBFE41B01C9CC43E78EAC15E53A5144D75F941509DFAA3F7C2E7410C8F7FA1688CF541D8B4B1329356EE4160B3088DC61AFF41B01206794A05F84134225F44A277EF41DECDFB42245C0142B0EA22B0413EE041C01271F70EADF44160E4B7445060D141A0759DBFFED2DE41A8BDB30EBB28FFC1A09E86EAA078DF415BFF876E879BFDC184B30174AB8FE1C101010000001EA7FCABD9640142635E45EAC08502C201060000000700000001030000000100000006000000CA5F05DF79A4E4C16E805E45CE21FFC1124B6DCA48BEF3410897C07551F7E5C108478B9E5736F441203CC7B24AA0D34156A446A65F68F141126B088C9979F6417AC06AA05B34F1C14C820704A6AAEA41CA5F05DF79A4E4C16E805E45CE21FFC10103000000010000000D0000002AF8A4054169EFC104219A0F87B2F9C168E6731C5F13E3C155000D927B7D02C240DCD62CF7B3CC415AEF001FFB23E8C1B80CB80EDFE5F74157F04E591065F7C11C057BA0A414FD415070BC0D8086C0C14CB3660FEC7401422CEDBF17A98FFF41345DB5B02056EE414C4270671F71FA41A64C7BE7071EF14136F117D1BE120242606324CD1CD5B1414806F5758F23F7410096D70068BEC6C1D4E52661F6AFEA417218A9EB32A601C2084E8E8993EEFF410C2CD6A00C37FCC1F4B8AE5991D3F1412AF8A4054169EFC104219A0F87B2F9C101030000000100000006000000CA70143B86E6EEC14C433D29241FF2C1DC3C969328BDFF415A3922087011FFC1A82842625365D9C1007EB832CCA3E74182C1E23A7489F8C1247FDD443D3FFD4172F49FB80A24E9C134595B958AF2E341CA70143B86E6EEC14C433D29241FF2C10103000000010000000600000070D141466612FDC17A39B423A956F1C177B777DDA506F0C1ECBD5DB45DE0E6C112821D3D5F86F941C4719716F79DE441B0982D8F68ECC6C13A2E838B8792F641ECC7F0A89A50F0C19203B6A5D570024270D141466612FDC17A39B423A956F1C10103000000010000000C0000009B38AC335D70FAC1008C2EF7ED72BAC120B69C7CF10701C28C54354F7412E3C160EECF39EF01BFC19047D4CB2A43C0C1EAC66B90B922F3411C836D59C0C7DCC1802ADC9185D8EA41105CFA059699C241E4C3BEADF86E0242B0CE4F96C8D6C8C19CD8C6B60299FC41F4CECA35497DFD41A0F43BFC73C0B9C1E46B1F779FC6F241B0749FE7B7D0D9C1441EE63759F1F941A1A31B0AA4ECF3C1A21391A0C97FF4414064415B77ABFCC1AC9959A3797AE6419B38AC335D70FAC1008C2EF7ED72BAC101030000000100000009000000042E9EE36BDDF9C160625E101B85D7C1403BC92C1A59BF41209329503FE9CC41F24C2E1B2D38FA41C3DB37483EA5F8C15EA61D286E1BF641F4154368F109E241F6B5ABEFEBE9F841D0F0B941BB97FB41BE3F38557862F841AC6210FE1F71FD41A0C7F9D611A6D441922B150A349202422575DBE0234B01C24A8765B07A18F041042E9EE36BDDF9C160625E101B85D7C10103000000010000000A000000208EDFE81E52C6C1DA520337C196FCC1B0DF996D1FD6D341341A8F93F572EEC1446B1F0F51FEED41906318327680FCC12CD8CFDB06A4F041918673A29BB5F7C132F0228DC42FF541AC606E2E0DCCF5C1786273CB9C09D34170F4613FE9CAC5C160386B5D2571CAC18819CB0B9E9DE9415B4A99FB2463F2C190B2244A355FF341EAA66F5879A4E1C1C80415000207DCC1208EDFE81E52C6C1DA520337C196FCC10106000000050000000103000000010000000B000000CCB1FFA1B54AF2C1ECDAC956F75AE7C174B002BF08ACE6C12F7C320F3CAC01C2007C61640B8E66413061C311FC4EE2C11C226176BB0AF24180A2AD1A00CD91C13809FB279042E341907E8ED8354CE641006475822DF7AE41F0A1A149E819E94108105D961D48ECC1545DB7803F3BF041F43BAF70A0BAE5C11C7771E6DCA3E141B4F6F96A1588FBC1C0E30907F82EF4418007284F27A9EAC1889CEC1869CADB41CCB1FFA1B54AF2C1ECDAC956F75AE7C101030000000100000004000000F825CDCC150BFCC1DE26CB66FCC6EFC1B0A13165A416C44194F5A5A87559F9C1E858904C4144D8C12059132D24F4CA41F825CDCC150BFCC1DE26CB66FCC6EFC1010300000001000000070000006A6A4F50FBCBE7C187F3BD873D4F00C27805B41A0665DD41F813CF63ED92DCC1AA941B137847F94154B27B138F89024220D1112F854FB1C1500ECEAE738CEE41C0CB0559F16CB2C13A42F17AFFCCF341F2FA4F5FD132FDC1804A62895FA1EE416A6A4F50FBCBE7C187F3BD873D4F00C20103000000010000000B000000C2EB198012A4FCC1B208C762D561E0C1571559F2029501C25EBB1606DC9902C2C0E9E8E6856BF4C1D848B015EFEC01C218F035396A59E2C18A7878151F2CF4C1ECFF31E32C2AE9418640D78BC2ACFAC1B86CD2B83668EC4100AE272D4E217A41F8EE19C44681E4417C106C94E163ED410E3D9CF5025BF541801C4E631FE2FF4124B5ED8C18B3EFC1B6D2105DA156FA415462817436B5FCC1C8F6CBCB11D4EE41C2EB198012A4FCC1B208C762D561E0C10103000000010000000B0000002255BFB82612FBC1208B2F1E10A3D941137B799929EBF4C1E0C7024DE511E7C1885825031082F1C1634BD5EA8F7D01C28A484948A324E5C1AC0822C359C9F0C18C598F75C7F9FD4120936DF0C8B7B541A861E53C619AD84178C49469C917F141F859B9E7872EEAC12029B87C186E014214C243BE4E98F1C1B41FF380EE5A0142BD964F14D01300C2A8EA36B38A1602421E0D16DA93BF00C2C8AB5D668198F0412255BFB82612FBC1208B2F1E10A3D9410103000000010000000900000040771BCFF70FC341FE93DFA204B4FCC11C2B64C8AC58EE41F85996E1CE99F5C1DA0B7AD2AE960242B82DE803310EE9C18CAF9992AF75FD4140F1038004EAAE41E485B535A9EEF541BC7E1D2ED90802420086334B19D58D41D8F121D736E30042D8141BADE0FADA41E08F2B2B4809EA414035185C9ECFC94108B581514AB9E04140771BCFF70FC341FE93DFA204B4FCC1':::GEOMETRY::GEOMETRY, seed._float8::FLOAT8)::BOOL)) to emit 48 events
    changefeed_test.go:1141: _st_dwithinexclusive(): dwithin distance cannot be less than zero
    --- FAIL: TestChangefeedRandomExpressions/kafka (4.45s)

Parameters:

See also: How To Investigate a Go Test Failure (internal)

Same failure on other branches

- #120174 ccl/changefeedccl: TestChangefeedRandomExpressions failed [test needs adjustment] [A-cdc C-test-failure O-robot P-3 T-cdc branch-master] - #117050 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-23.2]

/cc @cockroachdb/cdc

This test on roachdash | Improve this report!

Jira issue: CRDB-37928

rharding6373 commented 5 months ago

The WHERE clause (seed._bool AND ((seed._bool AND true) OR _st_dwithinexclusive(... forms a tautology that optimizes away the invalid geo builtin call away in the SQL query but not the CDC query. Another case of the test needing adjustment to handle SQL errors.

Dupe of #120174