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.2k stars 3.82k forks source link

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 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 47 events testfeed_test.go:284: creating external connection testfeed_test.go:287: ran create external connection 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 testfeed_test.go:284: creating external connection testfeed_test.go:287: ran create external connection changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._bool AND EXISTS (SELECT NULL AS col_43, 1.0116244554519653:::FLOAT8 AS "!co\nl-_44" FROM d.public.seed AS tab_17 WHERE seed._bool)) changefeed_test.go:1124: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (seed._bool AND EXISTS (SELECT NULL AS col_43, 1.0116244554519653:::FLOAT8 AS "!co\nl-_44" FROM d.public.seed AS tab_17 WHERE seed._bool)) to emit 47 events testfeed_test.go:284: creating external connection testfeed_test.go:287: ran create external connection 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 (true OR (NULL::INET << '169.181.105.36/2':::INET::INET)::BOOL) changefeed_test.go:1124: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (true OR (NULL::INET << '169.181.105.36/2':::INET::INET)::BOOL) to emit 100 events testfeed_test.go:284: creating external connection testfeed_test.go:287: ran create external connection changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT COALESCE(COALESCE(B'010000100110110000110110000001010111001', B'100111001000010110111110100001101111111'), B'101110100001011000000001111111101101110') AS col_57, B'110010' AS col_58, '1993-03-21 19:17:41.00049+00':::TIMESTAMPTZ AS col_59) changefeed_test.go:1124: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE EXISTS (SELECT COALESCE(COALESCE(B'010000100110110000110110000001010111001', B'100111001000010110111110100001101111111'), B'101110100001011000000001111111101101110') AS col_57, B'110010' AS col_58, '1993-03-21 19:17:41.00049+00':::TIMESTAMPTZ AS col_59) to emit 100 events testfeed_test.go:284: creating external connection testfeed_test.go:287: ran create external connection 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 3190346967:::OID::OID NOT IN (seed.tableoid,) changefeed_test.go:1124: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE 3190346967:::OID::OID NOT IN (seed.tableoid,) to emit 100 events testfeed_test.go:284: creating external connection testfeed_test.go:287: ran create external connection changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (e'\U00002603':::STRING::STRING % (NULL::STRING || NULL::OID)::STRING::STRING)::BOOL changefeed_test.go:1120: Skipping predicate (e'\U00002603':::STRING::STRING % (NULL::STRING || NULL::OID)::STRING::STRING)::BOOL because it returned no rows changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (NOT seed._bool) changefeed_test.go:1124: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (NOT seed._bool) to emit 45 events testfeed_test.go:284: creating external connection testfeed_test.go:287: ran create external connection changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE e'``A\r\x03U(':::REFCURSOR::REFCURSOR NOT IN (SELECT COALESCE('38':::REFCURSOR, e'q\x1dqwm\x1c9\x05':::REFCURSOR)::REFCURSOR AS col_124 FROM d.public.seed AS tab_48 JOIN d.public.seed AS tab_49 ON (tab_48._jsonb) = (tab_49._jsonb) ORDER BY seed._jsonb ASC) changefeed_test.go:1113: Skipping query SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE e'``A\r\x03U(':::REFCURSOR::REFCURSOR NOT IN (SELECT COALESCE('38':::REFCURSOR, e'q\x1dqwm\x1c9\x05':::REFCURSOR)::REFCURSOR AS col_124 FROM d.public.seed AS tab_48 JOIN d.public.seed AS tab_49 ON (tab_48._jsonb) = (tab_49._jsonb) ORDER BY seed._jsonb ASC) because error pq: unsupported comparison operator: refcursor NOT IN tuple{refcursor} changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE bool(NULL::JSONB)::BOOL changefeed_test.go:1120: Skipping predicate bool(NULL::JSONB)::BOOL because it returned no rows changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._string::STRING % NULL::STRING)::BOOL changefeed_test.go:1120: Skipping predicate (seed._string::STRING % NULL::STRING)::BOOL because it returned no rows changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._jsonb::JSONB#>>ARRAY[e'\x1a6v\bKu2P':::STRING, 'v':::STRING]::STRING[])::STRING ~* seed._string changefeed_test.go:1120: Skipping predicate (seed._jsonb::JSONB#>>ARRAY[e'\x1a6v\bKu2P':::STRING, 'v':::STRING]::STRING[])::STRING ~* seed._string because it returned no rows changefeed_test.go:1108: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE ((seed._bool OR (NOT true)) AND (seed._bool OR st_dwithin(seed._string::STRING, e'x\x1b\b7i<\x01':::STRING::STRING, seed._float4::FLOAT8)::BOOL)) changefeed_test.go:1124: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE ((seed._bool OR (NOT true)) AND (seed._bool OR st_dwithin(seed._string::STRING, e'x\x1b\b7i<\x01':::STRING::STRING, seed._float4::FLOAT8)::BOOL)) to emit 47 events testfeed_test.go:284: creating external connection testfeed_test.go:287: ran create external connection changefeed_test.go:1141: st_dwithin(): error parsing EWKT: syntax error: invalid keyword at line 1, pos 0 LINE 1: X ^ --- FAIL: TestChangefeedRandomExpressions/kafka (13.42s)

