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 #123614

Closed cockroach-teamcity closed 5 months ago

cockroach-teamcity commented 5 months ago

ccl/changefeedccl.TestChangefeedRandomExpressions failed on release-24.1.0-rc @ 34bbed697e77466f52012a80f0f6ae496c0d2889:

        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (12171:::INT8, (-128):::INT8, 0:::INT8, (-0.029541239142417908):::FLOAT8, (-1.0201609017402125):::FLOAT8, '1984-07-26':::DATE, '4714-11-24 00:00:00 BC':::TIMESTAMP, '2009-10-13 06:42:45.000969+00':::TIMESTAMPTZ, '77 years 1 mon 905 days 02:51:46.700591':::INTERVAL, true, (-1.234E+401):::DECIMAL, e'rk\x10\x11o\x17':::STRING, '\x3bed':::BYTES, '00000000-0000-0000-0000-000000000000':::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 (NULL, 127:::INT8, (-128):::INT8, NULL, 1.7976931348623157e+308:::FLOAT8, '1981-02-10':::DATE, '2021-05-06 16:18:14.000609':::TIMESTAMP, '1971-11-13 04:08:23.000888+00':::TIMESTAMPTZ, '1 mon 1 day':::INTERVAL, false, '-Infinity':::DECIMAL, NULL, '\x':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '{"test": "json"}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (15872:::INT8, (-1):::INT8, 0:::INT8, NULL, 3.4028234663852886e+38:::FLOAT8, '-infinity':::DATE, '1990-04-27 01:20:27.000591':::TIMESTAMP, '1988-03-01 04:23:49.000117+00':::TIMESTAMPTZ, '71 years 372 days 04:48:38.840358':::INTERVAL, false, 0:::DECIMAL, e'\'':::STRING, NULL, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, '2c9:bdb1:4768:541b:79c5:ae42:15a8:1685/116':::INET, '{}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-1):::INT8, (-1002425759):::INT8, 1470007056992854662:::INT8, '+Inf':::FLOAT8, 1.7976931348623157e+308:::FLOAT8, '1970-01-01':::DATE, '2028-04-10 11:05:53.000527':::TIMESTAMP, '1996-03-20 22:15:06.000063+00':::TIMESTAMPTZ, '290 years':::INTERVAL, NULL, (-7.168118281408450433E+19):::DECIMAL, e'\x00':::STRING, '\x86320283':::BYTES, NULL, '129.106.147.58/2':::INET, '{"Ox9rfPV": "hx8WnWm", "baz": false, "c": {"3qzujn4v": true, "PnpIfEVaR": false, "foo": {"baz": {"oY": null}, "uqPP": 0.005620758314014075, "vVgI": null}, "u9N": 1.703736365008971}, "foo": [[[[false], false, false], "a", false], "c", "b", {"d4gDS7": "lj7sAu"}, false, null], "foobar": {"0FzHyWrz": true, "bar": null, "fADo2H": false}}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-32768):::INT8, 639331370:::INT8, (-5228726404394830500):::INT8, 3.4028234663852886e+38:::FLOAT8, (-0.4271486861178335):::FLOAT8, '5874897-12-31':::DATE, '2001-01-01 00:00:00 BC':::TIMESTAMP, '2004-05-30 04:53:49.00075+00':::TIMESTAMPTZ, '-5 years -5 mons -22 days -14:45:10.998003':::INTERVAL, true, (-1.234E+401):::DECIMAL, '#7':::STRING, '\x538eace7db2351':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, '157.79.72.96/6':::INET, '[{"9dYoP": [true], "D7": 0.15459898956891405, "I5p": false, "c": null}, true, "bar"]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (13726:::INT8, NULL, (-5904470552832941389):::INT8, (-1.0507593154907227):::FLOAT8, (-0.5301845042054827):::FLOAT8, '5874897-12-31':::DATE, '3000-01-01 00:00:00':::TIMESTAMP, '2023-05-05 09:21:00.000333+00':::TIMESTAMPTZ, '-12 years -3 mons -488 days -09:02:45.210398':::INTERVAL, true, (-9.019672275567322395E+20):::DECIMAL, NULL, '\x22':::BYTES, '17d7ddda-da55-4f36-981e-21f4a128d5bd':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '[true, 1.066109205822681, "KOJvb", false]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (0:::INT8, NULL, (-2243866586164498302):::INT8, (-1.0):::FLOAT8, 1.0:::FLOAT8, '1977-12-11':::DATE, '2030-10-20 17:34:56.00013':::TIMESTAMP, '4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ, '-79 years -11 mons -776 days -09:20:42.268373':::INTERVAL, true, 'NaN':::DECIMAL, '"':::STRING, '\x22d4e7cb41955b28':::BYTES, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '{"test": "json"}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (26059:::INT8, (-2147483648):::INT8, (-243677825602988248):::INT8, 0.0:::FLOAT8, (-0.8943954702537199):::FLOAT8, '1987-04-27':::DATE, '1999-04-26 00:43:25.000219':::TIMESTAMP, '2001-01-01 00:00:00+00 BC':::TIMESTAMPTZ, '33 years 11 mons 369 days 17:22:22.654502':::INTERVAL, false, (-9.094342496371397250E+19):::DECIMAL, e'\x00':::STRING, '\x29e038':::BYTES, '4a1959cc-6922-4828-8684-33ff7b5bb2ca':::UUID, '140.183.81.199/14':::INET, '"baz"':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (1659:::INT8, (-369223903):::INT8, 3580988378104660973:::INT8, (-1.6999220848083496):::FLOAT8, 0.08886028595150336:::FLOAT8, '-infinity':::DATE, '1970-11-21 06:30:03.000816':::TIMESTAMP, '0001-01-01 00:00:00+00':::TIMESTAMPTZ, '-2 years -9 mons -245 days -23:41:04.225039':::INTERVAL, false, (-7.95948212752067816E+35):::DECIMAL, e'\x00':::STRING, '\xfd':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, '220.128.139.50/4':::INET, '[[null, false], true, true, true]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-11922):::INT8, 1917819161:::INT8, 127:::INT8, 0.1715516746044159:::FLOAT8, '+Inf':::FLOAT8, '1975-05-02':::DATE, '1996-10-20 04:18:15.000589':::TIMESTAMP, '2001-01-01 00:00:00+00 BC':::TIMESTAMPTZ, '40 years 4 mons 667 days 01:52:13.088282':::INTERVAL, true, NULL, NULL, '\x':::BYTES, 'a7ce6de9-01d7-4425-a0b2-c761a6c53532':::UUID, '579e:eb81:a895:c489:fb2c:86c9:748c:bc6c/127':::INET, '1':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-128):::INT8, 612038691:::INT8, 2147483647:::INT8, (-1.487794041633606):::FLOAT8, '+Inf':::FLOAT8, '4714-11-24 BC':::DATE, '2022-03-06 10:59:17.000065':::TIMESTAMP, '1987-05-30 17:29:33.000785+00':::TIMESTAMPTZ, '-51 years -4 mons -422 days -12:59:06.797234':::INTERVAL, false, (-6.471691731414121275E+19):::DECIMAL, e'X\n^f\x05':::STRING, '\x6f80052ea4083bc905':::BYTES, 'a7a23a2b-44fb-4535-8243-3badf52b15d0':::UUID, '0.0.0.0/0':::INET, '{"7hBw": null, "Q92CiOG": true, "hQtPkKVP": [false], "oWoBG": 2.0000481472921896}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-14756):::INT8, (-672339784):::INT8, (-2147483648):::INT8, '-Inf':::FLOAT8, 1.7976931348623157e+308:::FLOAT8, '1975-12-12':::DATE, '1972-08-23 05:41:46.000272':::TIMESTAMP, '294276-12-31 23:59:59.999999+00':::TIMESTAMPTZ, '290 years':::INTERVAL, true, (-6076.9506182343330):::DECIMAL, NULL, '\xff409a6a958d':::BYTES, '69fd81f2-22c0-432a-b3fb-dceed073537d':::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 ((-1335):::INT8, 348121604:::INT8, (-1704366186685448454):::INT8, (-1.0):::FLOAT8, 1.0454154666560074:::FLOAT8, '1970-01-01':::DATE, '2025-11-21 04:07:59.000064':::TIMESTAMP, '1975-10-21 23:02:28.000567+00':::TIMESTAMPTZ, '35 years 2 mons 123 days 15:49:08.172226':::INTERVAL, false, (-4.17941523185344332E+36):::DECIMAL, '7O9':::STRING, '\xadbb8cebd5d6a536':::BYTES, '3c33051c-c3b4-4ce6-981a-a684fecbf9ef':::UUID, NULL, '{}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-24802):::INT8, (-1):::INT8, (-5490406770549615770):::INT8, 1.0:::FLOAT8, '+Inf':::FLOAT8, '4714-11-24 BC':::DATE, '1974-04-22 05:29:44.00033':::TIMESTAMP, '3000-01-01 00:00:00+00':::TIMESTAMPTZ, '40 years 4 mons 841 days 21:31:42.968513':::INTERVAL, false, 877387006.3061225747:::DECIMAL, e'\'':::STRING, '\xe9289d114a05de':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '{"a": 0.642171202496228, "baz": 0.0179205590303691}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (127:::INT8, (-1781501086):::INT8, (-7868691440074177212):::INT8, (-1.111312747001648):::FLOAT8, 0.6988687715856048:::FLOAT8, '5874897-12-31':::DATE, '0001-01-01 00:00:00':::TIMESTAMP, '1970-07-10 23:15:38.00097+00':::TIMESTAMPTZ, '-66 years -2 mons -152 days -12:05:07.678279':::INTERVAL, true, (-1.798352268533377840E+22):::DECIMAL, 'h_':::STRING, '\xf1cf0ce1':::BYTES, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, NULL, '[{"c": false}, false]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (0:::INT8, NULL, 0:::INT8, (-1.0):::FLOAT8, (-0.0596509842498163):::FLOAT8, '1977-03-10':::DATE, '0001-01-01 00:00:00':::TIMESTAMP, '1994-11-11 13:53:20.000034+00':::TIMESTAMPTZ, '-42 years -8 mons -693 days -02:06:52.751548':::INTERVAL, false, 'NaN':::DECIMAL, e'``<N\x14\x0bR}@':::STRING, '\x58':::BYTES, '3b2096bc-dc17-4010-9a9c-c0566384390b':::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 (32767:::INT8, (-32768):::INT8, (-32768):::INT8, (-0.09595683217048645):::FLOAT8, (-1.0):::FLOAT8, '-infinity':::DATE, '0001-01-01 00:00:00':::TIMESTAMP, '294276-12-31 23:59:59.999999+00':::TIMESTAMPTZ, '290 years':::INTERVAL, true, (-1):::DECIMAL, 'X':::STRING, '\x22':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, '8950:b4f5:a1c1:7bb9:f724:1ebb:8b35:1a31/10':::INET, '1':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-32768):::INT8, 127:::INT8, 8571463491824641969:::INT8, '+Inf':::FLOAT8, 3.4028234663852886e+38:::FLOAT8, '1981-04-01':::DATE, '2001-01-01 00:00:00 BC':::TIMESTAMP, '2013-01-03 06:35:38.000126+00':::TIMESTAMPTZ, '00:00:00':::INTERVAL, true, 88.76944621433108446:::DECIMAL, NULL, '\x3245a7':::BYTES, '66129066-869a-410a-9267-912c1e88c086':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '[true, null, {"foobar": 0.8426029106956152}, false, 0.21342714881595992]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-1):::INT8, 1688634114:::INT8, 5752160373832449298:::INT8, 0.0:::FLOAT8, NULL, '1991-04-08':::DATE, '4714-11-24 00:00:00 BC':::TIMESTAMP, '2004-04-13 14:58:22.000743+00':::TIMESTAMPTZ, '15 years 11 mons 658 days 06:24:51.926003':::INTERVAL, false, 1:::DECIMAL, e'\U00002603':::STRING, '\x13f105':::BYTES, 'f2571808-cbb3-4e27-b2c8-11d7bc046b0f':::UUID, '7e76:3691:8c24:1997:d848:65da:9424:5966/49':::INET, '{}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-1):::INT8, 32767:::INT8, (-894893010298563234):::INT8, (-0.36717507243156433):::FLOAT8, (-0.0):::FLOAT8, NULL, '2031-04-27 18:59:07.000236':::TIMESTAMP, '3000-01-01 00:00:00+00':::TIMESTAMPTZ, '290 years':::INTERVAL, true, 8.689473234053675355E+30:::DECIMAL, e'Z\x17/':::STRING, '\xdc611dc362f1623f14':::BYTES, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, 'be5:990:adbf:d2ec:c3b2:88a8:a676:a65e/73':::INET, '{"4EW": true, "PWUCT0": {"1Jfb": 0.04419410693919251, "c": null}, "bar": {"FsZ": null, "ae": true, "saGodTq": 0.7000213803446619}, "hdEdO2H": [{"OM3bIe2IY": "b"}, "b"], "iO0KHB": "P1xbWPEy"}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-128):::INT8, (-21038120):::INT8, 3508036935899684744:::INT8, 0.4507685601711273:::FLOAT8, 5e-324:::FLOAT8, '1976-01-22':::DATE, '0001-01-01 00:00:00':::TIMESTAMP, '294276-12-31 23:59:59.999999+00':::TIMESTAMPTZ, '-60 years -4 mons -456 days -08:33:03.246243':::INTERVAL, false, (-5.503005554912157101E+34):::DECIMAL, '':::STRING, '\x22':::BYTES, 'e557ec2c-28ab-41d7-8b1d-ab54e3e43e08':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '{"870UR": null, "bar": "bar"}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (32767:::INT8, 1:::INT8, 1493654713157952892:::INT8, 0.0:::FLOAT8, 0.31197071858208525:::FLOAT8, '-infinity':::DATE, '2009-10-24 00:22:41.000803':::TIMESTAMP, '0001-01-01 00:00:00+00':::TIMESTAMPTZ, '-83 years -2 mons -643 days -13:16:59.02603':::INTERVAL, true, '-Infinity':::DECIMAL, NULL, '\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 (17511:::INT8, 1559670609:::INT8, 1166842322083418410:::INT8, (-1.2364836931228638):::FLOAT8, 0.21799065594098593:::FLOAT8, '1982-11-17':::DATE, '1997-01-02 17:44:40.000541':::TIMESTAMP, '4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ, '1 day':::INTERVAL, true, (-2284614105059.839274):::DECIMAL, '"':::STRING, '\x9e':::BYTES, '00000000-0000-0000-0000-000000000000':::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 ((-128):::INT8, 939736376:::INT8, (-6498170159226681746):::INT8, 1.4745830297470093:::FLOAT8, 0.5767601527397384:::FLOAT8, '1987-11-25':::DATE, '2016-05-22 18:02:59.000866':::TIMESTAMP, '1975-02-04 14:26:20.000871+00':::TIMESTAMPTZ, '00:00:00':::INTERVAL, false, NULL, 'X':::STRING, NULL, 'e6e3d268-87c4-4204-ae70-1f518aadcc0c':::UUID, 'cce8:b1ac:474d:75af:3367:fc3:f211:13a3/90':::INET, '{"test": "json"}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (21538:::INT8, (-122952907):::INT8, (-7200937594589998628):::INT8, (-0.1452201008796692):::FLOAT8, 3.4028234663852886e+38:::FLOAT8, 'infinity':::DATE, '1993-05-12 23:14:30.000036':::TIMESTAMP, '1989-02-07 02:12:17.000226+00':::TIMESTAMPTZ, '290 years':::INTERVAL, false, 0:::DECIMAL, e'\x03':::STRING, '\x58':::BYTES, '376f0d96-d6f8-4f51-8504-b82ba077e04a':::UUID, 'b8cb:780f:7cc6:6cf4:76e1:4626:c3b9:fbb9/4':::INET, '{}':::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, 127:::INT8, (-0.0):::FLOAT8, 0.061416035521872636:::FLOAT8, 'infinity':::DATE, '2010-12-10 08:55:37.000008':::TIMESTAMP, '2001-01-01 00:00:00+00 BC':::TIMESTAMPTZ, '-53 years -2 mons -634 days -22:21:28.044007':::INTERVAL, true, (-1.234E+401):::DECIMAL, '':::STRING, '\x27':::BYTES, '453cbb79-be1d-47c9-8e2a-f383be38556a':::UUID, '0.0.0.0/0':::INET, '{"a": ["qh", {"foobar": "bar"}, true], "c": {"b": false, "gD": false, "tf": {"foobar": 0.35739855076804605, "uuMiDi": 1.9768659808361255}}, "lWCnEJ": true}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (14581:::INT8, 0:::INT8, 0:::INT8, 0.0:::FLOAT8, 3.4028234663852886e+38:::FLOAT8, '4714-11-24 BC':::DATE, '1998-08-09 15:31:57.000099':::TIMESTAMP, '1999-07-16 12:00:22.000292+00':::TIMESTAMPTZ, '-42 years -9 mons -871 days -00:47:19.819678':::INTERVAL, true, (-1.234E+401):::DECIMAL, e'\U00002603':::STRING, '\x22':::BYTES, '29856fd7-ddea-454f-9519-dfcf268ef60e':::UUID, '50.121.131.136/13':::INET, '{}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (5239:::INT8, NULL, 6402851146018302912:::INT8, 1.401298464324817e-45:::FLOAT8, (-1.0052234635844461):::FLOAT8, '5874897-12-31':::DATE, '4714-11-24 00:00:00 BC':::TIMESTAMP, NULL, '-18 years -7 mons -955 days -01:02:50.242961':::INTERVAL, false, (-5.806116665024952518E+24):::DECIMAL, 'X':::STRING, '\x00':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, '130.180.193.89/20':::INET, '1':::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 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 '01010000A0E6100000D8A9BF7AAB2842C04411E9A9A7465340FE4BA7C6D7BBFBC1':::GEOGRAPHY::GEOGRAPHY NOT IN ('0107000060E6100000040000000101000060E61000008003C014CBF648C0F0A73C70C7AD27C0AE58445628F5FEC10103000060E6100000010000000900000011F4B7264F135EC052C016E4765752C0EC68F4A96FABE3410002F78D14C4F63FD075483039E517C03CEDA736642D01C2A8C16E4E688433402A621CF8DD183EC0608C8A0300E1D741A0FD936298875D40BC2C560F2357384060575D1DE0CFEB41D83AEFE733715940460E1D402456404028B44832A159DB41BEEBF8C2A59F52407808E31659C63C40C476ADCB257AFBC1B8F327CD01564A4098A5754DF8A4444000788706F3C854C1B78BB037E74664C0922984B172B440403C31C7D2AC17FC4111F4B7264F135EC052C016E4765752C0EC68F4A96FABE3410106000060E61000000200000001030000400100000005000000C09BD9F45D594C405015D726368A23C0B84522546B8DDF4128F7A61F53AD5340825F01332AEB51C078C1626BC57AED4138E23B0DD35A64403C2AA3BFF37B434068FC010F9AEDF7C1681FC2EE44C032C070E9249227553240B290864ABB020142C09BD9F45D594C405015D726368A23C0B84522546B8DDF410103000040010000000900000080792C915108FEBFC597219BFE1752C06E35754FE1C8E1C1A0F48757F8414740F816B42F0DF754C0D02EE267854ECBC1A8B69AAEED276140206BBBF4108238C0505C4A2005FAEEC174ED807A6823604010B97E2FB13E134010C272B72CDFD24180CAB4465609F1BF5CF2689C7F2231403B590C8FBE00F7C1C9E59FD51B8D60C054E8EA01E71C3C40ECF0E8AF6494EA41808E8E2FC968F3BF488E7BADE74A33C07E9A278ED57BF4C19F3B2DEE9BF659C078A17888A5D12EC0B0531CC15ADDDA4180792C915108FEBFC597219BFE1752C06E35754FE1C8E1C10105000060E61000000400000001020000400300000025A8954107865AC0E05F25BD99280840F4D5867D9306FB41A97B2B8EDEA257C0A18EE45ADAB24DC0E04CCE7DA682F0C162FFC848E2D74EC070A3B5823E9527C004172493CFB3F241010200004002000000381EFD95F3B33040A8AF8021D4BD34C04C305CB00283D5C1E809D9FC788C3440A0EB50A5CE3233C06746D4934728FCC1010200004002000000D6DB87DD0DD951C07CB4683ED65B304014A60A282D8CEC4134C61A17D43961C030717EBB5BFC2D40421CB68D9C00F2C1010200004002000000A8CA1A1CAAD14FC086F06C690D145540400148E1D16AB7418F02117378A259C0B8EE8B4971203940B24CD69918EDFDC1':::GEOGRAPHY,)
    changefeed_test.go:1124: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE '01010000A0E6100000D8A9BF7AAB2842C04411E9A9A7465340FE4BA7C6D7BBFBC1':::GEOGRAPHY::GEOGRAPHY NOT IN ('0107000060E6100000040000000101000060E61000008003C014CBF648C0F0A73C70C7AD27C0AE58445628F5FEC10103000060E6100000010000000900000011F4B7264F135EC052C016E4765752C0EC68F4A96FABE3410002F78D14C4F63FD075483039E517C03CEDA736642D01C2A8C16E4E688433402A621CF8DD183EC0608C8A0300E1D741A0FD936298875D40BC2C560F2357384060575D1DE0CFEB41D83AEFE733715940460E1D402456404028B44832A159DB41BEEBF8C2A59F52407808E31659C63C40C476ADCB257AFBC1B8F327CD01564A4098A5754DF8A4444000788706F3C854C1B78BB037E74664C0922984B172B440403C31C7D2AC17FC4111F4B7264F135EC052C016E4765752C0EC68F4A96FABE3410106000060E61000000200000001030000400100000005000000C09BD9F45D594C405015D726368A23C0B84522546B8DDF4128F7A61F53AD5340825F01332AEB51C078C1626BC57AED4138E23B0DD35A64403C2AA3BFF37B434068FC010F9AEDF7C1681FC2EE44C032C070E9249227553240B290864ABB020142C09BD9F45D594C405015D726368A23C0B84522546B8DDF410103000040010000000900000080792C915108FEBFC597219BFE1752C06E35754FE1C8E1C1A0F48757F8414740F816B42F0DF754C0D02EE267854ECBC1A8B69AAEED276140206BBBF4108238C0505C4A2005FAEEC174ED807A6823604010B97E2FB13E134010C272B72CDFD24180CAB4465609F1BF5CF2689C7F2231403B590C8FBE00F7C1C9E59FD51B8D60C054E8EA01E71C3C40ECF0E8AF6494EA41808E8E2FC968F3BF488E7BADE74A33C07E9A278ED57BF4C19F3B2DEE9BF659C078A17888A5D12EC0B0531CC15ADDDA4180792C915108FEBFC597219BFE1752C06E35754FE1C8E1C10105000060E61000000400000001020000400300000025A8954107865AC0E05F25BD99280840F4D5867D9306FB41A97B2B8EDEA257C0A18EE45ADAB24DC0E04CCE7DA682F0C162FFC848E2D74EC070A3B5823E9527C004172493CFB3F241010200004002000000381EFD95F3B33040A8AF8021D4BD34C04C305CB00283D5C1E809D9FC788C3440A0EB50A5CE3233C06746D4934728FCC1010200004002000000D6DB87DD0DD951C07CB4683ED65B304014A60A282D8CEC4134C61A17D43961C030717EBB5BFC2D40421CB68D9C00F2C1010200004002000000A8CA1A1CAAD14FC086F06C690D145540400148E1D16AB7418F02117378A259C0B8EE8B4971203940B24CD69918EDFDC1':::GEOGRAPHY,) to emit 100 events
    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 49 events
    changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE 'J':::STRING ILIKE seed._string
    changefeed_test.go:1120: Skipping predicate 'J':::STRING ILIKE seed._string because it returned no rows
    changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE _st_covers(st_multi('01020000C002000000C6997F46F15F004200DA1A24F4E670C1C0B0D2EEE4D0A4C1942D9ACD7E0400C2182BC1E2C057FC415C1C9BCC8C68F64120AC5C61F17FDDC16D3DB7F3E4E9FFC1':::GEOMETRY::GEOMETRY)::GEOMETRY::GEOMETRY, NULL::GEOMETRY)::BOOL
    changefeed_test.go:1120: Skipping predicate _st_covers(st_multi('01020000C002000000C6997F46F15F004200DA1A24F4E670C1C0B0D2EEE4D0A4C1942D9ACD7E0400C2182BC1E2C057FC415C1C9BCC8C68F64120AC5C61F17FDDC16D3DB7F3E4E9FFC1':::GEOMETRY::GEOMETRY)::GEOMETRY::GEOMETRY, NULL::GEOMETRY)::BOOL because it returned no rows
    changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT '80000000/0':::PG_LSN AS col_28, (seed._string::STRING || false::BOOL)::STRING COLLATE de_DE AS col_29)
    changefeed_test.go:1124: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE EXISTS (SELECT '80000000/0':::PG_LSN AS col_28, (seed._string::STRING || false::BOOL)::STRING COLLATE de_DE AS col_29) 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 (NULL <= NULL)
    changefeed_test.go:1120: Skipping predicate (NULL <= NULL) because it returned no rows
    changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (NOT (NOT (seed._int2::INT8 IN ((-3743083305726139752):::INT8, (seed._date::DATE - seed._date::DATE)::INT8, (seed._int8::INT8 # seed._int2::INT8)::INT8, 1807154686695038517:::INT8))))
    changefeed_test.go:1124: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (NOT (NOT (seed._int2::INT8 IN ((-3743083305726139752):::INT8, (seed._date::DATE - seed._date::DATE)::INT8, (seed._int8::INT8 # seed._int2::INT8)::INT8, 1807154686695038517:::INT8)))) to emit 12 events
    changefeed_test.go:1141: cannot subtract infinite dates
    --- FAIL: TestChangefeedRandomExpressions/kafka (4.36s)

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-38424

rharding6373 commented 5 months ago

dupe of #120174