ccl/changefeedccl: TestChangefeedRandomExpressions failed

cockroachdb / cockroach

CockroachDB — the cloud native, distributed SQL database designed for high availability, effortless scale, and control over data placement.

Other

30.18k stars 3.82k forks source link

INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-32531):::INT8, (-2147483648):::INT8, (-2097506280509592247):::INT8, (-0.06676764786243439):::FLOAT8, 0.28276407007663096:::FLOAT8, '4714-11-24 BC':::DATE, '3000-01-01 00:00:00':::TIMESTAMP, '2007-06-02 21:46:08.000352+00':::TIMESTAMPTZ, '-9 years -2 mons -234 days -09:32:07.148654':::INTERVAL, false, (-485.8839199981704302):::DECIMAL, ':E':::STRING, '\x22':::BYTES, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, '3525:5bcb:d7fa:7e08:1721:2f1e:1176:9e20/74':::INET, '1':::JSONB); INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (22115:::INT8, (-32768):::INT8, NULL, (-1.0):::FLOAT8, 1.0:::FLOAT8, '1970-01-01':::DATE, '2001-01-01 00:00:00 BC':::TIMESTAMP, NULL, NULL, NULL, (-3.297488647317000929E+24):::DECIMAL, e'\'':::STRING, '\x':::BYTES, 'd044f79a-10a0-4b05-9cb2-de411deca0d0':::UUID, '0.0.0.0/0':::INET, '1':::JSONB); INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (21882:::INT8, 665520608:::INT8, 9223372036854775807:::INT8, '+Inf':::FLOAT8, (-1.4400155145627682):::FLOAT8, '1985-12-17':::DATE, '2001-01-01 00:00:00 BC':::TIMESTAMP, '3000-01-01 00:00:00+00':::TIMESTAMPTZ, '00:00:00':::INTERVAL, true, 1:::DECIMAL, '':::STRING, '\x22':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, '0.0.0.0/0':::INET, '{"Oukj95fPM": [false, false, 0.7896352949852021, 0.9444035392128721], "V0": [null, false, true, null], "a": null, "b": ["foo"], "baz": {"XxJ6tlLdJ": false, "b53XOh5": null, "b5HL4": true, "baz": null, "c": {"Ns": "c", "baz": false}}, "foo": {"a": 1.756508309664409, "foo": {"BwsMluVnG": null, "bar": 0.39862834021679133, "nSbw8R": 0.01282311255299403}}}':::JSONB); INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (1:::INT8, (-1):::INT8, (-32768):::INT8, NULL, 1.401298464324817e-45:::FLOAT8, '5874897-12-31':::DATE, '1976-01-28 05:56:24.000832':::TIMESTAMP, '4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ, '51 years 10 mons 459 days 17:55:30.220015':::INTERVAL, true, (-1.234E+401):::DECIMAL, e'-\x12W6T#VO':::STRING, '\xa4aac200cbb6':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, '193.222.221.151/16':::INET, '{"test": "json"}':::JSONB); INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (26045:::INT8, 0:::INT8, 9208252062725612115:::INT8, 1.401298464324817e-45:::FLOAT8, '-Inf':::FLOAT8, '-infinity':::DATE, '2027-06-06 06:11:51.000567':::TIMESTAMP, '0001-01-01 00:00:00+00':::TIMESTAMPTZ, '00:00:00':::INTERVAL, true, (-1.214052895072570354E+35):::DECIMAL, '':::STRING, '\x956de19d71d8ee':::BYTES, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, '62b5:c10b:fa38:ab93:a984:69f:bf8f:a0b5/115':::INET, '[[1.630434884947431, 3.0670002840742345], null, 1.2101192113137138]':::JSONB); INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (13846:::INT8, 1109123359:::INT8, (-8575751779385037471):::INT8, (-0.45933058857917786):::FLOAT8, 1.5843514883368268:::FLOAT8, '1988-06-30':::DATE, '2025-07-21 06:24:59.000081':::TIMESTAMP, '1973-01-26 21:50:06.000234+00':::TIMESTAMPTZ, '-80 years -7 mons -768 days -05:06:39.327677':::INTERVAL, false, (-0.9147092411669870962):::DECIMAL, e'\'':::STRING, '\x22':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, '3b99:9ef9:9d82:633e:807:f6c0:b8d5:55a8/32':::INET, '1':::JSONB); INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (22596:::INT8, 32767:::INT8, 7508273483608316514:::INT8, '+Inf':::FLOAT8, 1.7976931348623157e+308:::FLOAT8, '1980-12-13':::DATE, '1974-12-03 06:06:26.000946':::TIMESTAMP, '2004-02-25 01:09:01.000695+00':::TIMESTAMPTZ, '290 years':::INTERVAL, true, (-8.901710716065399885E+37):::DECIMAL, 'X':::STRING, '\x00':::BYTES, 'bb9cd4e6-4231-4c93-af67-22a1011d9c60':::UUID, '54.118.202.238/31':::INET, '[false, null, true]':::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:1134: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE seed._bool changefeed_test.go:1150: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE seed._bool to emit 55 events changefeed_test.go:1134: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT seed._timestamptz AS col_17, seed._string AS col_18, e'qi\x1dx\x1b\x17P':::STRING AS col_19, '0103000000010000000A000000BAF461EE1A4C01C24A2BB5EBD113F9C1947FAE5254ABD9C1999FD2E7434F00C25601D57ED1CBF641A9915BC29B9100C258FBE9C0E389FA41316B018F4B20FAC1D4FC15F866FCE04166D7EEC34DABE3C1EA489359CC9D024258ED4DA3F960D44170E83F9A90ECD6C1569FF46BAB7CFA41D924C918A58F01C2163B27BC494EF24175542306E871F6C150CD1D224584C141BAF461EE1A4C01C24A2BB5EBD113F9C1':::GEOMETRY AS col_20, 'BOX(-0.7814060164278221 0.32550313606761705,-0.6270961557505284 1.7416577160308533)':::BOX2D AS "co}l\\U000A9045_21") changefeed_test.go:1150: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE EXISTS (SELECT seed._timestamptz AS col_17, seed._string AS col_18, e'qi\x1dx\x1b\x17P':::STRING AS col_19, '0103000000010000000A000000BAF461EE1A4C01C24A2BB5EBD113F9C1947FAE5254ABD9C1999FD2E7434F00C25601D57ED1CBF641A9915BC29B9100C258FBE9C0E389FA41316B018F4B20FAC1D4FC15F866FCE04166D7EEC34DABE3C1EA489359CC9D024258ED4DA3F960D44170E83F9A90ECD6C1569FF46BAB7CFA41D924C918A58F01C2163B27BC494EF24175542306E871F6C150CD1D224584C141BAF461EE1A4C01C24A2BB5EBD113F9C1':::GEOMETRY AS col_20, 'BOX(-0.7814060164278221 0.32550313606761705,-0.6270961557505284 1.7416577160308533)':::BOX2D AS "co}l\\U000A9045_21") to emit 100 events changefeed_test.go:1153: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC changefeed_test.go:1134: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE seed.tableoid::OID NOT IN (SELECT 4171911607:::OID::OID AS "cO̿\\U00058895l_29" FROM d.public.seed AS "t�ab_8" JOIN d.public.seed AS "t ab%v_9" ON ("t�ab_8"._jsonb) = ("t ab%v_9"._jsonb) ORDER BY seed._jsonb ASC NULLS FIRST) changefeed_test.go:1150: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE seed.tableoid::OID NOT IN (SELECT 4171911607:::OID::OID AS "cO̿\\U00058895l_29" FROM d.public.seed AS "t�ab_8" JOIN d.public.seed AS "t ab%v_9" ON ("t�ab_8"._jsonb) = ("t ab%v_9"._jsonb) ORDER BY seed._jsonb ASC NULLS FIRST) to emit 100 events changefeed_test.go:1153: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC changefeed_test.go:1134: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE true changefeed_test.go:1150: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE true to emit 100 events changefeed_test.go:1134: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE '01060000E0E61000000100000001030000C0010000000600000034129C05DCB35DC0A155A4D40DA643C0005BD2831425D641426BDF0E97F9F2C1C26AED00479F5140CB4DD46A66E440C080C7EF7ED883A3C10B7793C85DF6F3C1E4B74FB9179C5D40ACBD01E2EAAC49C06E8747907FB3EFC114C54CE51F280242DA26492CA13C53C0E8C05E27F31556409697D259F01FF5C18077E60A90B396411196CC8AC14355C0687C61FD238E4A4050AAC61B5200CA4100F99B3FC437FCC134129C05DCB35DC0A155A4D40DA643C0005BD2831425D641426BDF0E97F9F2C1':::GEOGRAPHY::GEOGRAPHY NOT IN (SELECT '01030000E0E61000000100000009000000AFBC0D5430CA64C00C58D8F2E2D153C04A38B2F1AC93F8C178FAC8B7226DE04190379640B7A534C0604715DD758A4AC0A8F2A74734FEF541808C03675BF7FE41E0CE2FC265891640A3772EBB273646C008A58B421ED0EF41F2FA79B974E101423E93F36893EC644008F8EE50E16A53C062607D7BD7ACF041206461EC23F7CEC15A1C5D94F09065408FEFB71976C053C010D008D0B105F74156DF0DE02F5501C2CE56E0BFF41E6440F03C648ECF3F4B40A87DD279CF40EC41408AA27365AABD418E8BC715DCDA64C008C96D2AF3FE4940A674187C8C40FDC13A4134DF5744ECC167B0CBF3C4F465C050D36D60698F2740B443471EA62CFE4100D874B8207B6241AFBC0D5430CA64C00C58D8F2E2D153C04A38B2F1AC93F8C178FAC8B7226DE041':::GEOGRAPHY::GEOGRAPHY AS "Col_81" FROM d.public.seed AS tab_25 WHERE seed._string::STRING IN (SELECT seed._string::STRING AS "col""_80" FROM d.public.seed AS ta😂b_26 JOIN d.public.seed AS tab_27 ON (((ta😂b_26.crdb_internal_mvcc_timestamp) = (tab_27.crdb_internal_mvcc_timestamp)) AND ((ta😂b_26._decimal) = (tab_27.crdb_internal_mvcc_timestamp))) AND ((ta😂b_26._float8) = (tab_27._float4)) JOIN d.public.seed AS "tAb_28" ON (ta😂b_26._int4) = ("tAb_28".crdb_internal_origin_id)) GROUP BY seed._decimal, seed._int8, seed._int4 HAVING seed._bool) changefeed_test.go:1150: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE '01060000E0E61000000100000001030000C0010000000600000034129C05DCB35DC0A155A4D40DA643C0005BD2831425D641426BDF0E97F9F2C1C26AED00479F5140CB4DD46A66E440C080C7EF7ED883A3C10B7793C85DF6F3C1E4B74FB9179C5D40ACBD01E2EAAC49C06E8747907FB3EFC114C54CE51F280242DA26492CA13C53C0E8C05E27F31556409697D259F01FF5C18077E60A90B396411196CC8AC14355C0687C61FD238E4A4050AAC61B5200CA4100F99B3FC437FCC134129C05DCB35DC0A155A4D40DA643C0005BD2831425D641426BDF0E97F9F2C1':::GEOGRAPHY::GEOGRAPHY NOT IN (SELECT '01030000E0E61000000100000009000000AFBC0D5430CA64C00C58D8F2E2D153C04A38B2F1AC93F8C178FAC8B7226DE04190379640B7A534C0604715DD758A4AC0A8F2A74734FEF541808C03675BF7FE41E0CE2FC265891640A3772EBB273646C008A58B421ED0EF41F2FA79B974E101423E93F36893EC644008F8EE50E16A53C062607D7BD7ACF041206461EC23F7CEC15A1C5D94F09065408FEFB71976C053C010D008D0B105F74156DF0DE02F5501C2CE56E0BFF41E6440F03C648ECF3F4B40A87DD279CF40EC41408AA27365AABD418E8BC715DCDA64C008C96D2AF3FE4940A674187C8C40FDC13A4134DF5744ECC167B0CBF3C4F465C050D36D60698F2740B443471EA62CFE4100D874B8207B6241AFBC0D5430CA64C00C58D8F2E2D153C04A38B2F1AC93F8C178FAC8B7226DE041':::GEOGRAPHY::GEOGRAPHY AS "Col_81" FROM d.public.seed AS tab_25 WHERE seed._string::STRING IN (SELECT seed._string::STRING AS "col""_80" FROM d.public.seed AS ta😂b_26 JOIN d.public.seed AS tab_27 ON (((ta😂b_26.crdb_internal_mvcc_timestamp) = (tab_27.crdb_internal_mvcc_timestamp)) AND ((ta😂b_26._decimal) = (tab_27.crdb_internal_mvcc_timestamp))) AND ((ta😂b_26._float8) = (tab_27._float4)) JOIN d.public.seed AS "tAb_28" ON (ta😂b_26._int4) = ("tAb_28".crdb_internal_origin_id)) GROUP BY seed._decimal, seed._int8, seed._int4 HAVING seed._bool) to emit 100 events changefeed_test.go:1153: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC changefeed_test.go:1134: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT seed._string AS col_95 FROM d.public.seed AS tab😜_34 JOIN d.public.seed AS tab_35 ON ((tab😜_34._jsonb) = (tab_35._jsonb)) AND ((tab😜_34._int4) = (tab_35.crdb_internal_origin_id))) changefeed_test.go:1150: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE EXISTS (SELECT seed._string AS col_95 FROM d.public.seed AS tab😜_34 JOIN d.public.seed AS tab_35 ON ((tab😜_34._jsonb) = (tab_35._jsonb)) AND ((tab😜_34._int4) = (tab_35.crdb_internal_origin_id))) to emit 100 events changefeed_test.go:1153: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC changefeed_test.go:1134: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE NULL changefeed_test.go:1146: Skipping predicate NULL because it returned no rows changefeed_test.go:1134: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (NOT (((seed._string !~* seed._string) OR true) OR (false AND false))) changefeed_test.go:1146: Skipping predicate (NOT (((seed._string !~* seed._string) OR true) OR (false AND false))) because it returned no rows changefeed_test.go:1134: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE ((NOT ('*Ix:euBT':::STRING::STRING % seed._string::STRING)::BOOL) OR NULL) changefeed_test.go:1150: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE ((NOT ('*Ix:euBT':::STRING::STRING % seed._string::STRING)::BOOL) OR NULL) to emit 93 events changefeed_test.go:1134: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE false changefeed_test.go:1146: Skipping predicate false because it returned no rows changefeed_test.go:1134: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE not_similar_to_escape(NULL::STRING, seed._string::STRING, seed._string::STRING)::BOOL changefeed_test.go:1146: Skipping predicate not_similar_to_escape(NULL::STRING, seed._string::STRING, seed._string::STRING)::BOOL because it returned no rows changefeed_test.go:1134: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT '1997-08-25 01:52:11.000164':::TIMESTAMP AS col_154, NULL AS col_155 FROM d.public.seed AS "ta b/_68" JOIN d.public.seed AS tab_69 ON ("ta b/_68"._jsonb) = (tab_69._jsonb) WHERE true GROUP BY seed._jsonb, seed._jsonb HAVING NULL ILIKE CASE WHEN NULL THEN '8':::STRING ELSE st_isvalidreason(st_pointfromtext(e')\r':::STRING::STRING, (-2161572070535776):::INT8::INT8)::GEOMETRY::GEOMETRY)::STRING END) changefeed_test.go:1146: Skipping predicate EXISTS (SELECT '1997-08-25 01:52:11.000164':::TIMESTAMP AS col_154, NULL AS col_155 FROM d.public.seed AS "ta b/_68" JOIN d.public.seed AS tab_69 ON ("ta b/_68"._jsonb) = (tab_69._jsonb) WHERE true GROUP BY seed._jsonb, seed._jsonb HAVING NULL ILIKE CASE WHEN NULL THEN '8':::STRING ELSE st_isvalidreason(st_pointfromtext(e')\r':::STRING::STRING, (-2161572070535776):::INT8::INT8)::GEOMETRY::GEOMETRY)::STRING END) because it returned no rows changefeed_test.go:1134: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE '1972-07-19 10:30:28.000337':::TIMESTAMP::TIMESTAMP IN (SELECT '2027-01-05 01:48:38.000744':::TIMESTAMP::TIMESTAMP AS "c\nol_177" FROM d.public.seed AS tab_83 JOIN d.public.seed AS tab_84 ON (tab_83._jsonb) = (tab_84._jsonb) WHERE ('150.72.52.37/23':::INET::INET << 'ce72:4316:36dd:cfee:658:87f1:48ca:94de/5':::INET::INET)::BOOL) changefeed_test.go:1146: Skipping predicate '1972-07-19 10:30:28.000337':::TIMESTAMP::TIMESTAMP IN (SELECT '2027-01-05 01:48:38.000744':::TIMESTAMP::TIMESTAMP AS "c\nol_177" FROM d.public.seed AS tab_83 JOIN d.public.seed AS tab_84 ON (tab_83._jsonb) = (tab_84._jsonb) WHERE ('150.72.52.37/23':::INET::INET << 'ce72:4316:36dd:cfee:658:87f1:48ca:94de/5':::INET::INET)::BOOL) because it returned no rows changefeed_test.go:1134: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE ('ae7f:14f0:24f:e3e6:e1ad:caeb:6517:6242/51':::INET::INET >> seed._inet::INET)::BOOL changefeed_test.go:1146: Skipping predicate ('ae7f:14f0:24f:e3e6:e1ad:caeb:6517:6242/51':::INET::INET >> seed._inet::INET)::BOOL because it returned no rows changefeed_test.go:1134: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._bool AND (seed._bool OR (NOT st_relatematch(seed._string::STRING, abbrev(seed._inet::INET)::STRING::STRING)::BOOL))) changefeed_test.go:1150: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (seed._bool AND (seed._bool OR (NOT st_relatematch(seed._string::STRING, abbrev(seed._inet::INET)::STRING::STRING)::BOOL))) to emit 55 events changefeed_test.go:1167: st_relatematch(): relation "\n\x04ti" should be of length 9 --- FAIL: TestChangefeedRandomExpressions/kafka (2.88s)

ccl/changefeedccl.TestChangefeedRandomExpressions failed on release-24.3 @ 416acdb7560e4548f3b82c5a522ef48592471c7d:

        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (22323:::INT8, 1464337956:::INT8, 1:::INT8, 1.401298464324817e-45:::FLOAT8, 1.0:::FLOAT8, '1970-01-01':::DATE, '2025-02-11 06:47:20.000506':::TIMESTAMP, '0001-01-01 00:00:00+00':::TIMESTAMPTZ, '-67 years -6 mons -654 days -15:32:06.434763':::INTERVAL, false, 235750018.4368637014:::DECIMAL, e'\U00002603':::STRING, '\xe29883':::BYTES, NULL, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '{"sljzO1DMB": "Iixf"}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-11422):::INT8, (-128):::INT8, (-9223372036854775807):::INT8, '+Inf':::FLOAT8, NULL, '1982-09-24':::DATE, '2001-01-01 00:00:00 BC':::TIMESTAMP, '2023-03-30 23:13:55.000781+00':::TIMESTAMPTZ, NULL, true, 9.14446751033221030:::DECIMAL, e'3C=H=]\x0e90':::STRING, '\x':::BYTES, '7954f177-e900-42df-a27e-6907a8522cdc':::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 (2531:::INT8, NULL, (-2147483648):::INT8, (-1.0):::FLOAT8, 1.468421735873438:::FLOAT8, '1993-03-24':::DATE, '2012-07-18 17:50:44.000578':::TIMESTAMP, '0001-01-01 00:00:00+00':::TIMESTAMPTZ, '1 year 11 mons 813 days 05:35:25.177158':::INTERVAL, true, (-1.0):::DECIMAL, '"':::STRING, '\x00':::BYTES, '8c652eee-eb7f-46f2-b424-821bccd4f997':::UUID, 'f66a:cccb:8326:c646:f5d9:e687:4e9a:954d/110':::INET, '{"0DDAyJhH": false, "4awMvSH": {"bar": "baz", "qObCyKBYq": false}, "7yG": 0.7404266560679562, "Wt": 0.2537113742400261}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (28625:::INT8, (-1171243246):::INT8, 8036464947038992685:::INT8, 1.401298464324817e-45:::FLOAT8, (-0.5111492890647098):::FLOAT8, '1972-08-15':::DATE, '1980-01-24 10:40:12.000008':::TIMESTAMP, '1982-11-27 23:29:36.000289+00':::TIMESTAMPTZ, '-44 years -5 mons -749 days -14:58:51.187017':::INTERVAL, true, (-3.398778512694758617E+21):::DECIMAL, '"':::STRING, '\x00':::BYTES, NULL, '93.24.237.53/23':::INET, '{"test": "json"}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (145:::INT8, (-1):::INT8, 1558640843621574278:::INT8, (-0.20311810076236725):::FLOAT8, 1.284908411697253:::FLOAT8, '1970-01-01':::DATE, NULL, '4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ, '1 day':::INTERVAL, true, 0:::DECIMAL, '6E':::STRING, '\x5afb877927f05c':::BYTES, '6d47f9ee-2b81-4f7a-8d9c-ba9eb4f2b0cf':::UUID, NULL, '{"DfE3l": 0.4843784529669096, "c": {"T4": true, "XtZ": "foo"}, "dhQmcw": null}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-1):::INT8, 712072775:::INT8, (-8319507782414847086):::INT8, '-Inf':::FLOAT8, 1.7976931348623157e+308:::FLOAT8, '4714-11-24 BC':::DATE, '3000-01-01 00:00:00':::TIMESTAMP, '4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ, NULL, true, 1:::DECIMAL, '1':::STRING, '\x211f4a':::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 (21752:::INT8, (-718269169):::INT8, 7047122340374434689:::INT8, (-1.6268869638442993):::FLOAT8, (-1.2734616908653404):::FLOAT8, '-infinity':::DATE, '1982-06-23 03:05:27.000853':::TIMESTAMP, '4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ, '1 day':::INTERVAL, true, (-6770598477.672591170):::DECIMAL, e'!/LQX\x05o\x0e':::STRING, '\x130c20':::BYTES, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '[{"5I": {"HrjqH2xL": "1ZTKRtSzZ"}, "a": ["bar", 6.079145389398718], "c": "bar", "foobar": {"foobar": "foobar", "hDV37Ed": null}}, true, {"c": true}, true]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (127:::INT8, NULL, 9223372036854775807:::INT8, (-1.5059107542037964):::FLOAT8, (-1.0):::FLOAT8, '1970-10-10':::DATE, '1974-10-07 21:22:08.00072':::TIMESTAMP, '2026-05-05 05:25:49.000397+00':::TIMESTAMPTZ, '43 years 799 days 04:02:31.422653':::INTERVAL, false, 31684282.1063337584:::DECIMAL, '':::STRING, '\x':::BYTES, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, '120.69.86.184/25':::INET, '{"8a1q": [true], "foo": true, "foobar": "QhfG", "idq": "baz"}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-4574):::INT8, (-1):::INT8, 2147483647:::INT8, 1.682680368423462:::FLOAT8, '+Inf':::FLOAT8, '1973-05-29':::DATE, '4714-11-24 00:00:00 BC':::TIMESTAMP, '2001-01-01 00:00:00+00 BC':::TIMESTAMPTZ, '290 years':::INTERVAL, true, NULL, e'\'':::STRING, '\x':::BYTES, '76e8411e-03d4-42dd-ac20-7a1426137699':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '[["a", 0.1274386842519947, false], [2.3073464545374187, 1.450550560097906], "umhnO", "foo"]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-128):::INT8, NULL, (-4489642189496254363):::INT8, (-0.010376039892435074):::FLOAT8, (-0.9114752251516065):::FLOAT8, NULL, '1982-12-23 05:09:57.000693':::TIMESTAMP, '3000-01-01 00:00:00+00':::TIMESTAMPTZ, '6 years 538 days 12:43:56.112978':::INTERVAL, false, 1:::DECIMAL, e'ZX\b':::STRING, '\x27':::BYTES, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, '30.58.119.69/25':::INET, '{}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-1):::INT8, (-1):::INT8, 32767:::INT8, 0.5988417863845825:::FLOAT8, 0.8636200705474735:::FLOAT8, '4714-11-24 BC':::DATE, '2033-01-13 08:58:26.000104':::TIMESTAMP, '4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ, '290 years':::INTERVAL, false, (-1):::DECIMAL, '':::STRING, '\x4673240a543ed98f':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, '177.110.217.19/2':::INET, '["baz"]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-32768):::INT8, (-32768):::INT8, (-32768):::INT8, 0.987525463104248:::FLOAT8, (-0.07947721471051694):::FLOAT8, '1985-08-03':::DATE, '2020-05-02 19:28:35.000681':::TIMESTAMP, '3000-01-01 00:00:00+00':::TIMESTAMPTZ, '79 years 616 days 04:18:29.852898':::INTERVAL, false, 0:::DECIMAL, '"':::STRING, '\xa5d0684a':::BYTES, 'ded5dc07-51da-49da-a779-ddc2ae5d4a4f':::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 (11617:::INT8, 32767:::INT8, 134370475410090318:::INT8, (-1.0555570125579834):::FLOAT8, (-1.158288660553517):::FLOAT8, '1971-10-01':::DATE, '3000-01-01 00:00:00':::TIMESTAMP, '3000-01-01 00:00:00+00':::TIMESTAMPTZ, '1 mon 1 day':::INTERVAL, false, (-1.234E+401):::DECIMAL, 'v/':::STRING, '\x58':::BYTES, 'af2a42a2-513d-4e10-a090-a555e0248973':::UUID, 'e194:ebfc:66b5:4150:8978:6275:38db:fb11/86':::INET, '{"b": {"c": null}, "foo": [0.9576902505204734, 0.37401130527482324], "xKyYKq": true}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (20680:::INT8, (-128):::INT8, (-9223372036854775807):::INT8, 0.8437385559082031:::FLOAT8, (-0.31564082097698287):::FLOAT8, '1970-01-01':::DATE, '294276-12-31 23:59:59.999999':::TIMESTAMP, '0001-01-01 00:00:00+00':::TIMESTAMPTZ, NULL, true, (-1179251823.025013953):::DECIMAL, e';\x0f8u1u3':::STRING, '\x':::BYTES, '05ee6f4f-3114-4b21-80d4-507fea8938ba':::UUID, '2086:ce8c:8375:8124:6551:5559:87bd:56a7/47':::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, 127:::INT8, 7245910345648000554:::INT8, 0.964347779750824:::FLOAT8, '-Inf':::FLOAT8, '1987-11-13':::DATE, '2001-01-01 00:00:00 BC':::TIMESTAMP, '0001-01-01 00:00:00+00':::TIMESTAMPTZ, '-62 years -8 mons -490 days -23:10:11.946165':::INTERVAL, false, (-1.234E+401):::DECIMAL, '':::STRING, '\xff':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, '73.194.153.61/26':::INET, '{"9k": true}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (26322:::INT8, 1933363083:::INT8, 1:::INT8, 0.8483347296714783:::FLOAT8, 1.6324788787038313:::FLOAT8, 'infinity':::DATE, '2026-06-26 02:04:01.000296':::TIMESTAMP, '4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ, '00:00:00':::INTERVAL, true, (-3.501087483560338150E+28):::DECIMAL, e'0\t':::STRING, '\xff':::BYTES, '1046e49d-48ad-4c14-b9e1-0d7a1405833d':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '{"DFec": {"P8pIH": false, "XD0": {"b": true, "foobar": true, "q8mfSkU": ["L0zKr0"]}}, "a": false, "qS61XCR": false, "wT0s9x4": "1y4n9h2"}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-1):::INT8, 2147483647:::INT8, (-1):::INT8, 0.0:::FLOAT8, 0.4258627651259017:::FLOAT8, '1982-11-24':::DATE, '2011-10-22 17:47:26.00075':::TIMESTAMP, '2033-02-25 10:53:57.000433+00':::TIMESTAMPTZ, '70 years 523 days 18:49:53.362069':::INTERVAL, true, 1.0:::DECIMAL, '':::STRING, '\x3e80364c6c3b':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, '52.21.172.71/11':::INET, '1':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-10286):::INT8, 484404470:::INT8, 9223372036854775807:::INT8, (-0.5517345070838928):::FLOAT8, '+Inf':::FLOAT8, '5874897-12-31':::DATE, '1988-08-25 00:45:37.00099':::TIMESTAMP, '1982-05-14 01:08:20.000433+00':::TIMESTAMPTZ, '20 years 5 mons 17 days 24:18:53.403367':::INTERVAL, true, (-4.23256610379957951):::DECIMAL, e'oq5m\x11-':::STRING, '\x56':::BYTES, '2a5cde6a-a43d-42fc-8c6e-ab44be57f176':::UUID, '0.0.0.0/0':::INET, '[[false], "7Tjx", false]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (30520:::INT8, 1:::INT8, 3280496036164601569:::INT8, (-1.5405278205871582):::FLOAT8, NULL, '1986-10-20':::DATE, '294276-12-31 23:59:59.999999':::TIMESTAMP, '1974-03-27 03:07:19.000786+00':::TIMESTAMPTZ, '13 years 6 mons 724 days 08:07:35.224524':::INTERVAL, true, (-1):::DECIMAL, 'X':::STRING, '\x00':::BYTES, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, '0.0.0.0/0':::INET, '{"2c19": 0.5606714238118167, "8Ka": false, "O1rpAXM": {"xBEx": false}, "a": [[true, 0.9742732125692513, false], {"a": "Yu", "baz": ["6E2r7V", false], "c": null}, [true], {"foobar": 0.9837596915352844, "rcb": false}, "bar", true, 0.2454638041157659], "baz": true, "c": {"4Fr": 0.10564589911770295, "b": true, "bar": "a"}}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-32768):::INT8, 1006638231:::INT8, (-8104122446153402541):::INT8, 1.401298464324817e-45:::FLOAT8, (-0.06608471143833838):::FLOAT8, '1996-05-05':::DATE, '3000-01-01 00:00:00':::TIMESTAMP, '2001-01-01 00:00:00+00 BC':::TIMESTAMPTZ, '8 years 1 mon 157 days 20:44:06.068555':::INTERVAL, true, 'Infinity':::DECIMAL, e'\U00002603':::STRING, '\x08b21d2f':::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 ((-1):::INT8, 32767:::INT8, 9223372036854775807:::INT8, (-0.7248105406761169):::FLOAT8, 0.5955360127248965:::FLOAT8, 'infinity':::DATE, '1998-11-24 05:02:38.000313':::TIMESTAMP, NULL, NULL, true, 8.351353881838416281E+33:::DECIMAL, e'\U00002603':::STRING, '\xe29883':::BYTES, '71f541c0-098a-4788-87b7-3bef5382cb6b':::UUID, '156.218.173.108/12':::INET, '{"test": "json"}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (29523:::INT8, 820013162:::INT8, (-274185138819853492):::INT8, (-0.5070459246635437):::FLOAT8, 0.32308772300711097:::FLOAT8, '1973-09-30':::DATE, '2008-07-04 21:34:52.000808':::TIMESTAMP, '1975-11-04 04:09:01.000068+00':::TIMESTAMPTZ, '290 years':::INTERVAL, true, 1:::DECIMAL, '"':::STRING, '\x27':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, '0.0.0.0/0':::INET, '[[false], "pvz86S"]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-1):::INT8, 0:::INT8, 0:::INT8, '+Inf':::FLOAT8, '+Inf':::FLOAT8, 'infinity':::DATE, '4714-11-24 00:00:00 BC':::TIMESTAMP, '1973-01-23 02:30:34.000711+00':::TIMESTAMPTZ, '82 years 8 mons 894 days 17:58:51.956357':::INTERVAL, true, (-1.0):::DECIMAL, e'"\x18xf\fK\x04':::STRING, NULL, '5f89c634-630d-464e-8462-a98cf891a581':::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 ((-19953):::INT8, 1287599862:::INT8, 0:::INT8, 0.0021998186130076647:::FLOAT8, 0.3778495033237221:::FLOAT8, '5874897-12-31':::DATE, NULL, '2031-10-06 06:13:57.000915+00':::TIMESTAMPTZ, '-40 years -3 mons -382 days -07:56:04.180171':::INTERVAL, false, 5.412321376502810441E+23:::DECIMAL, e'\'':::STRING, '\x904c1a0e201c':::BYTES, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, '16f9:d800:97e5:48cb:cdea:518d:f266:4bf9/101':::INET, '{}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (16091:::INT8, (-2147483648):::INT8, (-187978740386356084):::INT8, (-1.0):::FLOAT8, 1.4580573720825847:::FLOAT8, '1985-02-06':::DATE, '2009-10-30 09:13:55.000523':::TIMESTAMP, '0001-01-01 00:00:00+00':::TIMESTAMPTZ, NULL, true, '-Infinity':::DECIMAL, '"':::STRING, '\xab0e1fd4148804a68e':::BYTES, 'f5adc15a-971a-4a01-b3ab-b63dbe096d79':::UUID, NULL, '{"Fb3McOf1": 1.2115610345691061, "iFXbHlpW": null}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-32555):::INT8, 2147483647:::INT8, (-1):::INT8, 0.140853613615036:::FLOAT8, 0.8105439266458071:::FLOAT8, '5874897-12-31':::DATE, '2024-06-20 17:40:48.000909':::TIMESTAMP, '2009-02-22 11:27:40.000993+00':::TIMESTAMPTZ, '00:00:00':::INTERVAL, true, 0:::DECIMAL, e'\x0b\x1a{C-\\x6':::STRING, '\xb4642a4f0c93':::BYTES, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, '0.247.127.87/2':::INET, '1':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (127:::INT8, (-2147483648):::INT8, (-779275397157233974):::INT8, 0.0:::FLOAT8, 0.4288256304179753:::FLOAT8, '1988-10-24':::DATE, '2019-10-24 09:45:08.000301':::TIMESTAMP, '2015-02-11 23:58:55.000664+00':::TIMESTAMPTZ, '-78 years -4 mons -979 days -18:06:44.796211':::INTERVAL, false, 0:::DECIMAL, '<':::STRING, '\xff':::BYTES, 'dfd02705-6dd2-4772-996c-60baac480420':::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 (24682:::INT8, (-1):::INT8, (-4219047665584158798):::INT8, '+Inf':::FLOAT8, 3.4028234663852886e+38:::FLOAT8, '1981-10-27':::DATE, '294276-12-31 23:59:59.999999':::TIMESTAMP, '2004-01-09 06:10:20.000504+00':::TIMESTAMPTZ, '13 years 1 mon 570 days 07:44:59.474418':::INTERVAL, false, (-1.0):::DECIMAL, e'$\x1c,\\k\x12n}\x11':::STRING, '\x1d49':::BYTES, '4ae7c922-c4c8-4398-9467-71e6d14b1a7d':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '{"a": {"jH": 0.9924284656661913}, "bar": "c", "baz": true, "foobar": true}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (7714:::INT8, (-2147483648):::INT8, (-9223372036854775807):::INT8, (-0.8843377828598022):::FLOAT8, '+Inf':::FLOAT8, '-infinity':::DATE, NULL, '3000-01-01 00:00:00+00':::TIMESTAMPTZ, '-19 years -5 mons -822 days -15:13:42.749122':::INTERVAL, true, 'Infinity':::DECIMAL, '3&R(AYT#':::STRING, '\x1bfbd68ad6a260':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, 'e085:ed80:7482:bdb:7fbc:59f5:5ea8:448f/18':::INET, '{"1x0B": ["c2OKQhanT", null], "2P8XnE6": [null], "a": true, "foobar": null}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-20768):::INT8, (-1):::INT8, (-2506756120461338380):::INT8, (-0.0):::FLOAT8, (-0.6130413117517582):::FLOAT8, 'infinity':::DATE, '0001-01-01 00:00:00':::TIMESTAMP, '294276-12-31 23:59:59.999999+00':::TIMESTAMPTZ, '43 years 72 days 12:00:00.204482':::INTERVAL, false, 0:::DECIMAL, NULL, '\xe29883':::BYTES, '8cecd49a-d35c-4bea-99be-75703e570ceb':::UUID, '2.144.14.162/10':::INET, '{}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-2754):::INT8, (-1900666354):::INT8, 2058515725579043470:::INT8, 1.0:::FLOAT8, '+Inf':::FLOAT8, '1972-10-04':::DATE, '0001-01-01 00:00:00':::TIMESTAMP, '1973-09-10 09:15:38.000082+00':::TIMESTAMPTZ, '00:00:00':::INTERVAL, false, 1.0:::DECIMAL, e'``7#9f9\fu~':::STRING, '\x27':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, 'b1f1:f7a6:b186:c717:9d94:4927:dff2:9968':::INET, '[{"Waz": true, "bAgcl": {"729RI1ogh": [0.1622292935038952, 0.044039741848858026], "e47dDTWXD": true, "haDW": false}, "k7yzbsJR": 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, 2099224898:::INT8, 8065325262908673038:::INT8, (-1.2593729496002197):::FLOAT8, 1.101329868437686:::FLOAT8, '1975-09-07':::DATE, '1973-01-02 00:35:53.00032':::TIMESTAMP, '4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ, '-57 years -11 mons -617 days -02:42:59.222425':::INTERVAL, false, 'Infinity':::DECIMAL, e'xW.\x13':::STRING, '\x4b96cf8d34':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, NULL, '{}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-1):::INT8, 1536060829:::INT8, (-4359518084054791133):::INT8, (-0.028889738023281097):::FLOAT8, (-0.5308979838208046):::FLOAT8, '-infinity':::DATE, '1992-06-04 22:51:39.000489':::TIMESTAMP, '2001-01-01 00:00:00+00 BC':::TIMESTAMPTZ, NULL, true, 5.726027796869089848E+31:::DECIMAL, '"':::STRING, NULL, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, 'cb3e:c2a2:44d4:7011:a59a:f781:6caf:4248/57':::INET, '{"c": true, "foobar": false, "nlztmuQvt": 0.7674800273625446, "tiTiB": true}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-128):::INT8, 127:::INT8, 127:::INT8, NULL, NULL, '1987-07-10':::DATE, '2001-01-01 00:00:00 BC':::TIMESTAMP, '2001-01-01 00:00:00+00 BC':::TIMESTAMPTZ, '20 years 2 mons 488 days 14:38:53.302386':::INTERVAL, true, 8.350394531906973538E+23:::DECIMAL, e'\x00':::STRING, '\x27':::BYTES, '48f92471-42d7-423b-80cc-64c3c701ab35':::UUID, '893d:b121:b7d4:736e:f593:bfcd:fc5b:cefe/0':::INET, '1':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (NULL, (-259412197):::INT8, 7213135709619538647:::INT8, '+Inf':::FLOAT8, 1.7120708862283525:::FLOAT8, 'infinity':::DATE, '2031-07-11 21:29:36.000474':::TIMESTAMP, '2008-06-24 06:42:30.000074+00':::TIMESTAMPTZ, '1 mon 1 day':::INTERVAL, true, NULL, e'"FV\x1c\x11&|':::STRING, '\x':::BYTES, '650a10b2-ca47-4961-8ab5-96a975090720':::UUID, 'c306:14a6:f5f0:703:9a10:1ddd:e86d:cf6c/28':::INET, '{}':::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:1134: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE true
    changefeed_test.go:1150: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE true to emit 100 events
    changefeed_test.go:1134: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE st_covers('01040000E0E61000000300000001010000C0102D0094A2253AC0D24B34F4B1CD48C0382B71078C4F00C2C0046F983D8CDD4101010000C0301322B52E7A5F40F8AC0646A9794A40D41C2EACAFC6FA41AFBB73490895FFC101010000C00058BD746187E4BF00274C12885EF5BF7CE0AB4905B4F6C1806379AD33A7B1C1':::GEOGRAPHY::GEOGRAPHY, '0104000060E610000005000000010100004078BEB31156A65840ACD9DAA3EF383D402464433FB0D7EE41010100004098A42ED099F15F40F8FB03483A9542409C6A7739B6EEE9410101000040783EAE6183D84340687C8203353F45C0BC4034DC16EBF641010100004084656A581EEB484080DEA391441E0D40605C7EA93A08F6410101000040F27FDFC0AF116240C1D1C703E98853C0EBE80C06B90EF0C1':::GEOGRAPHY::GEOGRAPHY)::BOOL
    changefeed_test.go:1146: Skipping predicate st_covers('01040000E0E61000000300000001010000C0102D0094A2253AC0D24B34F4B1CD48C0382B71078C4F00C2C0046F983D8CDD4101010000C0301322B52E7A5F40F8AC0646A9794A40D41C2EACAFC6FA41AFBB73490895FFC101010000C00058BD746187E4BF00274C12885EF5BF7CE0AB4905B4F6C1806379AD33A7B1C1':::GEOGRAPHY::GEOGRAPHY, '0104000060E610000005000000010100004078BEB31156A65840ACD9DAA3EF383D402464433FB0D7EE41010100004098A42ED099F15F40F8FB03483A9542409C6A7739B6EEE9410101000040783EAE6183D84340687C8203353F45C0BC4034DC16EBF641010100004084656A581EEB484080DEA391441E0D40605C7EA93A08F6410101000040F27FDFC0AF116240C1D1C703E98853C0EBE80C06B90EF0C1':::GEOGRAPHY::GEOGRAPHY)::BOOL because it returned no rows
    changefeed_test.go:1134: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE seed."col""_40"
    changefeed_test.go:1139: Skipping query SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE seed."col""_40" because error pq: column "seed.col\"_40" does not exist
    changefeed_test.go:1134: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE seed._bool
    changefeed_test.go:1150: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE seed._bool to emit 47 events
    changefeed_test.go:1134: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._bool AND (seed._string ~* seed._string))
    changefeed_test.go:1150: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (seed._bool AND (seed._string ~* seed._string)) to emit 42 events
    changefeed_test.go:1167: invalid regular expression: error parsing regexp: missing closing ]: ``[)``
    --- FAIL: TestChangefeedRandomExpressions/kafka (10.82s)

