ccl/changefeedccl: TestChangefeedRandomExpressions failed #143589

github-actions · 2025-03-27T18:50:57Z

ccl/changefeedccl.TestChangefeedRandomExpressions failed on master @ 60cd8229592a49fb1695792032d1969de628a417:

    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE NULL
    changefeed_test.go:1327: Skipping predicate NULL because it returned no rows
    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (NULL AND (e'\x0f':::STRING::STRING NOT IN (e'\'':::STRING, 'nnn:H]7iQ':::STRING, e'\x136':::STRING)))
    changefeed_test.go:1327: Skipping predicate (NULL AND (e'\x0f':::STRING::STRING NOT IN (e'\'':::STRING, 'nnn:H]7iQ':::STRING, e'\x136':::STRING))) because it returned no rows
    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE true
    changefeed_test.go:1331: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE true to emit 100 events
    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE st_dwithin('fonT':::STRING::STRING, seed._string::STRING, seed._float8::FLOAT8)::BOOL
    changefeed_test.go:1320: Skipping query SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE st_dwithin('fonT':::STRING::STRING, seed._string::STRING, seed._float8::FLOAT8)::BOOL because error pq: st_dwithin(): error parsing EWKT: syntax error: invalid keyword at line 1, pos 0
        LINE 1: fonT
                ^
    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE false
    changefeed_test.go:1327: Skipping predicate false because it returned no rows
    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE seed._string !~ e'(\b!':::STRING
    changefeed_test.go:1320: Skipping query SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE seed._string !~ e'(\b!':::STRING because error pq: invalid regular expression: error parsing regexp: missing closing ): ``(�!``
    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE st_orderingequals('0106000000020000000103000000010000000A000000D05E77ADF6E1C9C12965FE2ADC7FF9C180777C4277BD97C128DCCF762914FDC1201465F79BD2B3C1CC501C8B9E3501C2B8D66EA50BBAE041D5370108416000C28CEC6F8E5796FE41457A10B25C1701C2C4364357DCB500427057E8B622EB00C28C8B0F0880A0FA41EC4A4FDD2FA6E541103C89888079F941F67B47686D2FF341A061F5CFF929B5C1BCF9DAE0E23AF241D05E77ADF6E1C9C12965FE2ADC7FF9C10103000000010000000C0000006A65F6CBAE49EFC1732442C9665002C28CFD520F7732E94145E101CD97A0FDC14E1154A86173F64103210ACF53E701C22C16B63B95C40042A4E220DF582A01C2A8C05BB8720B014270ECD7BCDA82C4C1D6624C316FE00142700D787D5ECEFD41E0B367A5B340EC4104CAE393181402429CF8634A56CFEA41D0B1AD69DA0800422CBC83F58BF2E9C128E68DDEEF35F241F0AA3D1330CAD4C178C76ACC4EF4E041EE80102F8C06FAC114DB921A045AF1416A65F6CBAE49EFC1732442C9665002C2':::GEOMETRY::GEOMETRY, '0105000040050000000102000040020000000647E29CA638F241844B93FF73F30142C03D7E2549F101C224F3989E4BE4F3C1ACFA2EA7DFE500420C020EB8C0C8F341010200004003000000C0DA30734FF500C2D2BA48039C42FCC17897031A08DE00421A70A920815AECC13C61CEDA5D2AF5C174DEA24E7A14F6417888808EC3ADFB4120D17169A1E3C2C130ACB8B95206EA410102000040030000008080DA94D4819A4150A5DF33F544D9C1CC02ACD1EF8E00422AAB07F7533BE8C1A25F9B8FA017FFC1925D695FCF810142D81A6CC14252EC419F3517F3C071F4C180185E44C42BCAC1010200004004000000F498279EABA3EEC184ACFFB4797702C2C4E49D1E8B59FF4148571468AE68E541C1EF38B10352FDC1584D2277700CFC41D8FDADA84C4FFC41615D9C47F92002C2484F104303D7D1C1BC0D97824119F4411034C0103C87C441A8B3DC071B94E4C1010200004002000000A8837A1FAB69EF4142560DBBDB1AE2C14E2BACDAD665F841228A537D30C0F7C140FA4DA73DBBAB4174DBB136B5210042':::GEOMETRY::GEOMETRY)::BOOL
    changefeed_test.go:1327: Skipping predicate st_orderingequals('0106000000020000000103000000010000000A000000D05E77ADF6E1C9C12965FE2ADC7FF9C180777C4277BD97C128DCCF762914FDC1201465F79BD2B3C1CC501C8B9E3501C2B8D66EA50BBAE041D5370108416000C28CEC6F8E5796FE41457A10B25C1701C2C4364357DCB500427057E8B622EB00C28C8B0F0880A0FA41EC4A4FDD2FA6E541103C89888079F941F67B47686D2FF341A061F5CFF929B5C1BCF9DAE0E23AF241D05E77ADF6E1C9C12965FE2ADC7FF9C10103000000010000000C0000006A65F6CBAE49EFC1732442C9665002C28CFD520F7732E94145E101CD97A0FDC14E1154A86173F64103210ACF53E701C22C16B63B95C40042A4E220DF582A01C2A8C05BB8720B014270ECD7BCDA82C4C1D6624C316FE00142700D787D5ECEFD41E0B367A5B340EC4104CAE393181402429CF8634A56CFEA41D0B1AD69DA0800422CBC83F58BF2E9C128E68DDEEF35F241F0AA3D1330CAD4C178C76ACC4EF4E041EE80102F8C06FAC114DB921A045AF1416A65F6CBAE49EFC1732442C9665002C2':::GEOMETRY::GEOMETRY, '0105000040050000000102000040020000000647E29CA638F241844B93FF73F30142C03D7E2549F101C224F3989E4BE4F3C1ACFA2EA7DFE500420C020EB8C0C8F341010200004003000000C0DA30734FF500C2D2BA48039C42FCC17897031A08DE00421A70A920815AECC13C61CEDA5D2AF5C174DEA24E7A14F6417888808EC3ADFB4120D17169A1E3C2C130ACB8B95206EA410102000040030000008080DA94D4819A4150A5DF33F544D9C1CC02ACD1EF8E00422AAB07F7533BE8C1A25F9B8FA017FFC1925D695FCF810142D81A6CC14252EC419F3517F3C071F4C180185E44C42BCAC1010200004004000000F498279EABA3EEC184ACFFB4797702C2C4E49D1E8B59FF4148571468AE68E541C1EF38B10352FDC1584D2277700CFC41D8FDADA84C4FFC41615D9C47F92002C2484F104303D7D1C1BC0D97824119F4411034C0103C87C441A8B3DC071B94E4C1010200004002000000A8837A1FAB69EF4142560DBBDB1AE2C14E2BACDAD665F841228A537D30C0F7C140FA4DA73DBBAB4174DBB136B5210042':::GEOMETRY::GEOMETRY)::BOOL because it returned no rows
    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE seed._string LIKE text(seed._decimal::DECIMAL)::STRING
    changefeed_test.go:1331: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE seed._string LIKE text(seed._decimal::DECIMAL)::STRING to emit 5 events
    changefeed_test.go:1334: Test tolerating create changefeed error: failed to start feed for job 0: pq: function "text" unsupported by CDC
    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE strptime(seed._string::STRING, seed._string::STRING)::TIMESTAMPTZ::TIMESTAMPTZ IN ('1976-10-07 06:42:18.000066+00':::TIMESTAMPTZ,)
    changefeed_test.go:1327: Skipping predicate strptime(seed._string::STRING, seed._string::STRING)::TIMESTAMPTZ::TIMESTAMPTZ IN ('1976-10-07 06:42:18.000066+00':::TIMESTAMPTZ,) because it returned no rows
    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (_st_covers(NULL::GEOMETRY, st_makepoint((-0.7645880743387212):::FLOAT8::FLOAT8, floor(st_distancesphere(st_linefromencodedpolyline(lpad((jsonb_extract_path_text(seed._jsonb::JSONB, ((NULL::STRING || ('11:27:38.044635':::TIME::TIME + parse_date(('5CACB67F/54053887':::PG_LSN::PG_LSN || e'\x17,U':::STRING::STRING)::STRING::STRING)::DATE::DATE)::TIMESTAMP::TIMESTAMP)::STRING::STRING || (age((parse_interval('':::STRING::STRING)::INTERVAL::INTERVAL + ('1972-06-18':::DATE::DATE + '21:22:42.157065-13:27':::TIMETZ::TIMETZ)::TIMESTAMPTZ::TIMESTAMPTZ)::TIMESTAMPTZ::TIMESTAMPTZ, '1981-05-05 01:16:50.000619+00':::TIMESTAMPTZ::TIMESTAMPTZ)::INTERVAL::INTERVAL + '02:17:26.0449':::TIME::TIME)::TIME::TIME)::STRING::STRING)::STRING::STRING || '25.31.149.204/7':::INET::INET)::STRING::STRING, (-421749047331507213):::INT8::INT8, text('BOX(-1.8634199081322134 0.8564944657681961,0.4767371341060131 0.8849137369782905)':::BOX2D::BOX2D)::STRING::STRING)::STRING::STRING, 385744537:::INT8::INT4)::GEOMETRY::GEOMETRY, '01020000C002000000D1B2E652B48DF1C1A8FC43F595F5DA4128A5BDAAD5BFD84176A3AD33F006F0C1C24E8A3A52C0F9416060B1143AFDC2C1320573984391F6C14092E96BF09200C2':::GEOMETRY::GEOMETRY)::FLOAT8::FLOAT8)::FLOAT8::FLOAT8, (COALESCE('[-35938.973,6.866188e+10,-3.391658e-15,-5.3114506e-13,1.2325489e+34,-0.004187722,64.55966,-2.8430585e+26,-5.0136025e-36,-1.0998768e+27,-3.0636203e-15,4.7894315e-07,2.2052853e+24,5.467805e-06,2.1479863e-34,3.6949918e-05,5.270769e-35,8.862301e+18,4.5823938e+21,-0.001817744,7.391393e-11,3.0804685e+06,-8.373172e+15,5.8811567e-31,2.9045188e+13,2.0921836e+26,-2.1902382e+20,1.9603125e-34,-5.1269108e+10,2.538526e-34,9.408017e-33,-8.9333907e+18,0.0010182926,1.0798094e+09,-4.0920737e+23,2.7241502,-5.3426227e-21,1.8007944e+15,-2.4211164e+16,-7.9153114e+34,-4.0634307e-21,8.101307e+31,3.1794706e-35,-1.1842067e+25,-2.5242535e-31,1.7161883e-27,1.7130142e-28,-0.0007668938,-8.593765e+15,-1.3011593e+37,2.5888442e-08,-2.664813e+35,-3.259599e+09,1.3359994e+20,-1.9095008e+27,8.5253233e-26,-3.6303253e-23,7.727224e+13,-8.241553e+33,-1.7450529e+09,0.0010403583,-921421.7,1.5535121e+18,3.0261227e+16,-2.5506963e+22,3.0221215e+36,3.2880858e+19,1.2501332e-08,-4.213115e-21,1.1246466e-13,4.6726488e-38,0.039362755,-1.1797804e+07,1.7035557e+18,4.599746e-06,2.25206e+09,-3.4606906e+21,-3.087579e+18,4.4249928e+20,4.8880293e+36,8.4917235e+14,325.96262,-70.91995,6.959931e+11,4.6037073e+27,-5.5993157e-09,-1.4011505e+19,8.47286e+12]':::VECTOR, (NULL::VECTOR - '[5.3619242e-08,-2.5298837e-33,-2.4609162e+07,0.22850661,-2.9099166e-36,-2.5310372e+07,-8.7576133e+15,-8.678138e-28,-1.8169825e-24,4.722297e+28,0.010882621,7.4857197e+28,2.6721285e-38,-1.2526684e-27,-2.1051592e+29,5.0408514e+10,7.285386e-21,8.865864e-11,-341085.2,-1.1209578e+36,-1.8529837e+09,-6.3524065e+10,-6.307907e-34,0.013603673,110699.79,7.773345e-16,-9.901649e-25,4.2531858e+31,2.1563848e-28,-21649.191,-2.7001604e-25,5.431038e-15,-7.9943425e-07,-1.7218952e+31,-1.6448426e+06,6.6125683e-18,-6.0168966e+08,9.697196e+07,1.10636005e-20,-1.6599315e-05,6.729609e-22,-3.5762656e-28,1.3453794e-37,3.68355e+15,-3.1741315e+27,-9.813843e-17,-6.4964465e+10,6.887656e+26,-4.4863333e-07,-1.5424852e-27,4.471833e+36,3.4298535e+16,-5.2859753e-32,-6.543205e-24,2.1074192e+07,3.420855e+29,-6.287817e+16,-2.1369635e+31,1.18453535e-26,-4.8120887e+30,-1.5218932e-05,-237.72531,-1.4649016e-36,-1935.4861,1.8427875e-15,-3.1618238e+23,-5.019078e+09,25.648773,7.2085306e+25,-4.2459826e-05,1.0473771,-635.5658,-1.4254005e+14,1.9280714e-21,-4.4838897e-38,1.9935584e-09,-1534.6958,959926.5,0.041144826,-1.2881039e+06,4.2613853e-11,1.6828391e+38,1.5154513e+29,-1.3112352e-34,-3.3542177e-35,1.4444348e-18,-3.8918786e+30,-7.397053e+14,-0.00011106352,-9.755646e+17,-2.1149007e-21,9.111718e+28,-9.409123e+23,2.4327808e+08,4.3826267e-06,-509.06555,-5.394982e+31,-5.7524634e-18,16865.77,5.0381653e+32,-4.7450235e-31,-5.250821e+22,1.4006156e+13,-0.0029624652,1.2359767e-33,-2.5076782e+29,3.0063274e+12,2.1618546e+37,-1.6289818e+24,-1.5078321e+11,-1.6980235e-28,-1.1390977e-17,-2.2845308e-07,4.7516798e-27,6.0839376e+26,5.043925e-13,-3.3360987e-38,1.228018e+21,1.12762284e-13,5.77489e+14,5.61923e+06,-1.3195706e+09,-1.5144137e-13,2.8022008e+06,-6.132575e-07,-2.0796108e-37,6.3606226e+32,-0.002124718,4.7791515e-36,4451.943,-1.2569312e-33,-2.9931e-33,-1.877316e-17,6.5213374e-16,-22.04635,-1.39918405e+32,1.1935855e+36,-8.252246e-24,0.034675438,1.19030125e+27,-1.01310205e+37,-1.530369e-07,7.152957e+17,-7.77366e+08,1.3972598e+30,2.9416294e-18,2.4557417e-22,-7.222787e+25,5.89074e+20,-2.2311827e+34,-2.1348672e+13,-5.1717296e+08,-2.4271955e+36,-7.240796e+30,-4.9241586e-18,1.675912e-14,-32041.43,2.74398e-22,-3.5130998e-07,0.40159574,5.124525e+24,-3.9688488e+18,1.6696902e+33,7.733978e+35,1.8917097e-33,-2.6961619e-11,1.1409711e+31,-2.1994086e+21,-4.384205e+36,-10348.691,-3.3505315e+06,1.6779314e+28,-1.9393922e+24,7.86072e-15,1.5397051e-12,-3.1094125e-31,8.7473165e+08,-1.2179503e+13,-3.2987494e+38,0.0009934048,-3.499402,1.8771269e-08,5.6219934e+24,-1.6419917,-0.67321146,-2.4703069,-1.2918989e-09,-3.889267e+34,4.6811027e-34,3.3850794e+12,-2.809716e+36,1.122067e-05,-1.8358331e+09,7.693678e+22,-5.180175e-13,9.926855e-19,1.0904128e+26,-4.7043546e+19,1.4653879e-06,3.2716906e+27,5.0788673e-20,-3.1996292e+06,-6.9951796e+19,-0.00061952334,-3.7333507e+29,0.02004722,-2.7379459e-22,-8.946761e+21,-5.43171e+25,-3.470683e-18,-3.7633164e+31,-2.1773864e-33,-1.9567104e+36,2.1736952e+37,1.6005731e+06,-2.4205953e-09,-4.6528266e+10,2.3755525e-24,-2.4537834e+29,-1.0232496e+07,1.4307879e+26,3.7114335e+13,-1.2053477e-21,2.7076517e+24,-5.8481874e+32,-7.398001e+35,3.920394e+24,1.3132733e+11,2.9235843e+19,1.8238834e+35,1.0271432e+10,0.017172683,-5.5577004e-08,1.3951111e+28,1.846771e+16,3.510511e+31,-0.7900979,-2.7067983e+38,1.4897878e+27,-1.7657012e-14,8.131983e-10,1.098714e+10,-6.4864106,1.2947694e-38,-9.57578e-30,-2.0901736e+24,-8.462887e-33,4.3367623e+36,6.928573e+25,5.647984e-31,-7.827951e+30,2.7162698e-18,-2.7600414e+20,1.035195e-36,2.646791e+33,1.4444873e+28,0.0006981963,6.413744e+31,0.40438536,2.79119e+31,1.2010545e+24,2.549899e-28,3.9588402e+12,-1.1267091e+25,-1.5205003e+32,-2.236325e+30,1.3934404e+15,-0.33922273,2.1408252e+06,7.63426e-24,4.461494e-21,-3.1156004e+25,-3.3082877e-11,-2.7963883e+35,8.1046604e+26,-6.689688e-16,-605291.1,3.8225396e-20,5.738074e-19,-0.007794831,7.885602e-30,4.192577e-30,-1.6528451e+08,8.966811e+21,-2.326462e-20,-1.9011126e-25,1.5268899e+18,0.00029344525,-5.61945e+25,-6.441025e+31,1.1000713e-16,-4.020033e+35,250672.05,1.835688e-17,-4.8017259e+27,-1.2293572,1.7704721e-15,2.9449906e-26,-0.028717156,-9.980909e-26,-5.783554e+33,6.324236e+33,0.24312563,-2.4791328e-16,3.0515773e-33,0.25326255,-2.5401533e-22,-3.2487212e-26,6.999614e+37,2.0647525e-26,-8.5910505e-29,-4.5522296e-30,-4.065037e-07,-1.1558857e+16,-6.9998586e-16,-3.946126e-08,-1.7727588e-29,-3.3092033e+21,-2.1450686e+35,3.3182084e-15,4.870595e-22,-6.7366937e-31,-2.1904323e-33,-8.389095e+28,-27785.19,-5.555338e+21,2.0126524e+35,-590.35547,141.50871,-3.1440126e+24,111924.664,-0.17817135,35.78465,3.4047068e+10,1.8328623e-13,-1.2443938e-36,2.9168358e+06,-5.044989e+30,1.4962312e-22,-3.1284453e-35,3.033864e-20,-2707.1963,-9.35319e-11,-5.6026646e+17,3.24209e+19,-7.155116e-16,-2.1691416e+32,53798.785]':::VECTOR::VECTOR)::VECTOR)::VECTOR <=> NULL::VECTOR)::FLOAT8::FLOAT8, '+Inf':::FLOAT8::FLOAT8)::GEOMETRY::GEOMETRY)::BOOL AND ('da88:544d:1567:e8e5:37e1:6603:b97:e2a4/65':::INET::INET << '6cc0:f897:e29c:2dbb:5bb8:2653:4be4:bec7/76':::INET::INET)::BOOL)
    changefeed_test.go:1327: Skipping predicate (_st_covers(NULL::GEOMETRY, st_makepoint((-0.7645880743387212):::FLOAT8::FLOAT8, floor(st_distancesphere(st_linefromencodedpolyline(lpad((jsonb_extract_path_text(seed._jsonb::JSONB, ((NULL::STRING || ('11:27:38.044635':::TIME::TIME + parse_date(('5CACB67F/54053887':::PG_LSN::PG_LSN || e'\x17,U':::STRING::STRING)::STRING::STRING)::DATE::DATE)::TIMESTAMP::TIMESTAMP)::STRING::STRING || (age((parse_interval('':::STRING::STRING)::INTERVAL::INTERVAL + ('1972-06-18':::DATE::DATE + '21:22:42.157065-13:27':::TIMETZ::TIMETZ)::TIMESTAMPTZ::TIMESTAMPTZ)::TIMESTAMPTZ::TIMESTAMPTZ, '1981-05-05 01:16:50.000619+00':::TIMESTAMPTZ::TIMESTAMPTZ)::INTERVAL::INTERVAL + '02:17:26.0449':::TIME::TIME)::TIME::TIME)::STRING::STRING)::STRING::STRING || '25.31.149.204/7':::INET::INET)::STRING::STRING, (-421749047331507213):::INT8::INT8, text('BOX(-1.8634199081322134 0.8564944657681961,0.4767371341060131 0.8849137369782905)':::BOX2D::BOX2D)::STRING::STRING)::STRING::STRING, 385744537:::INT8::INT4)::GEOMETRY::GEOMETRY, '01020000C002000000D1B2E652B48DF1C1A8FC43F595F5DA4128A5BDAAD5BFD84176A3AD33F006F0C1C24E8A3A52C0F9416060B1143AFDC2C1320573984391F6C14092E96BF09200C2':::GEOMETRY::GEOMETRY)::FLOAT8::FLOAT8)::FLOAT8::FLOAT8, (COALESCE('[-35938.973,6.866188e+10,-3.391658e-15,-5.3114506e-13,1.2325489e+34,-0.004187722,64.55966,-2.8430585e+26,-5.0136025e-36,-1.0998768e+27,-3.0636203e-15,4.7894315e-07,2.2052853e+24,5.467805e-06,2.1479863e-34,3.6949918e-05,5.270769e-35,8.862301e+18,4.5823938e+21,-0.001817744,7.391393e-11,3.0804685e+06,-8.373172e+15,5.8811567e-31,2.9045188e+13,2.0921836e+26,-2.1902382e+20,1.9603125e-34,-5.1269108e+10,2.538526e-34,9.408017e-33,-8.9333907e+18,0.0010182926,1.0798094e+09,-4.0920737e+23,2.7241502,-5.3426227e-21,1.8007944e+15,-2.4211164e+16,-7.9153114e+34,-4.0634307e-21,8.101307e+31,3.1794706e-35,-1.1842067e+25,-2.5242535e-31,1.7161883e-27,1.7130142e-28,-0.0007668938,-8.593765e+15,-1.3011593e+37,2.5888442e-08,-2.664813e+35,-3.259599e+09,1.3359994e+20,-1.9095008e+27,8.5253233e-26,-3.6303253e-23,7.727224e+13,-8.241553e+33,-1.7450529e+09,0.0010403583,-921421.7,1.5535121e+18,3.0261227e+16,-2.5506963e+22,3.0221215e+36,3.2880858e+19,1.2501332e-08,-4.213115e-21,1.1246466e-13,4.6726488e-38,0.039362755,-1.1797804e+07,1.7035557e+18,4.599746e-06,2.25206e+09,-3.4606906e+21,-3.087579e+18,4.4249928e+20,4.8880293e+36,8.4917235e+14,325.96262,-70.91995,6.959931e+11,4.6037073e+27,-5.5993157e-09,-1.4011505e+19,8.47286e+12]':::VECTOR, (NULL::VECTOR - '[5.3619242e-08,-2.5298837e-33,-2.4609162e+07,0.22850661,-2.9099166e-36,-2.5310372e+07,-8.7576133e+15,-8.678138e-28,-1.8169825e-24,4.722297e+28,0.010882621,7.4857197e+28,2.6721285e-38,-1.2526684e-27,-2.1051592e+29,5.0408514e+10,7.285386e-21,8.865864e-11,-341085.2,-1.1209578e+36,-1.8529837e+09,-6.3524065e+10,-6.307907e-34,0.013603673,110699.79,7.773345e-16,-9.901649e-25,4.2531858e+31,2.1563848e-28,-21649.191,-2.7001604e-25,5.431038e-15,-7.9943425e-07,-1.7218952e+31,-1.6448426e+06,6.6125683e-18,-6.0168966e+08,9.697196e+07,1.10636005e-20,-1.6599315e-05,6.729609e-22,-3.5762656e-28,1.3453794e-37,3.68355e+15,-3.1741315e+27,-9.813843e-17,-6.4964465e+10,6.887656e+26,-4.4863333e-07,-1.5424852e-27,4.471833e+36,3.4298535e+16,-5.2859753e-32,-6.543205e-24,2.1074192e+07,3.420855e+29,-6.287817e+16,-2.1369635e+31,1.18453535e-26,-4.8120887e+30,-1.5218932e-05,-237.72531,-1.4649016e-36,-1935.4861,1.8427875e-15,-3.1618238e+23,-5.019078e+09,25.648773,7.2085306e+25,-4.2459826e-05,1.0473771,-635.5658,-1.4254005e+14,1.9280714e-21,-4.4838897e-38,1.9935584e-09,-1534.6958,959926.5,0.041144826,-1.2881039e+06,4.2613853e-11,1.6828391e+38,1.5154513e+29,-1.3112352e-34,-3.3542177e-35,1.4444348e-18,-3.8918786e+30,-7.397053e+14,-0.00011106352,-9.755646e+17,-2.1149007e-21,9.111718e+28,-9.409123e+23,2.4327808e+08,4.3826267e-06,-509.06555,-5.394982e+31,-5.7524634e-18,16865.77,5.0381653e+32,-4.7450235e-31,-5.250821e+22,1.4006156e+13,-0.0029624652,1.2359767e-33,-2.5076782e+29,3.0063274e+12,2.1618546e+37,-1.6289818e+24,-1.5078321e+11,-1.6980235e-28,-1.1390977e-17,-2.2845308e-07,4.7516798e-27,6.0839376e+26,5.043925e-13,-3.3360987e-38,1.228018e+21,1.12762284e-13,5.77489e+14,5.61923e+06,-1.3195706e+09,-1.5144137e-13,2.8022008e+06,-6.132575e-07,-2.0796108e-37,6.3606226e+32,-0.002124718,4.7791515e-36,4451.943,-1.2569312e-33,-2.9931e-33,-1.877316e-17,6.5213374e-16,-22.04635,-1.39918405e+32,1.1935855e+36,-8.252246e-24,0.034675438,1.19030125e+27,-1.01310205e+37,-1.530369e-07,7.152957e+17,-7.77366e+08,1.3972598e+30,2.9416294e-18,2.4557417e-22,-7.222787e+25,5.89074e+20,-2.2311827e+34,-2.1348672e+13,-5.1717296e+08,-2.4271955e+36,-7.240796e+30,-4.9241586e-18,1.675912e-14,-32041.43,2.74398e-22,-3.5130998e-07,0.40159574,5.124525e+24,-3.9688488e+18,1.6696902e+33,7.733978e+35,1.8917097e-33,-2.6961619e-11,1.1409711e+31,-2.1994086e+21,-4.384205e+36,-10348.691,-3.3505315e+06,1.6779314e+28,-1.9393922e+24,7.86072e-15,1.5397051e-12,-3.1094125e-31,8.7473165e+08,-1.2179503e+13,-3.2987494e+38,0.0009934048,-3.499402,1.8771269e-08,5.6219934e+24,-1.6419917,-0.67321146,-2.4703069,-1.2918989e-09,-3.889267e+34,4.6811027e-34,3.3850794e+12,-2.809716e+36,1.122067e-05,-1.8358331e+09,7.693678e+22,-5.180175e-13,9.926855e-19,1.0904128e+26,-4.7043546e+19,1.4653879e-06,3.2716906e+27,5.0788673e-20,-3.1996292e+06,-6.9951796e+19,-0.00061952334,-3.7333507e+29,0.02004722,-2.7379459e-22,-8.946761e+21,-5.43171e+25,-3.470683e-18,-3.7633164e+31,-2.1773864e-33,-1.9567104e+36,2.1736952e+37,1.6005731e+06,-2.4205953e-09,-4.6528266e+10,2.3755525e-24,-2.4537834e+29,-1.0232496e+07,1.4307879e+26,3.7114335e+13,-1.2053477e-21,2.7076517e+24,-5.8481874e+32,-7.398001e+35,3.920394e+24,1.3132733e+11,2.9235843e+19,1.8238834e+35,1.0271432e+10,0.017172683,-5.5577004e-08,1.3951111e+28,1.846771e+16,3.510511e+31,-0.7900979,-2.7067983e+38,1.4897878e+27,-1.7657012e-14,8.131983e-10,1.098714e+10,-6.4864106,1.2947694e-38,-9.57578e-30,-2.0901736e+24,-8.462887e-33,4.3367623e+36,6.928573e+25,5.647984e-31,-7.827951e+30,2.7162698e-18,-2.7600414e+20,1.035195e-36,2.646791e+33,1.4444873e+28,0.0006981963,6.413744e+31,0.40438536,2.79119e+31,1.2010545e+24,2.549899e-28,3.9588402e+12,-1.1267091e+25,-1.5205003e+32,-2.236325e+30,1.3934404e+15,-0.33922273,2.1408252e+06,7.63426e-24,4.461494e-21,-3.1156004e+25,-3.3082877e-11,-2.7963883e+35,8.1046604e+26,-6.689688e-16,-605291.1,3.8225396e-20,5.738074e-19,-0.007794831,7.885602e-30,4.192577e-30,-1.6528451e+08,8.966811e+21,-2.326462e-20,-1.9011126e-25,1.5268899e+18,0.00029344525,-5.61945e+25,-6.441025e+31,1.1000713e-16,-4.020033e+35,250672.05,1.835688e-17,-4.8017259e+27,-1.2293572,1.7704721e-15,2.9449906e-26,-0.028717156,-9.980909e-26,-5.783554e+33,6.324236e+33,0.24312563,-2.4791328e-16,3.0515773e-33,0.25326255,-2.5401533e-22,-3.2487212e-26,6.999614e+37,2.0647525e-26,-8.5910505e-29,-4.5522296e-30,-4.065037e-07,-1.1558857e+16,-6.9998586e-16,-3.946126e-08,-1.7727588e-29,-3.3092033e+21,-2.1450686e+35,3.3182084e-15,4.870595e-22,-6.7366937e-31,-2.1904323e-33,-8.389095e+28,-27785.19,-5.555338e+21,2.0126524e+35,-590.35547,141.50871,-3.1440126e+24,111924.664,-0.17817135,35.78465,3.4047068e+10,1.8328623e-13,-1.2443938e-36,2.9168358e+06,-5.044989e+30,1.4962312e-22,-3.1284453e-35,3.033864e-20,-2707.1963,-9.35319e-11,-5.6026646e+17,3.24209e+19,-7.155116e-16,-2.1691416e+32,53798.785]':::VECTOR::VECTOR)::VECTOR)::VECTOR <=> NULL::VECTOR)::FLOAT8::FLOAT8, '+Inf':::FLOAT8::FLOAT8)::GEOMETRY::GEOMETRY)::BOOL AND ('da88:544d:1567:e8e5:37e1:6603:b97:e2a4/65':::INET::INET << '6cc0:f897:e29c:2dbb:5bb8:2653:4be4:bec7/76':::INET::INET)::BOOL) because it returned no rows
    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (NOT EXISTS (SELECT seed._inet AS "c͡o%ql_303" FROM d.public.seed AS "tab%q_97" ORDER BY seed._jsonb))
    changefeed_test.go:1327: Skipping predicate (NOT EXISTS (SELECT seed._inet AS "c͡o%ql_303" FROM d.public.seed AS "tab%q_97" ORDER BY seed._jsonb)) because it returned no rows
    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT '1974-04-05':::DATE AS "%v😓co%pl""_307" FROM d.public.seed AS tab_105 WHERE EXISTS (SELECT seed.tableoid AS col_305, NULL AS "co	l_306" FROM d.public.seed AS tab_106 WHERE false ORDER BY seed.crdb_internal_origin_timestamp ASC))
    changefeed_test.go:1327: Skipping predicate EXISTS (SELECT '1974-04-05':::DATE AS "%v😓co%pl""_307" FROM d.public.seed AS tab_105 WHERE EXISTS (SELECT seed.tableoid AS col_305, NULL AS "co	l_306" FROM d.public.seed AS tab_106 WHERE false ORDER BY seed.crdb_internal_origin_timestamp ASC)) because it returned no rows
    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._inet::INET << set_masklen(seed._inet::INET, (-2811293386950678100):::INT8::INT8)::INET::INET)::BOOL
    changefeed_test.go:1320: Skipping query SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (seed._inet::INET << set_masklen(seed._inet::INET, (-2811293386950678100):::INT8::INT8)::INET::INET)::BOOL because error pq: set_masklen(): invalid mask length: -2811293386950678100
    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE EXISTS (SELECT COALESCE(ARRAY[(-26540):::INT8], CASE WHEN true THEN COALESCE(ARRAY[704:::INT8, 12881:::INT8], ARRAY[23691:::INT8]) ELSE ARRAY[(-31979):::INT8] END) AS col_327, 2843969904:::REGPROCEDURE AS col̛_328, e'\\xa9709e1bb8':::BYTES AS "co̔L̄_329")
    changefeed_test.go:1331: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE EXISTS (SELECT COALESCE(ARRAY[(-26540):::INT8], CASE WHEN true THEN COALESCE(ARRAY[704:::INT8, 12881:::INT8], ARRAY[23691:::INT8]) ELSE ARRAY[(-31979):::INT8] END) AS col_327, 2843969904:::REGPROCEDURE AS col̛_328, e'\\xa9709e1bb8':::BYTES AS "co̔L̄_329") to emit 100 events
    changefeed_test.go:1334: Test tolerating create changefeed error: failed to start feed for job 0: pq: sub-query expressions not supported by CDC
    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (st_equals('0101000040000000000000F87F000000000000F87F000000000000F87F':::GEOMETRY::GEOMETRY, st_pointfromwkb(hmac('oc':::STRING::STRING, substr(text(e'W3))-Q\x11!':::STRING::STRING)::STRING::STRING, e'\x0b':::STRING::STRING)::STRING::STRING, e'k\\\x15.':::STRING::STRING)::BYTES::BYTES, strpos(bitmask_or(NULL::VARBIT, bitmask_xor(bitmask_xor(e'\x00':::STRING::STRING, e'\x19]\x17k\x0fZ]m':::STRING::STRING)::VARBIT::VARBIT, e'\rm':::STRING::STRING)::VARBIT::VARBIT)::VARBIT::VARBIT, B'000110101010'::VARBIT)::INT8::INT8)::GEOMETRY::GEOMETRY)::BOOL OR ((false AND (NOT true)) OR (NOT true)))
    changefeed_test.go:1327: Skipping predicate (st_equals('0101000040000000000000F87F000000000000F87F000000000000F87F':::GEOMETRY::GEOMETRY, st_pointfromwkb(hmac('oc':::STRING::STRING, substr(text(e'W3))-Q\x11!':::STRING::STRING)::STRING::STRING, e'\x0b':::STRING::STRING)::STRING::STRING, e'k\\\x15.':::STRING::STRING)::BYTES::BYTES, strpos(bitmask_or(NULL::VARBIT, bitmask_xor(bitmask_xor(e'\x00':::STRING::STRING, e'\x19]\x17k\x0fZ]m':::STRING::STRING)::VARBIT::VARBIT, e'\rm':::STRING::STRING)::VARBIT::VARBIT)::VARBIT::VARBIT, B'000110101010'::VARBIT)::INT8::INT8)::GEOMETRY::GEOMETRY)::BOOL OR ((false AND (NOT true)) OR (NOT true))) because it returned no rows
    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE bool(inet_contains_or_equals(seed._inet::INET, broadcast(seed._inet::INET)::INET::INET)::BOOL::BOOL)::BOOL
    changefeed_test.go:1331: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE bool(inet_contains_or_equals(seed._inet::INET, broadcast(seed._inet::INET)::INET::INET)::BOOL::BOOL)::BOOL to emit 92 events
    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE _st_overlaps('01030000C0010000000C0000001C8CA4C66BEFE9C109D92A5284B4FEC12CAA26BBCD4E004256C055EAA298F4C16E4D50576006F1416B41760B805CF3C130CCCC63E81FC6417C963EC0EB46F4C1EC68F1C83BF8FE4198C969E51BA3F7C1803DAA925477CAC120FEFA8D16E6B1C18879DA711835D0413011910F886FD141E858F860FB11F8412031EDE56FC9BFC1B041470D8FFFF641D03E5943894FC141DF740B72CEFEF6C11C7D3143C755E8C1928BAE20CF080142D88BF96EF406EE4112B70CD8E3C2F7415C25838F00A6FDC166E65A2D7DE2E4C118B818BBB8930142FC7D21A4552802C2A09471DA89E9E84174E394E616B3DCC1E63C054918AAF441E497D7D6C9EDE941F08BCD0C1BAFD041BA1E50A6A02EFBC1B67C413B5D3E014280C36A007CE9C141DE3A9AF1EE2002C2E08564B2DCD3C3C128110B17212CD84106F70550A22601425277CE901382F7C17B1D8CFEAF7AF5C16CB1C3FE8273E04118CD5A0BF1C8E14138184DA85578F0C11C8CA4C66BEFE9C109D92A5284B4FEC12CAA26BBCD4E004256C055EAA298F4C1':::GEOMETRY::GEOMETRY, '0106000080010000000103000080010000000B000000B41E9B731D08E8C19BAC4313FEDDFAC118C02E2E7CF9DD41C043F2EAF7F4C441104535E73572E6C18697534B79F2E7C1605F4978F754E541A44830502E82DFC1E475E5206D20F1410467D3242210F341CCF3FB70F231EFC168978C568425E1419819D9D7EE9AFB41142F2E9F50FFE24126B9503F46B3FDC1A44A62DFD9BCF44102F0E5C7EE230042D8EAD4E25D81FF4108495AE1A81BD4416646E4DF9D38004245EF578C131FF9C1C04640555808C841FAC15D435190F84184882062C45AF4C1C03DCDCC0F1EBAC1B47A528C2A9F01421C0A1FE95B0D00C2E6F09E34076EFFC13C80A6852094E541702D1071B3CEFAC1B41E9B731D08E8C19BAC4313FEDDFAC118C02E2E7CF9DD41':::GEOMETRY::GEOMETRY)::BOOL
    changefeed_test.go:1320: Skipping query SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE _st_overlaps('01030000C0010000000C0000001C8CA4C66BEFE9C109D92A5284B4FEC12CAA26BBCD4E004256C055EAA298F4C16E4D50576006F1416B41760B805CF3C130CCCC63E81FC6417C963EC0EB46F4C1EC68F1C83BF8FE4198C969E51BA3F7C1803DAA925477CAC120FEFA8D16E6B1C18879DA711835D0413011910F886FD141E858F860FB11F8412031EDE56FC9BFC1B041470D8FFFF641D03E5943894FC141DF740B72CEFEF6C11C7D3143C755E8C1928BAE20CF080142D88BF96EF406EE4112B70CD8E3C2F7415C25838F00A6FDC166E65A2D7DE2E4C118B818BBB8930142FC7D21A4552802C2A09471DA89E9E84174E394E616B3DCC1E63C054918AAF441E497D7D6C9EDE941F08BCD0C1BAFD041BA1E50A6A02EFBC1B67C413B5D3E014280C36A007CE9C141DE3A9AF1EE2002C2E08564B2DCD3C3C128110B17212CD84106F70550A22601425277CE901382F7C17B1D8CFEAF7AF5C16CB1C3FE8273E04118CD5A0BF1C8E14138184DA85578F0C11C8CA4C66BEFE9C109D92A5284B4FEC12CAA26BBCD4E004256C055EAA298F4C1':::GEOMETRY::GEOMETRY, '0106000080010000000103000080010000000B000000B41E9B731D08E8C19BAC4313FEDDFAC118C02E2E7CF9DD41C043F2EAF7F4C441104535E73572E6C18697534B79F2E7C1605F4978F754E541A44830502E82DFC1E475E5206D20F1410467D3242210F341CCF3FB70F231EFC168978C568425E1419819D9D7EE9AFB41142F2E9F50FFE24126B9503F46B3FDC1A44A62DFD9BCF44102F0E5C7EE230042D8EAD4E25D81FF4108495AE1A81BD4416646E4DF9D38004245EF578C131FF9C1C04640555808C841FAC15D435190F84184882062C45AF4C1C03DCDCC0F1EBAC1B47A528C2A9F01421C0A1FE95B0D00C2E6F09E34076EFFC13C80A6852094E541702D1071B3CEFAC1B41E9B731D08E8C19BAC4313FEDDFAC118C02E2E7CF9DD41':::GEOMETRY::GEOMETRY)::BOOL because error pq: _st_overlaps(): geos: no locations to init GEOS
    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (NOT (seed._string ~* seed._string))
    changefeed_test.go:1320: Skipping query SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE (NOT (seed._string ~* seed._string)) because error pq: invalid regular expression: error parsing regexp: missing closing ): ``(?i:v8x(G)``
    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE ((NOT true) AND true)
    changefeed_test.go:1327: Skipping predicate ((NOT true) AND true) because it returned no rows
    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE st_coveredby('010300000000000000':::GEOMETRY::GEOMETRY, '01040000C00200000001010000C0888B241C074BDDC16CFCD198A57EF941FCD8365CD4A7DAC19D40C3262561F2C101010000C0509CF1B0A16FE0C1026B983BDCA0FDC1F2511FFE8FF2FAC14043F250B9A70142':::GEOMETRY::GEOMETRY)::BOOL
    changefeed_test.go:1327: Skipping predicate st_coveredby('010300000000000000':::GEOMETRY::GEOMETRY, '01040000C00200000001010000C0888B241C074BDDC16CFCD198A57EF941FCD8365CD4A7DAC19D40C3262561F2C101010000C0509CF1B0A16FE0C1026B983BDCA0FDC1F2511FFE8FF2FAC14043F250B9A70142':::GEOMETRY::GEOMETRY)::BOOL because it returned no rows
    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE not_similar_to_escape('DXU|J:':::STRING::STRING, e'\x7fUa':::STRING::STRING, seed._string::STRING)::BOOL
    changefeed_test.go:1320: Skipping query SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE not_similar_to_escape('DXU|J:':::STRING::STRING, e'\x7fUa':::STRING::STRING, seed._string::STRING)::BOOL because error pq: not_similar_to_escape(): invalid escape string
    changefeed_test.go:1315: SELECT array_to_string(IFNULL(array_agg(distinct rowid),'{}'),'|') FROM seed WHERE ((NOT seed._bool) AND ((NOT seed._bool) OR (not_similar_to_escape(seed._string::STRING, seed._string::STRING, e'\x17\x1d\x166s\x18=':::STRING::STRING)::BOOL OR seed._bool)))
    changefeed_test.go:1331: Expecting statement CREATE CHANGEFEED WITH schema_change_policy='stop' AS SELECT rowid FROM seed WHERE ((NOT seed._bool) AND ((NOT seed._bool) OR (not_similar_to_escape(seed._string::STRING, seed._string::STRING, e'\x17\x1d\x166s\x18=':::STRING::STRING)::BOOL OR seed._bool))) to emit 55 events
    changefeed_test.go:1381: not_similar_to_escape(): invalid escape string
--- FAIL: TestChangefeedRandomExpressions/kafka (11.09s)

Parameters:

attempt=1
run=1
shard=13

Help

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

/cc @cockroachdb/cdc _{This test on roachdash | Improve this report!}

Jira issue: CRDB-48942

The text was updated successfully, but these errors were encountered:

aerfrei · 2025-03-31T17:00:12Z

This is another pgerror we can see when executing cdc expressions in this test, similar to the the ones from this PR: 89c8d02.
It seems that SQLsmith can generate queries that include calls to not_similar_to_escape but we do not expect cdc queries to handle these and this error message should therefore be ignored

The TestChangefeedRandomExpressions test could fail if sqlsmith generated a query including not_similar_to_escape. This is not supported in cdc queries and should not fail that test. Add it to the list of valid errors. Fixes: cockroachdb#143589 Release note: None

143851: changefeedccl: accept "invalid escape string" as valid pg error r=KeithCh a=aerfrei The TestChangefeedRandomExpressions test could fail if sqlsmith generated a query including not_similar_to_escape with certain regexs. Treat this error the same as "invalid regular expression" and add it to the list of valid errors. Fixes: #143589 Release note: None Co-authored-by: Aerin Freilich <[email protected]>

blathers-crl bot added the A-cdc Change Data Capture label Mar 27, 2025

aerfrei removed the release-blocker Indicates a release-blocker. Use with branch-release-2x.x label to denote which branch is blocked. label Mar 31, 2025

aerfrei added the P-2 Issues/test failures with a fix SLA of 3 months label Apr 1, 2025

aerfrei mentioned this issue Apr 2, 2025

changefeedccl: accept "invalid escape string" as valid pg error #143851

Merged

aerfrei self-assigned this Apr 3, 2025

craig bot closed this as completed in 4f82fe7 Apr 4, 2025

celeste-cockroachdb bot added the target-release-25.2.0 label Apr 4, 2025

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

ccl/changefeedccl: TestChangefeedRandomExpressions failed #143589

ccl/changefeedccl: TestChangefeedRandomExpressions failed #143589

github-actions bot commented Mar 27, 2025 •

edited by cockroach-jira-scripts

Loading

aerfrei commented Mar 31, 2025

ccl/changefeedccl: TestChangefeedRandomExpressions failed #143589

ccl/changefeedccl: TestChangefeedRandomExpressions failed #143589

Comments

github-actions bot commented Mar 27, 2025 • edited by cockroach-jira-scripts Loading

aerfrei commented Mar 31, 2025

github-actions bot commented Mar 27, 2025 •

edited by cockroach-jira-scripts

Loading