ccl/changefeedccl.TestChangefeedRandomExpressions failed on release-24.2 @ cf9b1574fd03c877cc831f4be41a5e12b1055a42:

        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-128):::INT8, (-128):::INT8, (-9223372036854775807):::INT8, (-1.1178467273712158):::FLOAT8, 0.20517385744524652:::FLOAT8, '1991-02-15':::DATE, '2032-08-23 22:40:41.000044':::TIMESTAMP, '2001-01-01 00:00:00+00 BC':::TIMESTAMPTZ, '-11 years -5 mons -622 days -21:13:25.146627':::INTERVAL, false, 'NaN':::DECIMAL, e'\U00002603':::STRING, '\xff':::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 (NULL, 1:::INT8, (-3181117012003483254):::INT8, 0.36369791626930237:::FLOAT8, '+Inf':::FLOAT8, '1982-06-08':::DATE, '1972-03-28 19:53:46.000953':::TIMESTAMP, '1984-08-31 22:10:14.000581+00':::TIMESTAMPTZ, '11 years 7 mons 841 days 24:00:32.788445':::INTERVAL, true, (-57.08614982402418440):::DECIMAL, 'P':::STRING, '\x097f81eff472d0':::BYTES, 'bd3fad64-c489-4591-86f8-b98f1e8b6057':::UUID, '71.134.102.125/22':::INET, '[["4vX9Gt", 1.3375246716605822], true, false]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (127:::INT8, 2147483647:::INT8, 2147483647:::INT8, NULL, NULL, NULL, '2004-11-21 22:49:00.000227':::TIMESTAMP, '1976-10-12 02:18:09.000241+00':::TIMESTAMPTZ, '1 day':::INTERVAL, false, 1:::DECIMAL, '':::STRING, '\x':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, '0.0.0.0/0':::INET, '{"CxFWmDv64": false, "EE9x": {"c": 0.4851028859104318, "foobar": false}, "c": [{"foo": null, "foobar": "AKKc58MKx"}, "foo", null, null], "qi26n0idC": true}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (8464:::INT8, 995227180:::INT8, (-32768):::INT8, '+Inf':::FLOAT8, (-0.0):::FLOAT8, 'infinity':::DATE, '3000-01-01 00:00:00':::TIMESTAMP, '2002-12-28 14:05:09.000688+00':::TIMESTAMPTZ, '50 years 1 mon 663 days 07:38:57.392288':::INTERVAL, false, NULL, e'Rb\x02\x1c\x06m":1':::STRING, '\x22':::BYTES, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, '141.58.112.132/7':::INET, '{}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (NULL, 127:::INT8, 8193742568345780169:::INT8, 3.4028234663852886e+38:::FLOAT8, NULL, '1970-01-01':::DATE, '2001-01-01 00:00:00 BC':::TIMESTAMP, '1976-08-31 09:03:01.000528+00':::TIMESTAMPTZ, '1 day':::INTERVAL, true, (-1.0):::DECIMAL, e'H(\x03Q!~)]':::STRING, '\xb1a70782b3':::BYTES, '59e1a145-d9b0-4541-875d-61eb23b4edf1':::UUID, '126.246.70.197/12':::INET, '[{"GwJG": [null, "Fd"], "SVuUhV": ["b", false], "b": 3.655514390929954, "c": [[null], null], "foo": 1.0159591191518822}, false]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (0:::INT8, (-32768):::INT8, (-2147483648):::INT8, 1.401298464324817e-45:::FLOAT8, (-0.0):::FLOAT8, '1978-06-28':::DATE, '0001-01-01 00:00:00':::TIMESTAMP, '2002-07-01 14:48:00.000927+00':::TIMESTAMPTZ, '00:00:00':::INTERVAL, true, 3898837975.811051543:::DECIMAL, e'\'':::STRING, '\xfce845':::BYTES, 'a375dc62-ef0e-49c5-8c92-1fe6c73ba99f':::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 ((-1):::INT8, 1638127336:::INT8, (-1764915577441693433):::INT8, '+Inf':::FLOAT8, (-0.6575479175738757):::FLOAT8, 'infinity':::DATE, '2023-08-31 00:01:21.000968':::TIMESTAMP, '294276-12-31 23:59:59.999999+00':::TIMESTAMPTZ, '1 mon 1 day':::INTERVAL, false, 0.0100071966478026997:::DECIMAL, '"':::STRING, '\x58':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '[true, true]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (30054:::INT8, NULL, 1:::INT8, 0.27150943875312805:::FLOAT8, (-1.0):::FLOAT8, '5874897-12-31':::DATE, '2025-05-18 07:57:34.000806':::TIMESTAMP, '4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ, '21 years 6 mons 660 days 23:06:46.334853':::INTERVAL, false, (-1.0):::DECIMAL, 'X':::STRING, NULL, '00000000-0000-0000-0000-000000000000':::UUID, NULL, '{"72m0": true, "b": 0.022702053885223103, "xb": {"BIN0F906": 0.6379099754015449, "VsZx5": ["foobar"], "foo": [[null], 1.3789365319068734], "v9dr7": "j5thCdc"}}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (NULL, (-150042980):::INT8, 5672166151617532920:::INT8, 0.0:::FLOAT8, 1.401298464324817e-45:::FLOAT8, '-infinity':::DATE, '2000-09-17 22:09:44.000978':::TIMESTAMP, '3000-01-01 00:00:00+00':::TIMESTAMPTZ, '00:00:00':::INTERVAL, true, 'Infinity':::DECIMAL, e',\x0f8\x11tE] n':::STRING, '\xff':::BYTES, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '[{"NKmXg": null, "a": {"SSYGElbI5": [true], "Zpsc": false, "bar": "QeNV1M1", "foobar": {"ek": null, "foobar": null}}, "foo": "NrEMaV"}, [true], false]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (1:::INT8, (-584432228):::INT8, 32767:::INT8, (-1.0):::FLOAT8, (-0.9566877117348069):::FLOAT8, '4714-11-24 BC':::DATE, '1991-01-09 02:22:57.000424':::TIMESTAMP, '2018-02-24 13:45:29.000385+00':::TIMESTAMPTZ, NULL, NULL, 1.0:::DECIMAL, e'05K7\x1f\x14\\':::STRING, '\x1a03b78969954b35':::BYTES, NULL, '7e88:5d80:8001:32de:9efa:5344:32d:49c9/125':::INET, '[["b", {"iwDGcZ": "b"}, null], {"2gT3": "Og", "foobar": 0.4815055958467336}, {"c": false}, 0.6005646382620109, 0.21477035655903923, null]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (5151:::INT8, (-126800145):::INT8, (-2147483648):::INT8, 1.401298464324817e-45:::FLOAT8, 0.10461488803721386:::FLOAT8, 'infinity':::DATE, '2015-09-04 17:11:24.00066':::TIMESTAMP, '2001-01-01 00:00:00+00 BC':::TIMESTAMPTZ, '1 mon 1 day':::INTERVAL, false, 1.0:::DECIMAL, 'X':::STRING, '\x22':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '{"K6rnXQV2t": false, "LWYCum": ["a", true], "baz": false, "dh": [null]}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (0:::INT8, (-2147483648):::INT8, (-2083184310787578713):::INT8, 3.4028234663852886e+38:::FLOAT8, 1.7036892526774938:::FLOAT8, '1987-01-04':::DATE, '294276-12-31 23:59:59.999999':::TIMESTAMP, '3000-01-01 00:00:00+00':::TIMESTAMPTZ, '290 years':::INTERVAL, false, 7.218299094614043388E+36:::DECIMAL, '.':::STRING, '\x22':::BYTES, '4ff3dce7-d651-4be7-a91c-e881081cda67':::UUID, '0.0.0.0/0':::INET, '[{"36J6dMU": null, "SLW55": [false, true]}, {"nDL1": true}, null, true]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-32768):::INT8, (-1):::INT8, (-7650126791322174951):::INT8, 0.9347965717315674:::FLOAT8, (-1.0):::FLOAT8, '1972-03-08':::DATE, '0001-01-01 00:00:00':::TIMESTAMP, '1978-04-03 00:23:30.000427+00':::TIMESTAMPTZ, '1 day':::INTERVAL, false, (-25552076364677.58335):::DECIMAL, '9++5':::STRING, '\x':::BYTES, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::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 (29819:::INT8, (-128):::INT8, 32767:::INT8, 3.4028234663852886e+38:::FLOAT8, '-Inf':::FLOAT8, '-infinity':::DATE, '2015-09-10 02:26:03.000333':::TIMESTAMP, '3000-01-01 00:00:00+00':::TIMESTAMPTZ, '1 day':::INTERVAL, false, NULL, e'\U00002603':::STRING, '\x2569b7b2':::BYTES, NULL, '117.185.222.135/27':::INET, '{}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (10637:::INT8, 786829385:::INT8, (-1513941295516307528):::INT8, 0.12267662584781647:::FLOAT8, 3.4028234663852886e+38:::FLOAT8, '1971-08-09':::DATE, NULL, '3000-01-01 00:00:00+00':::TIMESTAMPTZ, '1 day':::INTERVAL, true, 'NaN':::DECIMAL, '?!``e':::STRING, '\xf52c':::BYTES, '2de5699e-9596-4a35-94df-8a80fc4aa050':::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 ((-12622):::INT8, (-1190094663):::INT8, NULL, 0.8636864423751831:::FLOAT8, NULL, '-infinity':::DATE, '1995-02-02 23:52:17.000637':::TIMESTAMP, '1994-10-25 22:09:30.000619+00':::TIMESTAMPTZ, '32 years 3 mons 538 days 24:43:35.188619':::INTERVAL, true, (-1.234E+401):::DECIMAL, 'F;nT':::STRING, '\x00':::BYTES, '68489765-3e4b-48c9-8c44-3a62b6a5953b':::UUID, '66.88.94.71/28':::INET, '{"b": [{"P5qJ83IS": [{"smOF3Ik6F": 0.08899346199320288}, true], "UspkS": null, "foobar": null}, {"M2AjF": {"a": false}, "b": [0.16398162424396356, true], "foo": true, "jFe2RcA": null}, {"2l2HQ": {"OnHxs": null}, "b": "GL69hUZiG", "baz": null, "c": "a"}, 0.4048445834009261, null], "baz": {"foo": null}, "foo": null, "foobar": false}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-31402):::INT8, (-837609171):::INT8, (-2147483648):::INT8, '-Inf':::FLOAT8, 1.401298464324817e-45:::FLOAT8, '1970-01-01':::DATE, '1999-04-15 12:56:59.000208':::TIMESTAMP, '2014-06-13 17:29:16.000201+00':::TIMESTAMPTZ, '1 mon 1 day':::INTERVAL, true, (-1.234E+401):::DECIMAL, e'Dc\f':::STRING, '\xff':::BYTES, '00000000-0000-0000-0000-000000000000':::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 (32767:::INT8, NULL, 7983150356853453135:::INT8, 0.27557364106178284:::FLOAT8, (-1.0):::FLOAT8, '1973-01-28':::DATE, '294276-12-31 23:59:59.999999':::TIMESTAMP, '294276-12-31 23:59:59.999999+00':::TIMESTAMPTZ, '8 years 7 mons 840 days 01:22:06.809496':::INTERVAL, true, (-3.896268005760827816E+36):::DECIMAL, 'X':::STRING, '\xff':::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 (6155:::INT8, 740182208:::INT8, NULL, 0.5969445705413818:::FLOAT8, 1.401298464324817e-45:::FLOAT8, '-infinity':::DATE, NULL, '2001-09-08 21:07:17.000281+00':::TIMESTAMPTZ, NULL, true, 'NaN':::DECIMAL, e'v<k!j+\x1d)3':::STRING, '\x6e418121':::BYTES, '25ecff8d-af20-48e8-a69a-7f2c88964fb7':::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 ((-16038):::INT8, (-32768):::INT8, NULL, (-1.1741172075271606):::FLOAT8, 0.5598348991629932:::FLOAT8, '1990-04-09':::DATE, NULL, '2032-06-07 16:39:13.00095+00':::TIMESTAMPTZ, '1 mon 1 day':::INTERVAL, true, (-4.739406679585963311E+21):::DECIMAL, 'cmx*':::STRING, '\x22':::BYTES, '3d7691b6-2803-4105-9add-0649301c0766':::UUID, '0.0.0.0/0':::INET, '{"R7UDZtg": true, "b": false}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (1:::INT8, (-199403019):::INT8, 7720897761218573318:::INT8, 0.9968155026435852:::FLOAT8, (-1.6911371336938918):::FLOAT8, '1975-10-29':::DATE, '3000-01-01 00:00:00':::TIMESTAMP, '2002-05-14 14:33:18.000237+00':::TIMESTAMPTZ, '1 day':::INTERVAL, true, (-4838237108240818446):::DECIMAL, '':::STRING, '\x58':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, '81e9:187a:9569:29ae:26a4:6708:5385:72fa/68':::INET, '[{"Cuhkqw": 0.4020442349393638, "a": {"bar": false, "fph": true}, "foo": null, "tXF6sV": null}, null, "c"]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (27220:::INT8, 1395390868:::INT8, 1585314851667865344:::INT8, 0.0:::FLOAT8, 0.4151758005306677:::FLOAT8, '1987-07-20':::DATE, '3000-01-01 00:00:00':::TIMESTAMP, '2001-01-01 00:00:00+00 BC':::TIMESTAMPTZ, '-52 years -7 mons -713 days -13:27:55.181537':::INTERVAL, true, (-4.326194188732722636E+29):::DECIMAL, e'{\x10Ip':::STRING, '\x00':::BYTES, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::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 (1:::INT8, (-1):::INT8, (-9223372036854775807):::INT8, '+Inf':::FLOAT8, 0.3154137254916474:::FLOAT8, '1970-01-01':::DATE, '2001-01-01 00:00:00 BC':::TIMESTAMP, NULL, '00:00:00':::INTERVAL, false, 'NaN':::DECIMAL, e'\U00002603':::STRING, '\x3c901090':::BYTES, '143ba0c8-25f6-42cb-9090-e922bf4e8f39':::UUID, '0.0.0.0/0':::INET, '[{"4gZWkTt3": true, "foo": "a"}, {"4Biux5L": "RvAYX", "7yPNKA": null, "foo": null}, {"Oy7P": 0.8605060267298319, "c": "3seedBx"}, null]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-1):::INT8, 127:::INT8, 2733829694755026648:::INT8, 2.55631422996521:::FLOAT8, 0.050361353129437306:::FLOAT8, '1977-02-07':::DATE, '1983-05-09 09:28:00.000595':::TIMESTAMP, '1979-02-07 16:55:32.000248+00':::TIMESTAMPTZ, '79 years 5 mons 211 days 02:42:54.432639':::INTERVAL, false, (-7.696536787623746542E+31):::DECIMAL, '':::STRING, '\xd73a06':::BYTES, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, '0.0.0.0/0':::INET, NULL);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (32767:::INT8, (-32768):::INT8, 0:::INT8, (-0.6461538672447205):::FLOAT8, (-0.5997539783162784):::FLOAT8, '-infinity':::DATE, '2005-03-10 18:22:38.000343':::TIMESTAMP, '2007-04-19 09:27:47.000119+00':::TIMESTAMPTZ, '19 years 3 mons 617 days 17:11:03.39145':::INTERVAL, true, NULL, e'\x1e\x7fK6;':::STRING, '\x347759b392e8aa29':::BYTES, NULL, '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 (1:::INT8, (-2075685000):::INT8, 1435260325108140427:::INT8, (-0.0):::FLOAT8, 1.8512712782045389:::FLOAT8, '1970-01-01':::DATE, '1998-12-17 09:21:40.000669':::TIMESTAMP, '0001-01-01 00:00:00+00':::TIMESTAMPTZ, '17 years 516 days 05:54:58.146813':::INTERVAL, false, (-1):::DECIMAL, e'?0l},\x14\x15':::STRING, '\xe29883':::BYTES, NULL, '124.214.161.106/13':::INET, '{"test": "json"}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (0:::INT8, 765496829:::INT8, (-9223372036854775807):::INT8, 3.4028234663852886e+38:::FLOAT8, 'NaN':::FLOAT8, '-infinity':::DATE, '4714-11-24 00:00:00 BC':::TIMESTAMP, '4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ, '-41 years -7 mons -183 days -02:39:36.390706':::INTERVAL, true, 'NaN':::DECIMAL, e'\x7fiw\x06]k.':::STRING, '\x9242f021':::BYTES, '6d20a22c-0a70-46da-b089-c31122b2452d':::UUID, '2743:8c6e:3a67:f951:b306:bf28:c300:acd4/49':::INET, '[[{"X2lN9SZQ": false, "b6JWZ": true}, 0.32166509939446364], [[null], true, false], null, {"foobar": null, "z17kx": null}, false, "fiw6g"]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-19421):::INT8, (-2147483648):::INT8, 7996853851207316369:::INT8, '+Inf':::FLOAT8, '+Inf':::FLOAT8, '1978-05-14':::DATE, '3000-01-01 00:00:00':::TIMESTAMP, '0001-01-01 00:00:00+00':::TIMESTAMPTZ, '00:00:00':::INTERVAL, false, 7.852486162514165767E+30:::DECIMAL, e'\x1fu){HT':::STRING, '\xff':::BYTES, '7a1a74ca-dfd4-45b0-af86-a5ae92dbf408':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '{"HeFw49Oik": "bar", "L7OZtCO": "b", "Wz7Gyo": true, "c": [true], "cb80B": null}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (1026:::INT8, (-1017753768):::INT8, 5078887038974696351:::INT8, 1.2322998046875:::FLOAT8, 1.401298464324817e-45:::FLOAT8, 'infinity':::DATE, '2021-12-26 16:22:03.000422':::TIMESTAMP, NULL, '-64 years -8 mons -740 days -06:04:04.574844':::INTERVAL, false, (-8.359693087871472033E+33):::DECIMAL, '}KIcDk':::STRING, '\xff':::BYTES, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, '0.0.0.0/0':::INET, '[{"3OOP": "c", "bar": [["6CA62R", "wYSvIgb2"], ["c"], true], "foobar": {"DCGa": "a"}}, 0.8396725148715894, [false, "c", true], true, false]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (32767:::INT8, (-435739202):::INT8, 2147483647:::INT8, '-Inf':::FLOAT8, 0.6706529962662452:::FLOAT8, '1979-10-16':::DATE, '1998-09-19 11:22:59.000504':::TIMESTAMP, '0001-01-01 00:00:00+00':::TIMESTAMPTZ, '00:00:00':::INTERVAL, true, 5.816116142256826590E+21:::DECIMAL, '':::STRING, '\x27':::BYTES, '604192d1-228c-41fc-ac5f-34c30f13e5b2':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '{"1hDBmi": "2hcVQ", "MhkRu3": null, "pZDaLot": 0.21431860034050815, "zUR": false}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-791):::INT8, 0:::INT8, 5733161342584154066:::INT8, 1.0:::FLOAT8, (-0.8022463214209823):::FLOAT8, '1992-04-15':::DATE, '1972-09-29 12:48:55.000906':::TIMESTAMP, '0001-01-01 00:00:00+00':::TIMESTAMPTZ, '-13 years -729 days -10:51:02.600205':::INTERVAL, true, 0:::DECIMAL, '':::STRING, '\xdf3e':::BYTES, '33cecf05-4d68-4778-8029-a8fcedac18ec':::UUID, '203.53.112.164/5':::INET, '{"b": [0.2036761890437376, false], "baz": {"bar": 1.0024569245494683, "foobar": null}, "skiP": "foobar"}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (1:::INT8, 1823096107:::INT8, (-468415744613755335):::INT8, '-Inf':::FLOAT8, '+Inf':::FLOAT8, '1971-03-23':::DATE, '294276-12-31 23:59:59.999999':::TIMESTAMP, '3000-01-01 00:00:00+00':::TIMESTAMPTZ, '-13 years -10 mons -738 days -24:56:06.825708':::INTERVAL, true, NULL, e'\'':::STRING, '\x33a108a2f0dba30c':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, '20e7:54b7:149e:9b3:4034:4d96:a251:9e06/125':::INET, '{"5ag6zYe23": {"Kwq": false, "a": null}, "a": {"bar": false}, "baz": 0.36686007758946193, "c": false}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (1:::INT8, 320134193:::INT8, (-1):::INT8, '+Inf':::FLOAT8, 0.18573171694951118:::FLOAT8, '1975-05-13':::DATE, '1996-06-19 08:30:55.00005':::TIMESTAMP, '2007-05-23 22:04:40.000165+00':::TIMESTAMPTZ, '1 day':::INTERVAL, false, 'Infinity':::DECIMAL, '"':::STRING, '\x58':::BYTES, 'ffffffff-ffff-ffff-ffff-ffffffffffff':::UUID, '166.176.141.162/22':::INET, '1':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-32693):::INT8, 117652143:::INT8, 32767:::INT8, (-0.36993882060050964):::FLOAT8, 1.0:::FLOAT8, '-infinity':::DATE, '3000-01-01 00:00:00':::TIMESTAMP, '2012-07-07 04:53:44.000194+00':::TIMESTAMPTZ, '290 years':::INTERVAL, false, '-Infinity':::DECIMAL, '"':::STRING, '\xaa83f683e467':::BYTES, '193d132d-47f2-4eac-bba9-df583a499a6e':::UUID, '606c:ffb6:658b:e449:f15e:a401:d33d:76e0/60':::INET, NULL);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-32768):::INT8, (-1):::INT8, (-2122256452952536559):::INT8, (-1.5576398372650146):::FLOAT8, NULL, '1990-02-09':::DATE, '0001-01-01 00:00:00':::TIMESTAMP, '4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ, '50 years 11 mons 264 days 07:51:18.905381':::INTERVAL, true, (-7.888680779412881339E+21):::DECIMAL, e'\U00002603':::STRING, '\x27':::BYTES, 'da5e0789-ae0c-4633-943b-bbb36c22a0d6':::UUID, '56.216.214.10/8':::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, 0:::INT8, '+Inf':::FLOAT8, (-0.3847998151358543):::FLOAT8, '1970-01-01':::DATE, '4714-11-24 00:00:00 BC':::TIMESTAMP, '4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ, NULL, true, 0:::DECIMAL, e'&*h\x1f ':::STRING, '\x5b2b':::BYTES, '6cd44846-a9ea-4b52-9510-269ac3d22d76':::UUID, '6.227.139.56/0':::INET, '{"h72s": "CQJTwkkM", "omlHwiQh": {"a": null}, "qWP2ni930": {"foo": true, "yAR4vSeaM": [[false], "qEbRok"]}}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (0:::INT8, (-1):::INT8, (-9223372036854775807):::INT8, 'NaN':::FLOAT8, (-0.914255815526224):::FLOAT8, 'infinity':::DATE, '294276-12-31 23:59:59.999999':::TIMESTAMP, '4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ, '-39 years -5 mons -62 days -07:36:35.821991':::INTERVAL, NULL, 0:::DECIMAL, e'\x10\x1b``\x01Jo':::STRING, NULL, 'e783008b-fba1-4c79-b763-a4be32e4a78c':::UUID, '22.190.98.149/14':::INET, '[0.15009158831063457, "L7kuOIQe", "c"]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (7041:::INT8, 733991567:::INT8, 0:::INT8, '+Inf':::FLOAT8, 0.2471833859215114:::FLOAT8, '1973-04-25':::DATE, NULL, '3000-01-01 00:00:00+00':::TIMESTAMPTZ, '5 years 5 mons 756 days 13:20:48.580295':::INTERVAL, true, 1.0:::DECIMAL, e'\x00':::STRING, '\x':::BYTES, 'ce88ad66-1ea0-43da-bfa0-1ed6a1882478':::UUID, NULL, '[["b"], [{"X6iK": null, "c": false}, true, true], [{"8glNIT": "lZn3FAhq", "baz": true, "lMhZ": true}, "baz", "lQEZMD4"], {"7g": false}, [[false], true, false], true, 0.3973222634453468]':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (14799:::INT8, 1909701992:::INT8, (-1469743055813516609):::INT8, 1.0:::FLOAT8, 1.0178894253573145:::FLOAT8, '1993-04-24':::DATE, NULL, '4714-11-24 00:00:00+00 BC':::TIMESTAMPTZ, '00:00:00':::INTERVAL, false, NULL, e'\x06ZLl\r+R\x01':::STRING, '\x':::BYTES, '5fcafe9f-438a-4977-958c-e71713db8086':::UUID, '6a19:19be:6d7e:cbac:fcb8:4f30:94c2:5cf/6':::INET, '[false, false, "foobar", false]':::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, 3442488136725359329:::INT8, (-0.41793251037597656):::FLOAT8, 0.8985558484548929:::FLOAT8, 'infinity':::DATE, '2023-02-21 12:40:48.000047':::TIMESTAMP, '294276-12-31 23:59:59.999999+00':::TIMESTAMPTZ, '00:00:00':::INTERVAL, true, (-7688035352.965105896):::DECIMAL, '':::STRING, '\xff':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, '157.2.54.173/6':::INET, '{"test": "json"}':::JSONB);
        INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-23438):::INT8, (-275985190):::INT8, NULL, '-Inf':::FLOAT8, NULL, '1993-03-19':::DATE, '294276-12-31 23:59:59.999999':::TIMESTAMP, '1981-05-12 09:30:52.000969+00':::TIMESTAMPTZ, '00:00:00':::INTERVAL, true, 854145472699781508.5:::DECIMAL, e'L\x12\x10P6{N':::STRING, '\x27':::BYTES, '6f758ad5-2f51-435e-9454-c4f07c686732':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '[[{"QaSPCKP9": "xv", "b": [1.1215405060091503], "p3ZhOjb": "kl4g"}, {"5rEOcQf": false}, null, null], {"8MqMcav": null, "a": 0.4386762578773822, "pt": "SBNKFjPm"}, {"6tju": {"foo": false}, "c": null, "yMA": "wBt"}, 0.25734622138408303]':::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:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._bool AND (e'Y6Ctbr\x17(':::STRING NOT LIKE seed._string))
    changefeed_test.go:1122: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (seed._bool AND (e'Y6Ctbr\x17(':::STRING NOT LIKE seed._string)) to emit 39 events
    testfeed_test.go:301: creating external connection
    testfeed_test.go:304: ran create external connection
    changefeed_test.go:1139: LIKE regexp compilation failed: LIKE pattern must not end with escape character
    --- FAIL: TestChangefeedRandomExpressions/kafka (2.13s)

Parameters:

attempt=1
run=14
shard=10
Help

Same failure on other branches

- #132516 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot T-cdc branch-release-23.2.13-rc] - #131898 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot T-cdc X-duplicate branch-release-24.1.6-rc release-blocker] - #131179 ccl/changefeedccl: TestChangefeedRandomExpressions failed [A-cdc C-test-failure O-robot T-cdc branch-release-24.1.5-rc release-blocker] - #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] - #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 ((-17913):::INT8, 0:::INT8, (-1):::INT8, '+Inf':::FLOAT8, '-Inf':::FLOAT8, '1970-01-01':::DATE, '3000-01-01 00:00:00':::TIMESTAMP, '3000-01-01 00:00:00+00':::TIMESTAMPTZ, '32 years 9 mons 363 days 20:18:27.797161':::INTERVAL, false, (-851661234.051575749):::DECIMAL, e'\x1d26u\x14r\x16.':::STRING, '\xe2':::BYTES, '21079d41-11d3-41c7-8be2-3557c9540e88':::UUID, 'cda:3f53:718a:30b1:c56b:8dc5:2067:dc92/112':::INET, '{"8mcgHOO2": {"TFH": null, "foo": null}, "m1ZxI": 0.05409942102775554, "nMjFtwRUS": true}':::JSONB); INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES ((-12285):::INT8, (-2092253543):::INT8, (-7272765528053663403):::INT8, (-2.2815303802490234):::FLOAT8, 5e-324:::FLOAT8, '1986-10-06':::DATE, '2009-01-03 01:01:21.000832':::TIMESTAMP, '1980-06-15 15:20:12.000493+00':::TIMESTAMPTZ, '-44 years -9 mons -330 days -22:23:50.361654':::INTERVAL, false, 6.270991640442899201E+26:::DECIMAL, '"':::STRING, '\xe29883':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '[{"Fnq": true, "YoMV5gtDN": false, "bar": {"b": false}}, [true], false]':::JSONB); INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (127:::INT8, (-1734898577):::INT8, 3276892269191456911:::INT8, 3.3560431003570557:::FLOAT8, 3.4028234663852886e+38:::FLOAT8, '1992-10-23':::DATE, '294276-12-31 23:59:59.999999':::TIMESTAMP, '0001-01-01 00:00:00+00':::TIMESTAMPTZ, '74 years 450 days 17:46:26.001992':::INTERVAL, NULL, 1:::DECIMAL, e'o\x07W8``>[':::STRING, '\xc412':::BYTES, 'a611df8e-e4e0-4d48-b4f9-9b6b488fc3bc':::UUID, '0.0.0.0/0':::INET, '{"2U": {"bar": false, "f2fEO3DZk": "9sDQUGUU"}, "7Q97mJ": {"fTB": null, "foo": false}, "zzNHGnguw": 2.0705682049539362}':::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:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE true changefeed_test.go:1122: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE true to emit 100 events changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE e'\n@t':::STRING ~ e'\x1b/ZN':::STRING changefeed_test.go:1118: Skipping predicate e'\n@t':::STRING ~ e'\x1b/ZN':::STRING because it returned no rows changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE seed._bool changefeed_test.go:1122: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE seed._bool to emit 45 events changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE st_dwithinexclusive(NULL::GEOGRAPHY, '0105000020E610000001000000010200000008000000D448242D353353C08D0E00EF0EA545C040D9F07B880128C08522BECDC28F53C0E0C816E8445C1440108E99F211021A400069C3CB10750EC0E8D76A7534B32740904FB87C83C75840FCE56D17F7534340AAF19748B3E84FC0C04F9EFA05144C40ACDB7651E9C851C094987F658D214F400E7E8D6622FA52C0ACBF39A4E2B55040':::GEOGRAPHY::GEOGRAPHY, (-0.4976620116579353):::FLOAT8::FLOAT8)::BOOL::BOOL IN (SELECT false::BOOL AS col_38 FROM d.public.seed AS "t}%pa B_15" WHERE st_rotate('0101000080000000000000F87F000000000000F87F000000000000F87F':::GEOMETRY::GEOMETRY, seed._float8::FLOAT8, seed._float4::FLOAT8, random()::FLOAT8::FLOAT8)::GEOMETRY::GEOMETRY IN (NULL, st_simplifypreservetopology('01010000C0000000000000F87F000000000000F87F000000000000F87F000000000000F87F':::GEOMETRY::GEOMETRY, 1.0993304227934484:::FLOAT8::FLOAT8)::GEOMETRY, '01040000400200000001010000400216B88F3179FAC160DA513B3E1DF1416235E69878A4F641010100004029AC1BF8EF58F9C162AFD639BA09F0C1A6A26FBF56F7E7C1':::GEOMETRY, '01050000000500000001020000000200000000DE27F6EEC58141B60D49695C94F0410C79602D3CE6F6C1C479CE70CE6BEB4101020000000600000064C740005734EB412E281907F7A4EFC19A399AE460BAF441807787EA4E3ECDC12C1F3C52C0BE0042BC8A2DEEA655E241AEF4667E8E340242600034380C90F0415E8DDD94543EF741DE93094D1CE30042EE729BC8EBECF041E64F77DEC3D601420102000000030000002063D9A89F670242C46AA3834701FE41101567865AAE004210E31273F1D9014264ACD5430023F241B80858CA99AFFB41010200000007000000CE1FE1E80744E4C16C1C4D41B105F5C1E4A0F05D552DDCC19A423100B71DFFC19CEF1D7FE53BF0414B4826848DEEF0C16EEFD96B07EAF74100A357A0E9DCC4C1D43DE164FCA0F7414005034FBF10F741D02255548B50D3C1AC3446E99593EA41965B748B4C23EFC10039E7311F7BBCC1010200000004000000A2542BF9B6C9EEC1D24EEC5C15A9FFC1D0F32274D58FFD41918201B18382FFC1C62E68E09E5B02428657910AE8AFF7C17407B682FCE001424456A7C32F1DF0C1':::GEOMETRY) ORDER BY seed._timestamp DESC) changefeed_test.go:1118: Skipping predicate st_dwithinexclusive(NULL::GEOGRAPHY, '0105000020E610000001000000010200000008000000D448242D353353C08D0E00EF0EA545C040D9F07B880128C08522BECDC28F53C0E0C816E8445C1440108E99F211021A400069C3CB10750EC0E8D76A7534B32740904FB87C83C75840FCE56D17F7534340AAF19748B3E84FC0C04F9EFA05144C40ACDB7651E9C851C094987F658D214F400E7E8D6622FA52C0ACBF39A4E2B55040':::GEOGRAPHY::GEOGRAPHY, (-0.4976620116579353):::FLOAT8::FLOAT8)::BOOL::BOOL IN (SELECT false::BOOL AS col_38 FROM d.public.seed AS "t}%pa B_15" WHERE st_rotate('0101000080000000000000F87F000000000000F87F000000000000F87F':::GEOMETRY::GEOMETRY, seed._float8::FLOAT8, seed._float4::FLOAT8, random()::FLOAT8::FLOAT8)::GEOMETRY::GEOMETRY IN (NULL, st_simplifypreservetopology('01010000C0000000000000F87F000000000000F87F000000000000F87F000000000000F87F':::GEOMETRY::GEOMETRY, 1.0993304227934484:::FLOAT8::FLOAT8)::GEOMETRY, '01040000400200000001010000400216B88F3179FAC160DA513B3E1DF1416235E69878A4F641010100004029AC1BF8EF58F9C162AFD639BA09F0C1A6A26FBF56F7E7C1':::GEOMETRY, '01050000000500000001020000000200000000DE27F6EEC58141B60D49695C94F0410C79602D3CE6F6C1C479CE70CE6BEB4101020000000600000064C740005734EB412E281907F7A4EFC19A399AE460BAF441807787EA4E3ECDC12C1F3C52C0BE0042BC8A2DEEA655E241AEF4667E8E340242600034380C90F0415E8DDD94543EF741DE93094D1CE30042EE729BC8EBECF041E64F77DEC3D601420102000000030000002063D9A89F670242C46AA3834701FE41101567865AAE004210E31273F1D9014264ACD5430023F241B80858CA99AFFB41010200000007000000CE1FE1E80744E4C16C1C4D41B105F5C1E4A0F05D552DDCC19A423100B71DFFC19CEF1D7FE53BF0414B4826848DEEF0C16EEFD96B07EAF74100A357A0E9DCC4C1D43DE164FCA0F7414005034FBF10F741D02255548B50D3C1AC3446E99593EA41965B748B4C23EFC10039E7311F7BBCC1010200000004000000A2542BF9B6C9EEC1D24EEC5C15A9FFC1D0F32274D58FFD41918201B18382FFC1C62E68E09E5B02428657910AE8AFF7C17407B682FCE001424456A7C32F1DF0C1':::GEOMETRY) ORDER BY seed._timestamp DESC) because it returned no rows changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE e'\'':::STRING LIKE 'R':::STRING changefeed_test.go:1118: Skipping predicate e'\'':::STRING LIKE 'R':::STRING because it returned no rows changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE false changefeed_test.go:1118: Skipping predicate false because it returned no rows changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._string::STRING % seed._string::STRING)::BOOL changefeed_test.go:1122: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (seed._string::STRING % seed._string::STRING)::BOOL to emit 55 events changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (e'M&e~&s\x02E':::STRING::STRING % e'KY\x138I':::STRING::STRING)::BOOL changefeed_test.go:1118: Skipping predicate (e'M&e~&s\x02E':::STRING::STRING % e'KY\x138I':::STRING::STRING)::BOOL because it returned no rows changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE 2871784157:::OID::OID NOT IN (SELECT 1201910873:::OID::OID AS col_105 FROM d.public.seed AS tab_37 GROUP BY seed._inet HAVING seed._string ILIKE to_hex(seed._string::STRING)::STRING) changefeed_test.go:1122: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE 2871784157:::OID::OID NOT IN (SELECT 1201910873:::OID::OID AS col_105 FROM d.public.seed AS tab_37 GROUP BY seed._inet HAVING seed._string ILIKE to_hex(seed._string::STRING)::STRING) to emit 100 events changefeed_test.go:1125: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT NULL AS col_119 FROM (SELECT seed._jsonb AS "col _115", '[[false], true]':::JSONB AS col_116) AS tab_48 ("Col_117", "%col_118") JOIN d.public.seed AS tab_49 ON (tab_48."Col_117") = (tab_49._jsonb) WHERE (seed._inet::INET >> 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET::INET)::BOOL ORDER BY seed._timestamp, seed._interval DESC NULLS LAST) changefeed_test.go:1122: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE EXISTS (SELECT NULL AS col_119 FROM (SELECT seed._jsonb AS "col _115", '[[false], true]':::JSONB AS col_116) AS tab_48 ("Col_117", "%col_118") JOIN d.public.seed AS tab_49 ON (tab_48."Col_117") = (tab_49._jsonb) WHERE (seed._inet::INET >> 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET::INET)::BOOL ORDER BY seed._timestamp, seed._interval DESC NULLS LAST) to emit 1 events changefeed_test.go:1125: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE ('192.233.242.148/23':::INET::INET >> seed._inet::INET)::BOOL changefeed_test.go:1118: Skipping predicate ('192.233.242.148/23':::INET::INET >> seed._inet::INET)::BOOL because it returned no rows changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE seed._string NOT ILIKE seed._string changefeed_test.go:1118: Skipping predicate seed._string NOT ILIKE seed._string because it returned no rows changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE _st_dwithin('01060000C00100000001030000C0010000000500000006F6DF70ECA800C295A601F0A32D00C2C54E43C3F466FFC1CAC2F7D82EACF0415C0C35DA69AAFD413E50D02AA28EFDC1A07D73DBDA95B5C100E40587959EAA411A2561FB4E94F741587D4740CE0BD541928233A70D20F1C13E931AF0A224E1C198E91B455DCAF5411C7737896152F941909506BEE747DE412C7216351341E9C106F6DF70ECA800C295A601F0A32D00C2C54E43C3F466FFC1CAC2F7D82EACF041':::GEOMETRY::GEOMETRY, '01040000C000000000':::GEOMETRY::GEOMETRY, seed._float8::FLOAT8)::BOOL changefeed_test.go:1111: Skipping query SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE _st_dwithin('01060000C00100000001030000C0010000000500000006F6DF70ECA800C295A601F0A32D00C2C54E43C3F466FFC1CAC2F7D82EACF0415C0C35DA69AAFD413E50D02AA28EFDC1A07D73DBDA95B5C100E40587959EAA411A2561FB4E94F741587D4740CE0BD541928233A70D20F1C13E931AF0A224E1C198E91B455DCAF5411C7737896152F941909506BEE747DE412C7216351341E9C106F6DF70ECA800C295A601F0A32D00C2C54E43C3F466FFC1CAC2F7D82EACF041':::GEOMETRY::GEOMETRY, '01040000C000000000':::GEOMETRY::GEOMETRY, seed._float8::FLOAT8)::BOOL because error pq: _st_dwithin(): dwithin distance cannot be less than zero changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT 'BOX(0.2991436124149286 -1.0410392493020195,1.3989840542373333 1.5508971911034026)':::BOX2D AS col_193, e'\'':::REFCURSOR AS "%acc\\uF736ol_194" FROM d.public.seed AS "%qtab_82" GROUP BY seed._jsonb, seed._decimal, seed._inet HAVING (seed._bool OR false) ORDER BY seed._inet NULLS FIRST) changefeed_test.go:1122: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE EXISTS (SELECT 'BOX(0.2991436124149286 -1.0410392493020195,1.3989840542373333 1.5508971911034026)':::BOX2D AS col_193, e'\'':::REFCURSOR AS "%acc\\uF736ol_194" FROM d.public.seed AS "%qtab_82" GROUP BY seed._jsonb, seed._decimal, seed._inet HAVING (seed._bool OR false) ORDER BY seed._inet NULLS FIRST) to emit 45 events changefeed_test.go:1125: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._bool AND st_dwithin('0103000080010000000C00000080003AD32E0496C19E5F781C282FEDC1FF13E5A77221FEC18C185E1FD916E841BF64542A076B01C200690F169B8FC9C198E896E7D1A2EE411811CDDAAC68EDC1E4C1F57E288C0142C885164FAD33F341A6D82111E6DEEFC1282BBF442DE4D241B481605A053BF641082A3415E64AE0C124569FE96F70F041142D1C7EF017E141807A0F4DC9C4A6C12E523E1BE5C101427C1DA6620E9CE241E0FD52DF3672E04122ECCE09572CEAC1B02B98838362E841AC6C9CE863EEF8412241ACD5C718E7C1409EB9A1801ACCC130792AE1F4E1E74165A99424476FF4C1EA32BE5DB3F5FFC1944F8988411BFD41909AD5D2CBEBCCC19019C5A3A9AAF9C1600FFDD02956EE415028CB74947AC94180003AD32E0496C19E5F781C282FEDC1FF13E5A77221FEC1':::GEOMETRY::GEOMETRY, NULL::GEOMETRY, (-1.1964843589672296):::FLOAT8::FLOAT8)::BOOL) changefeed_test.go:1118: Skipping predicate (seed._bool AND st_dwithin('0103000080010000000C00000080003AD32E0496C19E5F781C282FEDC1FF13E5A77221FEC18C185E1FD916E841BF64542A076B01C200690F169B8FC9C198E896E7D1A2EE411811CDDAAC68EDC1E4C1F57E288C0142C885164FAD33F341A6D82111E6DEEFC1282BBF442DE4D241B481605A053BF641082A3415E64AE0C124569FE96F70F041142D1C7EF017E141807A0F4DC9C4A6C12E523E1BE5C101427C1DA6620E9CE241E0FD52DF3672E04122ECCE09572CEAC1B02B98838362E841AC6C9CE863EEF8412241ACD5C718E7C1409EB9A1801ACCC130792AE1F4E1E74165A99424476FF4C1EA32BE5DB3F5FFC1944F8988411BFD41909AD5D2CBEBCCC19019C5A3A9AAF9C1600FFDD02956EE415028CB74947AC94180003AD32E0496C19E5F781C282FEDC1FF13E5A77221FEC1':::GEOMETRY::GEOMETRY, NULL::GEOMETRY, (-1.1964843589672296):::FLOAT8::FLOAT8)::BOOL) because it returned no rows changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE NULL changefeed_test.go:1118: Skipping predicate NULL because it returned no rows changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT seed.col_239 AS col_240 FROM (SELECT 3974028594:::OID AS "co}😤l_228", (seed._timestamptz::TIMESTAMPTZ - seed._interval::INTERVAL)::TIMESTAMPTZ AS col_229, seed._interval AS "coL_230", seed._string AS "Col_231", (-64680159792400.00085):::DECIMAL AS col_232, (seed._bytes::BYTES || e'\\x6da8be5995d5294627':::BYTES::BYTES)::BYTES AS "c'ol_233" FROM d.public.seed AS "*tab\n_90" ORDER BY seed._float8 DESC NULLS FIRST) AS tab_91 ("col%v_234", "col _235", "Col_236", col_237, " c'ol_238", col_239)) changefeed_test.go:1111: Skipping query SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT seed.col_239 AS col_240 FROM (SELECT 3974028594:::OID AS "co}😤l_228", (seed._timestamptz::TIMESTAMPTZ - seed._interval::INTERVAL)::TIMESTAMPTZ AS col_229, seed._interval AS "coL_230", seed._string AS "Col_231", (-64680159792400.00085):::DECIMAL AS col_232, (seed._bytes::BYTES || e'\\x6da8be5995d5294627':::BYTES::BYTES)::BYTES AS "c'ol_233" FROM d.public.seed AS "*tab\n_90" ORDER BY seed._float8 DESC NULLS FIRST) AS tab_91 ("col%v_234", "col _235", "Col_236", col_237, " c'ol_238", col_239)) because error pq: column "seed.col_239" does not exist changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (false OR EXISTS (SELECT '':::VOID AS "c%qol%p_249" FROM d.public.seed AS tab_101 JOIN d.public.seed AS "t/ab_102" ON (((tab_101._int8) = ("t/ab_102"._int8)) AND ((tab_101._date) = ("t/ab_102"._date))) AND ((tab_101._float8) = ("t/ab_102"._float8)))) changefeed_test.go:1122: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (false OR EXISTS (SELECT '':::VOID AS "c%qol%p_249" FROM d.public.seed AS tab_101 JOIN d.public.seed AS "t/ab_102" ON (((tab_101._int8) = ("t/ab_102"._int8)) AND ((tab_101._date) = ("t/ab_102"._date))) AND ((tab_101._float8) = ("t/ab_102"._float8)))) to emit 100 events changefeed_test.go:1125: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._bool AND (seed._bool OR st_dfullywithinexclusive('01040000C000000000':::GEOMETRY::GEOMETRY, '010300004001000000050000004031C67FBFBBAEC1921C9D9814CCF6C1B44B7FF383D9E7C19E11BF3A360AF641A881A3B0DC93E4413C51AB7CF262F74184AEC805F38AF841E8163AE4989C0242F9833A895F7CF5C11AB7915B2C55F141E4031DE5912B004268FD930FF8AFF2C14031C67FBFBBAEC1921C9D9814CCF6C1B44B7FF383D9E7C1':::GEOMETRY::GEOMETRY, seed._float8::FLOAT8)::BOOL)) changefeed_test.go:1122: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (seed._bool AND (seed._bool OR st_dfullywithinexclusive('01040000C000000000':::GEOMETRY::GEOMETRY, '010300004001000000050000004031C67FBFBBAEC1921C9D9814CCF6C1B44B7FF383D9E7C19E11BF3A360AF641A881A3B0DC93E4413C51AB7CF262F74184AEC805F38AF841E8163AE4989C0242F9833A895F7CF5C11AB7915B2C55F141E4031DE5912B004268FD930FF8AFF2C14031C67FBFBBAEC1921C9D9814CCF6C1B44B7FF383D9E7C1':::GEOMETRY::GEOMETRY, seed._float8::FLOAT8)::BOOL)) to emit 45 events changefeed_test.go:1139: st_dfullywithinexclusive(): dwithin distance cannot be less than zero --- FAIL: TestChangefeedRandomExpressions/kafka (2.62s)

INSERT INTO seed (_int2, _int4, _int8, _float4, _float8, _date, _timestamp, _timestamptz, _interval, _bool, _decimal, _string, _bytes, _uuid, _inet, _jsonb) VALUES (NULL, (-128):::INT8, 9223372036854775807:::INT8, 0.0:::FLOAT8, (-0.0):::FLOAT8, 'infinity':::DATE, '2016-10-07 17:20:53.000603':::TIMESTAMP, '294276-12-31 23:59:59.999999+00':::TIMESTAMPTZ, '-72 years -2 mons -160 days -08:03:14.173958':::INTERVAL, true, 0:::DECIMAL, e'9x\'ni\x14K':::STRING, '\x22':::BYTES, '00000000-0000-0000-0000-000000000000':::UUID, 'ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff':::INET, '[0.14514233616075495]':::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:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE seed._bool changefeed_test.go:1122: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE seed._bool to emit 48 events testfeed_test.go:301: creating external connection testfeed_test.go:304: ran create external connection changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._bool OR seed._bool) changefeed_test.go:1122: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (seed._bool OR seed._bool) to emit 48 events testfeed_test.go:301: creating external connection testfeed_test.go:304: ran create external connection changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE true changefeed_test.go:1122: 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:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE false changefeed_test.go:1118: Skipping predicate false because it returned no rows changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE ('BOX(-1.4054166746430963 -0.5926948379324062,0.6602072129013642 0.8488648075064518)':::BOX2D <= 'BOX(-10 -10,10 10)':::BOX2D) changefeed_test.go:1118: Skipping predicate ('BOX(-1.4054166746430963 -0.5926948379324062,0.6602072129013642 0.8488648075064518)':::BOX2D <= 'BOX(-10 -10,10 10)':::BOX2D) because it returned no rows changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE NULL changefeed_test.go:1118: Skipping predicate NULL because it returned no rows changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE ('7623:a5e8:f947:91e7:2682:29b2:537a:132/90':::INET::INET >> (hostmask('233.140.108.219/10':::INET::INET)::INET::INET & inet(e'\tU\x10j\f\n':::STRING::STRING)::INET::INET)::INET::INET)::BOOL changefeed_test.go:1111: Skipping query SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE ('7623:a5e8:f947:91e7:2682:29b2:537a:132/90':::INET::INET >> (hostmask('233.140.108.219/10':::INET::INET)::INET::INET & inet(e'\tU\x10j\f\n':::STRING::STRING)::INET::INET)::INET::INET)::BOOL because error pq: inet(): could not parse "\tU\x10j\f\n" as inet. invalid IP changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT seed.tableoid AS "col%_132", e'\'duCfwKvvr\':356A,835A':::TSVECTOR AS "co%vl&_133", B'0000111100000111001' AS col_134, NULL AS "col _135" FROM d.public.seed AS t̬ab_47 WHERE ((st_intersection('01030000A0E61000000100000005000000D39A2CF03F1066C020E4032748DF09C0B0A9D1E9ECB6D2C18762DF381D0660C09E108AEA7D0745C0BC55CA332FAEE941163BC9A1012A6240080D2B7FED7625C06E645DA041B9E8C10492AF4E60AF48C09AE63F64FF605440EC9422B54738E1C1D39A2CF03F1066C020E4032748DF09C0B0A9D1E9ECB6D2C1':::GEOGRAPHY::GEOGRAPHY, '01050000A0E6100000080000000102000080030000001072132FD0DE494000D3A2876669D9BF52FE0FD99CF400C2707AE139819A3B40D048834CB9B21C40E8DD6581E207DD41F4384CAC5ACC534002B1A8CFB6025040407C5602E77DBFC1010200008005000000D74F604C371263C0E7D76332EF3043C0F1924FAE970AF0C1786860A3F1C461C0348C8E96896850C088FF2162B743E14110F25051A8AF3CC05A9A5E69E7E550C08CF07FEA70E2DAC1FC58D56C737A5D400CCAC2F5EB0B3FC0B04238163BA0F841204BF8CF84333CC00C68CA3EB9E250408877A0BD9F900042010200008002000000E4B446AD456560C0990E813CA74B50C07C3270E5422BE6C1247B7A5606195840241F47DA3D3C4B40D256FF12AA83F04101020000800400000038D8E49B8D163E40C00DA724F48F3A4074E1984AA95BFAC1FCEC4D8B8BA763408E05BE81265454402E68B8970921E3C18086358E5D9617400C16AD0BAEA94F4052C36A940AA9FAC174D301AB4D6F47C03AF6E4B102975040F0FA31FE0BDAC24101020000800300000010C984F786652F4098C7764411414A40004584A13E349F41E0EA0786CB4123C018F8514CDAE64C407C14BE55C2AEDAC14C41B68BE39B62C0148713AD555156402C07BBD875A9FD4101020000800B00000085DAC0515CDC5BC0068F68958B914DC0C0B6C1ACB906C5410CB3241F030249C0B1D6B97ABF4656C0AC6DFF5ABE8DDEC1805E3E2BA9EFFC3F81FB2C2A33CC50C0961FCAF9A3C6F1418C286B2E1A275D404EFE7878540043C070561A7CBD0FE7C1120B868B926E6240D08C5149FF18324044DED321F5CCE2C19E8936C5AA376040FC9B714A21BA33408CF38EA28405FD41285F5D04DC625A40443624343EE835401255D277C1C9E2C1FCF17C040D365440CC9E1DEB7D7D5640A46CEF7A12CAFF4108614BC48BC8314058483954042A5640D0D9DC490B5DCB41C0962688F9B604403C7F24E1D68B494014D59BE2F28DFF41BAD1E2C9AAC163C03A65321FBEAE524078266C7EE5CBEAC1010200008003000000270B3BDFF22E62C0E0FE42D3EB312740BAAB3D52E75DE5C1E510AAD67F2E52C0304A7817991B3640C8E39597C1F7F54120C9DB3798D1384094156E96FF4A514020D195658CFFEEC10102000080020000006DE6ECED646F53C0F767DDDB83D350C07E881FBC4880F741EC40874F60F05B406B8049F1CC8250C0E8A69C847678D541':::GEOGRAPHY::GEOGRAPHY)::GEOGRAPHY::GEOGRAPHY NOT IN (COALESCE('01030000E0E6100000010000000A000000DADFE7375AFB61C04CE6DEC8514E3FC0A45167F5ED18E241983A6A095EC2D3C1C04EB291202617C0166DC50CD6F243C010285B8A3246DD41602E624C9334CB418C732766B4B2464027288261943F42C000405E80324829C1209B101A9CBEB041287A4BFF05FB4240DCEA3B360A5340C07C901EEC704CEF41B4B6E6B6D1D2FAC1282A9CE3A8855B40AFF412A8F10643C0771E426B1C76F4C151CFCD823AE6FAC12819A37A6E344340F8687DFAD3D831C0B3147537CA38F8C184B417C257C0F8C1D054C17BA19741C0804310FA1D6E2140C8FB614FC637D541A11883A27E4A00C2B9C89693201D60C0448CF6088AA64D404074B474D0D9004230927A4AF5A3CBC1218F73806BF160C00C617513DF2B4B40C06299AB02A5FE418080E6B521BCD841DADFE7375AFB61C04CE6DEC8514E3FC0A45167F5ED18E241983A6A095EC2D3C1':::GEOGRAPHY, st_geogfromgeojson(seed._string::STRING)::GEOGRAPHY),)) AND (NULL OR (NOT seed._bool)))) changefeed_test.go:1111: Skipping query SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT seed.tableoid AS "col%_132", e'\'duCfwKvvr\':356A,835A':::TSVECTOR AS "co%vl&_133", B'0000111100000111001' AS col_134, NULL AS "col _135" FROM d.public.seed AS t̬ab_47 WHERE ((st_intersection('01030000A0E61000000100000005000000D39A2CF03F1066C020E4032748DF09C0B0A9D1E9ECB6D2C18762DF381D0660C09E108AEA7D0745C0BC55CA332FAEE941163BC9A1012A6240080D2B7FED7625C06E645DA041B9E8C10492AF4E60AF48C09AE63F64FF605440EC9422B54738E1C1D39A2CF03F1066C020E4032748DF09C0B0A9D1E9ECB6D2C1':::GEOGRAPHY::GEOGRAPHY, '01050000A0E6100000080000000102000080030000001072132FD0DE494000D3A2876669D9BF52FE0FD99CF400C2707AE139819A3B40D048834CB9B21C40E8DD6581E207DD41F4384CAC5ACC534002B1A8CFB6025040407C5602E77DBFC1010200008005000000D74F604C371263C0E7D76332EF3043C0F1924FAE970AF0C1786860A3F1C461C0348C8E96896850C088FF2162B743E14110F25051A8AF3CC05A9A5E69E7E550C08CF07FEA70E2DAC1FC58D56C737A5D400CCAC2F5EB0B3FC0B04238163BA0F841204BF8CF84333CC00C68CA3EB9E250408877A0BD9F900042010200008002000000E4B446AD456560C0990E813CA74B50C07C3270E5422BE6C1247B7A5606195840241F47DA3D3C4B40D256FF12AA83F04101020000800400000038D8E49B8D163E40C00DA724F48F3A4074E1984AA95BFAC1FCEC4D8B8BA763408E05BE81265454402E68B8970921E3C18086358E5D9617400C16AD0BAEA94F4052C36A940AA9FAC174D301AB4D6F47C03AF6E4B102975040F0FA31FE0BDAC24101020000800300000010C984F786652F4098C7764411414A40004584A13E349F41E0EA0786CB4123C018F8514CDAE64C407C14BE55C2AEDAC14C41B68BE39B62C0148713AD555156402C07BBD875A9FD4101020000800B00000085DAC0515CDC5BC0068F68958B914DC0C0B6C1ACB906C5410CB3241F030249C0B1D6B97ABF4656C0AC6DFF5ABE8DDEC1805E3E2BA9EFFC3F81FB2C2A33CC50C0961FCAF9A3C6F1418C286B2E1A275D404EFE7878540043C070561A7CBD0FE7C1120B868B926E6240D08C5149FF18324044DED321F5CCE2C19E8936C5AA376040FC9B714A21BA33408CF38EA28405FD41285F5D04DC625A40443624343EE835401255D277C1C9E2C1FCF17C040D365440CC9E1DEB7D7D5640A46CEF7A12CAFF4108614BC48BC8314058483954042A5640D0D9DC490B5DCB41C0962688F9B604403C7F24E1D68B494014D59BE2F28DFF41BAD1E2C9AAC163C03A65321FBEAE524078266C7EE5CBEAC1010200008003000000270B3BDFF22E62C0E0FE42D3EB312740BAAB3D52E75DE5C1E510AAD67F2E52C0304A7817991B3640C8E39597C1F7F54120C9DB3798D1384094156E96FF4A514020D195658CFFEEC10102000080020000006DE6ECED646F53C0F767DDDB83D350C07E881FBC4880F741EC40874F60F05B406B8049F1CC8250C0E8A69C847678D541':::GEOGRAPHY::GEOGRAPHY)::GEOGRAPHY::GEOGRAPHY NOT IN (COALESCE('01030000E0E6100000010000000A000000DADFE7375AFB61C04CE6DEC8514E3FC0A45167F5ED18E241983A6A095EC2D3C1C04EB291202617C0166DC50CD6F243C010285B8A3246DD41602E624C9334CB418C732766B4B2464027288261943F42C000405E80324829C1209B101A9CBEB041287A4BFF05FB4240DCEA3B360A5340C07C901EEC704CEF41B4B6E6B6D1D2FAC1282A9CE3A8855B40AFF412A8F10643C0771E426B1C76F4C151CFCD823AE6FAC12819A37A6E344340F8687DFAD3D831C0B3147537CA38F8C184B417C257C0F8C1D054C17BA19741C0804310FA1D6E2140C8FB614FC637D541A11883A27E4A00C2B9C89693201D60C0448CF6088AA64D404074B474D0D9004230927A4AF5A3CBC1218F73806BF160C00C617513DF2B4B40C06299AB02A5FE418080E6B521BCD841DADFE7375AFB61C04CE6DEC8514E3FC0A45167F5ED18E241983A6A095EC2D3C1':::GEOGRAPHY, st_geogfromgeojson(seed._string::STRING)::GEOGRAPHY),)) AND (NULL OR (NOT seed._bool)))) because error pq: st_intersection(): geos: no locations to init GEOS changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE st_voronoipolygons(st_makepolygon('01070000800200000001030000800100000007000000D8E4497105C8EFC14EDE05E617CFE0C116693B6FDC2301423EBFC3AF847DFCC155214D998A7300C24C7BA5636BC2FC41CE1A44DC2A6CE7C1620846DDC4DEFBC1D6AE85821CC1F141F8F1F60B50C5E4414DDC610C0A35F1C1C84186E325C7FD413479BE56813DE84160572E0A5AA2B1C108DFAE281CCBDC41F8B52448FEE6EAC1B8EFE293D68D0242E023B69DDDA8BAC1D8E4497105C8EFC14EDE05E617CFE0C116693B6FDC230142010500008006000000010200008003000000667E92A4632FF541C84594EB5697F5C1DCE0F76E77D7FAC1A4E86B90C242FE417C23C9B3E460EAC1F0F9ECAAD423FD41B8800969EFAFD641E8E7AEC8FDCFF64140591CFA2203A0410102000080020000006C9C07D30D0A01C2603AF392879AECC1424C6202D3D6E6C10EAE2DF43D35E8C11DEA90818FD2F9C1CCA1A5991B26E4C1010200008002000000DC1715D964310142A4E89A2CC7F7E6C14E723D5246A8E0C1D4180AB256F6E841803743E412219741B915DC71192A00C201020000800400000095185B7B6A3EF0C1ECD0BE158CE3E241406DCC892D84E9411031C3C77E73D9417299DD795E79F3C15C0729B89206F841B04CB6776540CFC1C6733553B8CC0042649B1452417DEA41B41E0BC74DD9F3C1208D36A1888FFE41E505EB4A1366F4C1010200008004000000863DD3A0B159F7413829E04E8D2FDEC106D080D51FA4FAC1C415D345B89CFF411C870022203ADCC17CD1CAF1E323F74178CDC135B754E141003AC535E3A8F6415CF10F3D0D78EA41CA94B80179A2EDC1C03E581D0F0AF541620D71BA2B6FF441010200008003000000C880E9F5BBFFE8C1C0FE6177EEFFB6415C742EEEA363E8C120373F389DF2B3C11028623EC412D2C1DB87B280A5DE01C2780399F7007800C2C8234F5C36C0D3417EBFCD033847F341':::GEOMETRY::GEOMETRY)::GEOMETRY::GEOMETRY, 0.45363575762362485:::FLOAT8::FLOAT8, '01050000000300000001020000000300000046A35F82B183FCC1C269D372C19CEEC1E8A86592C5AFDF417F2B35CD8079F1C178A3AE654D77D24180CF89314B9BD641010200000003000000402D61F30EB7E641D06AF9020C2BD941BC6BB8CFC92DE8412C74ED6EF1EAEA418338A56D4237FAC100B3A6C317749F4101020000000200000042AE758C8BDDF3C1F27E5C7DF03FF0C1E19C2C1C17A8F4C12EAFCA72465BF741':::GEOMETRY::GEOMETRY)::GEOMETRY::GEOMETRY NOT IN (SELECT '010200000000000000':::GEOMETRY::GEOMETRY AS col_167 FROM d.public.seed AS "\\x12tab_71" JOIN d.public.seed AS tab_72 ON (("\\x12tab_71"._int8) = (tab_72._int4)) AND (("\\x12tab_71"._int4) = (tab_72._int4))) changefeed_test.go:1111: Skipping query SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE st_voronoipolygons(st_makepolygon('01070000800200000001030000800100000007000000D8E4497105C8EFC14EDE05E617CFE0C116693B6FDC2301423EBFC3AF847DFCC155214D998A7300C24C7BA5636BC2FC41CE1A44DC2A6CE7C1620846DDC4DEFBC1D6AE85821CC1F141F8F1F60B50C5E4414DDC610C0A35F1C1C84186E325C7FD413479BE56813DE84160572E0A5AA2B1C108DFAE281CCBDC41F8B52448FEE6EAC1B8EFE293D68D0242E023B69DDDA8BAC1D8E4497105C8EFC14EDE05E617CFE0C116693B6FDC230142010500008006000000010200008003000000667E92A4632FF541C84594EB5697F5C1DCE0F76E77D7FAC1A4E86B90C242FE417C23C9B3E460EAC1F0F9ECAAD423FD41B8800969EFAFD641E8E7AEC8FDCFF64140591CFA2203A0410102000080020000006C9C07D30D0A01C2603AF392879AECC1424C6202D3D6E6C10EAE2DF43D35E8C11DEA90818FD2F9C1CCA1A5991B26E4C1010200008002000000DC1715D964310142A4E89A2CC7F7E6C14E723D5246A8E0C1D4180AB256F6E841803743E412219741B915DC71192A00C201020000800400000095185B7B6A3EF0C1ECD0BE158CE3E241406DCC892D84E9411031C3C77E73D9417299DD795E79F3C15C0729B89206F841B04CB6776540CFC1C6733553B8CC0042649B1452417DEA41B41E0BC74DD9F3C1208D36A1888FFE41E505EB4A1366F4C1010200008004000000863DD3A0B159F7413829E04E8D2FDEC106D080D51FA4FAC1C415D345B89CFF411C870022203ADCC17CD1CAF1E323F74178CDC135B754E141003AC535E3A8F6415CF10F3D0D78EA41CA94B80179A2EDC1C03E581D0F0AF541620D71BA2B6FF441010200008003000000C880E9F5BBFFE8C1C0FE6177EEFFB6415C742EEEA363E8C120373F389DF2B3C11028623EC412D2C1DB87B280A5DE01C2780399F7007800C2C8234F5C36C0D3417EBFCD033847F341':::GEOMETRY::GEOMETRY)::GEOMETRY::GEOMETRY, 0.45363575762362485:::FLOAT8::FLOAT8, '01050000000300000001020000000300000046A35F82B183FCC1C269D372C19CEEC1E8A86592C5AFDF417F2B35CD8079F1C178A3AE654D77D24180CF89314B9BD641010200000003000000402D61F30EB7E641D06AF9020C2BD941BC6BB8CFC92DE8412C74ED6EF1EAEA418338A56D4237FAC100B3A6C317749F4101020000000200000042AE758C8BDDF3C1F27E5C7DF03FF0C1E19C2C1C17A8F4C12EAFCA72465BF741':::GEOMETRY::GEOMETRY)::GEOMETRY::GEOMETRY NOT IN (SELECT '010200000000000000':::GEOMETRY::GEOMETRY AS col_167 FROM d.public.seed AS "\\x12tab_71" JOIN d.public.seed AS tab_72 ON (("\\x12tab_71"._int8) = (tab_72._int4)) AND (("\\x12tab_71"._int4) = (tab_72._int4))) because error pq: st_makepolygon(): argument must be LINESTRING geometries changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (false OR seed._bool) changefeed_test.go:1122: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (false OR seed._bool) to emit 48 events testfeed_test.go:301: creating external connection testfeed_test.go:304: ran create external connection changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._string::STRING % e'\x19\x0fL':::STRING::STRING)::BOOL changefeed_test.go:1118: Skipping predicate (seed._string::STRING % e'\x19\x0fL':::STRING::STRING)::BOOL because it returned no rows changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (NOT false) changefeed_test.go:1122: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (NOT false) to emit 100 events testfeed_test.go:301: creating external connection testfeed_test.go:304: ran create external connection changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._bool AND seed._bool) changefeed_test.go:1122: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (seed._bool AND seed._bool) to emit 48 events testfeed_test.go:301: creating external connection testfeed_test.go:304: ran create external connection changefeed_test.go:1106: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._bool AND (seed._string SIMILAR TO seed._string)) changefeed_test.go:1122: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE (seed._bool AND (seed._string SIMILAR TO seed._string)) to emit 43 events testfeed_test.go:301: creating external connection testfeed_test.go:304: ran create external connection changefeed_test.go:1139: invalid regular expression: error parsing regexp: invalid escape sequence: ``\J`` --- FAIL: TestChangefeedRandomExpressions/kafka (11.81s)

cockroachdb / cockroach

ccl/changefeedccl: TestChangefeedRandomExpressions failed #127642