Parameters:

attempt=1
run=8
shard=12
Help

Same failure on other branches

- #132516 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-23.2.13-rc] - #131898 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc X-duplicate branch-release-24.1.6-rc release-blocker] - #131179 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-24.1.5-rc] - #129173 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-24.2.0-rc] - #128772 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-24.1.3-rc] - #127642 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-24.2] - #126889 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-24.1.2-rc] - #124738 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot P-3 T-cdc branch-release-24.1] - #120174 ccl/changefeedccl: TestChangefeedRandomExpressions failed [test needs adjustment] [A-cdc C-test-failure O-robot P-3 T-cdc branch-master]

This test on roachdash | Improve this report!

INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-1):::INT8, 1:::INT8, (-1):::INT8, '-Inf':::FLOAT8, '+Inf':::FLOAT8, '1987-04-09':::DATE, '2024-05-13 22:28:59.000596':::TIMESTAMP, '2007-12-09 01:41:34.000752+00':::TIMESTAMPTZ, '40 years 7 mons 628 days 20:36:29.383354':::INTERVAL, true, NULL, 'Qu#]':::STRING, '\x':::BYTES, 'c98d4680-a443-45f9-8750-3e485f2da535':::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 (1:::INT8, 1627069604:::INT8, 5758520192150450710:::INT8, 0.0:::FLOAT8, (-1.409271494699245):::FLOAT8, '1980-01-26':::DATE, '2009-11-21 05:03:22.000716':::TIMESTAMP, '2021-07-21 22:27:18.000952+00':::TIMESTAMPTZ, '36 years 5 mons 556 days 10:06:17.878416':::INTERVAL, false, 88847801888329.56029:::DECIMAL, 'x3s':::STRING, '\x7495':::BYTES, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, '131.182.253.170/10':::INET, '{"test": "json"}':::JSONB); INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (7436:::INT8, (-128):::INT8, (-1944830492231045209):::INT8, (-1.149985909461975):::FLOAT8, (-0.0):::FLOAT8, '1987-04-20':::DATE, '2000-10-18 09:57:57.000347':::TIMESTAMP, '3000-01-01 00:00:00+00':::TIMESTAMPTZ, '19 years 10 mons 177 days 07:12:24.167663':::INTERVAL, false, (-1):::DECIMAL, e'\U00002603':::STRING, '\x58':::BYTES, '51f44bb6-34d1-4ac6-844e-791837e86693':::UUID, '184.172.107.151/12':::INET, '1':::JSONB); INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-32413):::INT8, (-718967233):::INT8, (-9223372036854775807):::INT8, 0.7019750475883484:::FLOAT8, (-3.094944302407807):::FLOAT8, '1972-02-05':::DATE, '2001-01-01 00:00:00 BC':::TIMESTAMP, '1997-04-17 18:02:38.000737+00':::TIMESTAMPTZ, '290 years':::INTERVAL, true, 293058291161.8460601:::DECIMAL, e'\b\x14\t,&\x1a':::STRING, '\x27':::BYTES, '1f6c8aed-9043-49d9-9df0-b8bd0e0558d2':::UUID, '166.16.103.251':::INET, '{"PbzfI": false, "baz": "L9dL5"}':::JSONB); INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-32768):::INT8, (-2095454418):::INT8, (-2147483648):::INT8, 0.0:::FLOAT8, 1.860289857234929:::FLOAT8, '1970-01-01':::DATE, '2025-10-02 16:32:05.000206':::TIMESTAMP, '4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ, '1 mon 1 day':::INTERVAL, false, 0:::DECIMAL, e'\U00002603':::STRING, '\x':::BYTES, '824991ce-1833-4074-bac8-b87ebfd5ec51':::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 (6800:::INT8, 947165573:::INT8, (-2147483648):::INT8, 1.7104681730270386:::FLOAT8, 0.0:::FLOAT8, '-infinity':::DATE, '294276-12-31 23:59:59.999999':::TIMESTAMP, '2015-12-31 09:39:31.000034+00':::TIMESTAMPTZ, NULL, false, 1.0:::DECIMAL, '':::STRING, '\x':::BYTES, NULL, '182.183.55.139/5':::INET, '{"0Nso": null, "Oc7gF": "foo", "a": [false]}':::JSONB); INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (24248:::INT8, (-1697187877):::INT8, 32767:::INT8, (-0.308144748210907):::FLOAT8, 0.9733883187677626:::FLOAT8, '1986-11-11':::DATE, '0001-01-01 00:00:00':::TIMESTAMP, '4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ, '00:00:00':::INTERVAL, true, (-1.10183441612872890E+25):::DECIMAL, e'\x1f;D)(\x19(4V':::STRING, '\x00':::BYTES, '7731e559-91ee-44fb-9e25-0b69166dee73':::UUID, 'db9d:80df:dfd8:9cc1:bc20:6089:7377:3943/51':::INET, '{"2Oa": true, "a": [false], "bar": "c", "c": [[{"tM": true}, false], false, 3.226171378711417], "jmy3Ef1nm": "xfrg", "n4ea": [false]}':::JSONB); INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (1:::INT8, 364999266:::INT8, (-1):::INT8, 1.401298464324817e-45:::FLOAT8, NULL, '1976-04-19':::DATE, '294276-12-31 23:59:59.999999':::TIMESTAMP, '2033-02-24 08:51:15.000109+00':::TIMESTAMPTZ, '-70 years -8 mons -440 days -14:42:29.944841':::INTERVAL, true, 0:::DECIMAL, 'VRx6+Zn':::STRING, '\x':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, '72e3:645:36dd:f19a:67c3:d6c4:f87a:957/64':::INET, '{"3K": true, "6M0rgyLx": null, "bar": {"BO": 0.30001266584305436}}':::JSONB); INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (0:::INT8, 127:::INT8, (-7181554345287229667):::INT8, NULL, 5e-324:::FLOAT8, '1973-05-05':::DATE, '2001-01-01 00:00:00 BC':::TIMESTAMP, '2032-08-28 14:54:13.00049+00':::TIMESTAMPTZ, '-35 years -431 days -15:50:29.562791':::INTERVAL, false, '-Infinity':::DECIMAL, '"':::STRING, '\x':::BYTES, '5e61bed0-0c71-4009-b552-481467b5112d':::UUID, '0.0.0.0/0':::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:1136: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (('05:42:31.472125':::TIME::TIME || e'#\x1668\x0fN':::STRING::STRING)::STRING::STRING || '{"a": true, "foo": null}':::JSONB::JSONB)::STRING ~* e'j(\tV\x06u\x12':::STRING changefeed_test.go:1141: Skipping query SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (('05:42:31.472125':::TIME::TIME || e'#\x1668\x0fN':::STRING::STRING)::STRING::STRING || '{"a": true, "foo": null}':::JSONB::JSONB)::STRING ~* e'j(\tV\x06u\x12':::STRING because error pq: invalid regular expression: error parsing regexp: missing closing ): ``(?i:j( V�u�)`` changefeed_test.go:1136: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE seed._bool changefeed_test.go:1152: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE seed._bool to emit 44 events testfeed_test.go:301: creating external connection testfeed_test.go:304: ran create external connection changefeed_test.go:1136: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (('1992-12-20':::DATE::DATE NOT IN (SELECT seed._date::DATE AS col_13 FROM d.public.seed AS tab_11 JOIN d.public.seed AS "t%qab!_12" ON (tab_11._jsonb) = ("t%qab!_12"._jsonb) JOIN d.public.seed AS "taB_13" ON (tab_11._jsonb) = ("taB_13"._jsonb))) OR false) changefeed_test.go:1152: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (('1992-12-20':::DATE::DATE NOT IN (SELECT seed._date::DATE AS col_13 FROM d.public.seed AS tab_11 JOIN d.public.seed AS "t%qab!_12" ON (tab_11._jsonb) = ("t%qab!_12"._jsonb) JOIN d.public.seed AS "taB_13" ON (tab_11._jsonb) = ("taB_13"._jsonb))) OR false) to emit 92 events testfeed_test.go:301: creating external connection testfeed_test.go:304: ran create external connection changefeed_test.go:1155: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC changefeed_test.go:1136: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE st_isclosed(NULL::GEOMETRY)::BOOL changefeed_test.go:1148: Skipping predicate st_isclosed(NULL::GEOMETRY)::BOOL because it returned no rows changefeed_test.go:1136: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE false changefeed_test.go:1148: Skipping predicate false because it returned no rows changefeed_test.go:1136: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE true changefeed_test.go:1152: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE true to emit 100 events testfeed_test.go:301: creating external connection testfeed_test.go:304: ran create external connection changefeed_test.go:1136: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT e'\\':::STRING AS "co l_59" FROM d.public.seed AS "ta%b̸._39" JOIN d.public.seed AS tab_40 ON ("ta%b̸._39"._jsonb) = (tab_40._jsonb) ORDER BY seed._jsonb DESC NULLS FIRST, seed._jsonb ASC) changefeed_test.go:1152: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE EXISTS (SELECT e'\\':::STRING AS "co l_59" FROM d.public.seed AS "ta%b̸._39" JOIN d.public.seed AS tab_40 ON ("ta%b̸._39"._jsonb) = (tab_40._jsonb) ORDER BY seed._jsonb DESC NULLS FIRST, seed._jsonb ASC) to emit 100 events testfeed_test.go:301: creating external connection testfeed_test.go:304: ran create external connection changefeed_test.go:1155: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC changefeed_test.go:1136: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (NULL AND _st_covers('0106000020E61000000200000001030000000100000004000000BC2EED4B001065C0D31C913D082D47C040206247B5D42E402383CA98150F41C0524C84D1751F6340505FDC2888CF18C0BC2EED4B001065C0D31C913D082D47C00103000000010000000700000074AF2D81F2B65DC04E2B3DE4A8483BC0A006F4543D0C114000133DE8D60025C0A05207588E2224C0A0AC2F6AFFBF2A40ECE7ED5D65745F40140186EC759A414028E18A1603C34DC0B6B67802CCD55240C8B007C5261A5CC08004A7F1B1C9454074AF2D81F2B65DC04E2B3DE4A8483BC0':::GEOGRAPHY::GEOGRAPHY, '01070000A0E61000000300000001060000A0E61000000200000001030000800100000009000000F8DB80DF2EFF43401C42D423852E3240647E16479C22FD41F2E11FF118A65140C1E291FBAE9749C0CAA5CF04A5BEF941A4C554FDB8756640C099F27B62DB04C0F08C8856611ED4C1083EE749A550544048D3ECECF3E050407C9EB66F4A5B00422426F88E42AE4C4060A5C9EC89D04B406839554F2FB7F8C1D873D65095214A40C8C2F3AF054156400EA9B9751D1F0242A070B1D2656439C0D0B30A5F51F65540F02BFBBD42D5E241B8B8C62CB95346C00470ADF3C9185540101E0CD64C9CD4C1F8DB80DF2EFF43401C42D423852E3240647E16479C22FD410103000080010000000600000066700E990F7C5FC0333BAD6FDCB941C08C7ACD637F1FE541E21B7235AB2B51401C033D53ADE254C02A08E25D944FFAC1228DFBC8E5C164404191AE088FDC46C09191FC4EAD6DFFC1AE4F477EA880654070C087341D4839C028020FB693ECF7C194DB165019726040FABB11F6501155403C60A67A9D88FB4166700E990F7C5FC0333BAD6FDCB941C08C7ACD637F1FE54101030000A0E6100000010000000600000065764108C35A55C0A773684903CD46C0C6FCE5C3CE92F941F00B3193F64325C00858C2024C9351C0007396531CAF9F4168953AAABAEE39404C3757FE59DF4E404855DFF85EBDFB41A0785F12CED01EC000178E85A00F4B40C8CE40D0FABDE141B29D0776991860C03CA37F28ABE4314070D7C62AA60ACEC165764108C35A55C0A773684903CD46C0C6FCE5C3CE92F94101020000A0E61000000200000014CAA7FE606C52C0CA1013680BED52C0C83CBA1C0E14FB41C023002902BB4AC070962CB2E84152C0402EF4D0A00CF141':::GEOGRAPHY::GEOGRAPHY)::BOOL) changefeed_test.go:1148: Skipping predicate (NULL AND _st_covers('0106000020E61000000200000001030000000100000004000000BC2EED4B001065C0D31C913D082D47C040206247B5D42E402383CA98150F41C0524C84D1751F6340505FDC2888CF18C0BC2EED4B001065C0D31C913D082D47C00103000000010000000700000074AF2D81F2B65DC04E2B3DE4A8483BC0A006F4543D0C114000133DE8D60025C0A05207588E2224C0A0AC2F6AFFBF2A40ECE7ED5D65745F40140186EC759A414028E18A1603C34DC0B6B67802CCD55240C8B007C5261A5CC08004A7F1B1C9454074AF2D81F2B65DC04E2B3DE4A8483BC0':::GEOGRAPHY::GEOGRAPHY, '01070000A0E61000000300000001060000A0E61000000200000001030000800100000009000000F8DB80DF2EFF43401C42D423852E3240647E16479C22FD41F2E11FF118A65140C1E291FBAE9749C0CAA5CF04A5BEF941A4C554FDB8756640C099F27B62DB04C0F08C8856611ED4C1083EE749A550544048D3ECECF3E050407C9EB66F4A5B00422426F88E42AE4C4060A5C9EC89D04B406839554F2FB7F8C1D873D65095214A40C8C2F3AF054156400EA9B9751D1F0242A070B1D2656439C0D0B30A5F51F65540F02BFBBD42D5E241B8B8C62CB95346C00470ADF3C9185540101E0CD64C9CD4C1F8DB80DF2EFF43401C42D423852E3240647E16479C22FD410103000080010000000600000066700E990F7C5FC0333BAD6FDCB941C08C7ACD637F1FE541E21B7235AB2B51401C033D53ADE254C02A08E25D944FFAC1228DFBC8E5C164404191AE088FDC46C09191FC4EAD6DFFC1AE4F477EA880654070C087341D4839C028020FB693ECF7C194DB165019726040FABB11F6501155403C60A67A9D88FB4166700E990F7C5FC0333BAD6FDCB941C08C7ACD637F1FE54101030000A0E6100000010000000600000065764108C35A55C0A773684903CD46C0C6FCE5C3CE92F941F00B3193F64325C00858C2024C9351C0007396531CAF9F4168953AAABAEE39404C3757FE59DF4E404855DFF85EBDFB41A0785F12CED01EC000178E85A00F4B40C8CE40D0FABDE141B29D0776991860C03CA37F28ABE4314070D7C62AA60ACEC165764108C35A55C0A773684903CD46C0C6FCE5C3CE92F94101020000A0E61000000200000014CAA7FE606C52C0CA1013680BED52C0C83CBA1C0E14FB41C023002902BB4AC070962CB2E84152C0402EF4D0A00CF141':::GEOGRAPHY::GEOGRAPHY)::BOOL) because it returned no rows changefeed_test.go:1136: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (false OR ((netmask(seed._inet::INET)::INET::INET & '1ba:9854:a84a:2263:6f1:9d10:930d:2a12/113':::INET::INET)::INET::INET >> 'a11d:c450:7e43:3c7:20a3:12b5:3187:4df8/15':::INET::INET)::BOOL) changefeed_test.go:1141: Skipping query SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (false OR ((netmask(seed._inet::INET)::INET::INET & '1ba:9854:a84a:2263:6f1:9d10:930d:2a12/113':::INET::INET)::INET::INET >> 'a11d:c450:7e43:3c7:20a3:12b5:3187:4df8/15':::INET::INET)::BOOL) because error pq: cannot AND inet values of different sizes changefeed_test.go:1136: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE st_dwithin('01060000A0E61000000900000001030000800100000006000000E8B6CDDE9B2963C086B8E107A87454C0689F674E74BEE341E0F3AEF8964D11C0B831C015F1054BC0E62312C85AF5F4C1802F4DEDD66756405EAEE54A5D945240A8E2BE77A208DB41C00680A77C1130405ED44C61AF574240DCF9D7B4298DFC41487047C12A364AC07E0C12870E6D5440D0501A6B60E5D2C1E8B6CDDE9B2963C086B8E107A87454C0689F674E74BEE3410103000080010000000400000034E01A1C10585740B4DACE5FA50E3440AC09BC97F4B5F4C1B03235A316402CC026C52F15D3985140408FD45DFFB8FE4160E21BBB448039C07A7D6C7427AA514015F9A0B4191201C234E01A1C10585740B4DACE5FA50E3440AC09BC97F4B5F4C1010300008001000000060000007D9E90215D0266C0A0EABD6B0E9130C00059E0A6DF93FCC18C950C07457847C00D6FF88616CF50C091AF71CED218F3C15EA8AC1C0C176540E85BE77457EC28C020941516F9B4B0C1FA4FE5F85D77514058186C58CAB04D40E8321B712790FC41E829599FB27532C07051E3ECA8232E402764AD1011B9F4C17D9E90215D0266C0A0EABD6B0E9130C00059E0A6DF93FCC10103000080010000000800000000A624CA752B3740AF07BA390B0A41C0D8568583C661EC4156332FABBF855140965BE59B45ED52C012F37CBD6436F6C104470FC700D15B40A265848A3EF04DC0C0D55ACD422FB841EAABBA71B6836140C829EC2036A827C0B0D46572D440D1C188C804EFEED36440A0133DFC06D904C01E2D471D5721F7C1E52F7C8AB5435CC06EBE88501A795640404E7712191CCAC14D86AFDC70CA61C050CB68CF87FA47407826929BED12F8C100A624CA752B3740AF07BA390B0A41C0D8568583C661EC410103000080010000000400000029EB62BBADAA5AC0ACE01DB18A6253C0DC0E8FCDF154F14180E65E64682C484055290452EE5650C0A82E693FBA8FEE414E52595F4BE363C0E1A9FDC0A0974EC0199D0BB6D87DF4C129EB62BBADAA5AC0ACE01DB18A6253C0DC0E8FCDF154F1410103000080010000000B0000004A6C1F72A4A864C082047EA6BA0A3CC08495051742F2F4C128D1CC23845B52C017474A78AF8444C07E89878E79A1FAC1A96207C589F456C0D57316FC369D4BC0E0CF5181ABE2D24100EC8EA0036EF4BFDF2102BA67EE51C05B675877A977FEC1D886ADB47B0766405C575888083956C070650E9B8DBBCA4164597A3D95F54F409C7FCF02B05D39C0DB0895513399F3C1661F8D19E63A66402CD333B79F804A40008AFAD69318A341783EB2E1411659403C2DA0FD119C4940F06ED1A6D64701422E3DBD06AB0A61C0F2A4CCA9407055401639138A623EF941B42EE9E9268557C006B242BB968642407830C8F69B8BD2414A6C1F72A4A864C082047EA6BA0A3CC08495051742F2F4C1010300008001000000060000001EE71442DBD362C0C0FE7781A98D09C02C82B5AA754AE6C1B0A21B14DEAC4B406859C07CFEC122C05CC632E01367F4416435739FA35F494060655B5CEAC70EC0AF25809383DDFBC12E407C2A43385CC0B0E283F4BCAA4D402C62EE612A35E241D5234DD1D35D61C028DD82274F072A40FC5E18BE0CD8F1C11EE71442DBD362C0C0FE7781A98D09C02C82B5AA754AE6C101030000800100000005000000780DD3158C303EC08688C92DD10745C020F967C9EF5AC0C1787DF6BB9D29534028E055FF8FF4464058FAE86049FCFBC16C91199E633859405405A83AA3A44A401CE913625805FFC1FF8891E9C68D60C0E200A3891F1C5240ECE066AE1A94EE41780DD3158C303EC08688C92DD10745C020F967C9EF5AC0C1010300008001000000070000009E442074446F65C0F02F5481F77452C080E788C90D71DD41F2469F2F0C2965406B007B4C47DE4BC0F1D922A07A9AF3C1B8A1ABE13E4C6640835186BCFAFF40C0BCB26E502DE3FE419E73AE6E49906240E0AE0B2E367F0CC07E74B68D8FE1F1415AD3B284FA02664038601EF8B23056403AF5A41E4B03F5C17C48C113D8E355C038B83E7A37754E40A2DE63810ED6ECC19E442074446F65C0F02F5481F77452C080E788C90D71DD41':::GEOGRAPHY::GEOGRAPHY, NULL::GEOGRAPHY, seed._float8::FLOAT8, seed._bool::BOOL)::BOOL changefeed_test.go:1148: Skipping predicate st_dwithin('01060000A0E61000000900000001030000800100000006000000E8B6CDDE9B2963C086B8E107A87454C0689F674E74BEE341E0F3AEF8964D11C0B831C015F1054BC0E62312C85AF5F4C1802F4DEDD66756405EAEE54A5D945240A8E2BE77A208DB41C00680A77C1130405ED44C61AF574240DCF9D7B4298DFC41487047C12A364AC07E0C12870E6D5440D0501A6B60E5D2C1E8B6CDDE9B2963C086B8E107A87454C0689F674E74BEE3410103000080010000000400000034E01A1C10585740B4DACE5FA50E3440AC09BC97F4B5F4C1B03235A316402CC026C52F15D3985140408FD45DFFB8FE4160E21BBB448039C07A7D6C7427AA514015F9A0B4191201C234E01A1C10585740B4DACE5FA50E3440AC09BC97F4B5F4C1010300008001000000060000007D9E90215D0266C0A0EABD6B0E9130C00059E0A6DF93FCC18C950C07457847C00D6FF88616CF50C091AF71CED218F3C15EA8AC1C0C176540E85BE77457EC28C020941516F9B4B0C1FA4FE5F85D77514058186C58CAB04D40E8321B712790FC41E829599FB27532C07051E3ECA8232E402764AD1011B9F4C17D9E90215D0266C0A0EABD6B0E9130C00059E0A6DF93FCC10103000080010000000800000000A624CA752B3740AF07BA390B0A41C0D8568583C661EC4156332FABBF855140965BE59B45ED52C012F37CBD6436F6C104470FC700D15B40A265848A3EF04DC0C0D55ACD422FB841EAABBA71B6836140C829EC2036A827C0B0D46572D440D1C188C804EFEED36440A0133DFC06D904C01E2D471D5721F7C1E52F7C8AB5435CC06EBE88501A795640404E7712191CCAC14D86AFDC70CA61C050CB68CF87FA47407826929BED12F8C100A624CA752B3740AF07BA390B0A41C0D8568583C661EC410103000080010000000400000029EB62BBADAA5AC0ACE01DB18A6253C0DC0E8FCDF154F14180E65E64682C484055290452EE5650C0A82E693FBA8FEE414E52595F4BE363C0E1A9FDC0A0974EC0199D0BB6D87DF4C129EB62BBADAA5AC0ACE01DB18A6253C0DC0E8FCDF154F1410103000080010000000B0000004A6C1F72A4A864C082047EA6BA0A3CC08495051742F2F4C128D1CC23845B52C017474A78AF8444C07E89878E79A1FAC1A96207C589F456C0D57316FC369D4BC0E0CF5181ABE2D24100EC8EA0036EF4BFDF2102BA67EE51C05B675877A977FEC1D886ADB47B0766405C575888083956C070650E9B8DBBCA4164597A3D95F54F409C7FCF02B05D39C0DB0895513399F3C1661F8D19E63A66402CD333B79F804A40008AFAD69318A341783EB2E1411659403C2DA0FD119C4940F06ED1A6D64701422E3DBD06AB0A61C0F2A4CCA9407055401639138A623EF941B42EE9E9268557C006B242BB968642407830C8F69B8BD2414A6C1F72A4A864C082047EA6BA0A3CC08495051742F2F4C1010300008001000000060000001EE71442DBD362C0C0FE7781A98D09C02C82B5AA754AE6C1B0A21B14DEAC4B406859C07CFEC122C05CC632E01367F4416435739FA35F494060655B5CEAC70EC0AF25809383DDFBC12E407C2A43385CC0B0E283F4BCAA4D402C62EE612A35E241D5234DD1D35D61C028DD82274F072A40FC5E18BE0CD8F1C11EE71442DBD362C0C0FE7781A98D09C02C82B5AA754AE6C101030000800100000005000000780DD3158C303EC08688C92DD10745C020F967C9EF5AC0C1787DF6BB9D29534028E055FF8FF4464058FAE86049FCFBC16C91199E633859405405A83AA3A44A401CE913625805FFC1FF8891E9C68D60C0E200A3891F1C5240ECE066AE1A94EE41780DD3158C303EC08688C92DD10745C020F967C9EF5AC0C1010300008001000000070000009E442074446F65C0F02F5481F77452C080E788C90D71DD41F2469F2F0C2965406B007B4C47DE4BC0F1D922A07A9AF3C1B8A1ABE13E4C6640835186BCFAFF40C0BCB26E502DE3FE419E73AE6E49906240E0AE0B2E367F0CC07E74B68D8FE1F1415AD3B284FA02664038601EF8B23056403AF5A41E4B03F5C17C48C113D8E355C038B83E7A37754E40A2DE63810ED6ECC19E442074446F65C0F02F5481F77452C080E788C90D71DD41':::GEOGRAPHY::GEOGRAPHY, NULL::GEOGRAPHY, seed._float8::FLOAT8, seed._bool::BOOL)::BOOL because it returned no rows changefeed_test.go:1136: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE '':::STRING !~* e'L\fc\\K\x01v$':::STRING changefeed_test.go:1141: Skipping query SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE '':::STRING !~* e'L\fc\\K\x01v$':::STRING because error pq: invalid regular expression: error parsing regexp: invalid escape sequence: ``\K`` changefeed_test.go:1136: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._bool AND (seed._bool OR _st_dwithinexclusive(st_geogfromgeojson('{"test": "json"}':::JSONB::JSONB)::GEOGRAPHY::GEOGRAPHY, '0105000060E610000001000000010200004008000000C831EF00811140C000AA35FB5150D13F7FF6C28ADAC1F3C100265FE8A71A4CC08C8AD2C3829339C03C5DBC39E796DCC130E43EFF80B444C034A77EC4C5F751C06AED1EF94C6500424C269067AF3C5940F69B80685E6F54C09AC8382424DAF0C1FCE38D653AAC4D403081FEAE5C0926C098FED2AA62B7F8413C7755B6084E57409C4A8EEA31EC4440A0B638ED55E6C6C1400F5794D261584000E3705EDE99504060D0681941A9FB41F664462CC97D5040D203C4D39F415440B058953EFD8AE741':::GEOGRAPHY::GEOGRAPHY, (-2.027430558318774):::FLOAT8::FLOAT8, (false AND (NULL !~ seed._string))::BOOL)::BOOL)) changefeed_test.go:1152: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (seed._bool AND (seed._bool OR _st_dwithinexclusive(st_geogfromgeojson('{"test": "json"}':::JSONB::JSONB)::GEOGRAPHY::GEOGRAPHY, '0105000060E610000001000000010200004008000000C831EF00811140C000AA35FB5150D13F7FF6C28ADAC1F3C100265FE8A71A4CC08C8AD2C3829339C03C5DBC39E796DCC130E43EFF80B444C034A77EC4C5F751C06AED1EF94C6500424C269067AF3C5940F69B80685E6F54C09AC8382424DAF0C1FCE38D653AAC4D403081FEAE5C0926C098FED2AA62B7F8413C7755B6084E57409C4A8EEA31EC4440A0B638ED55E6C6C1400F5794D261584000E3705EDE99504060D0681941A9FB41F664462CC97D5040D203C4D39F415440B058953EFD8AE741':::GEOGRAPHY::GEOGRAPHY, (-2.027430558318774):::FLOAT8::FLOAT8, (false AND (NULL !~ seed._string))::BOOL)::BOOL)) to emit 44 events testfeed_test.go:301: creating external connection testfeed_test.go:304: ran create external connection changefeed_test.go:1169: st_geogfromgeojson(): error parsing GeoJSON: geojson: unsupported type: --- FAIL: TestChangefeedRandomExpressions/kafka (10.85s)

cockroachdb / cockroach

ccl/changefeedccl: TestChangefeedRandomExpressions failed #133049