[sqlancer] crash when executing query

[dulong41]

Steps to reproduce the behavior (Required)

1. CREATE TABLE '...'
2. INSERT INTO '....'
3. SELECT '....'

DROP DATABASE IF EXISTS d12;
CREATE DATABASE d12;
USE d12;
admin set frontend config ("enable_decimal_v3" = "true");
CREATE TABLE IF NOT EXISTS t0 (c_0_0 DATE NOT NULL ,c_0_1 ARRAY<INT> NOT NULL ) UNIQUE KEY (c_0_0) PARTITION BY RANGE(c_0_0) (START ("2010-01-01") END ("2022-12-31") EVERY (INTERVAL 135 day)) DISTRIBUTED BY HASH (c_0_0) BUCKETS 3 properties("replication_num"="3") ;
CREATE TABLE IF NOT EXISTS t1 (c_1_0 DATE NOT NULL ,c_1_1 LARGEINT NULL ,c_1_2 DATE NOT NULL ,c_1_3 CHAR(1) NULL ,c_1_4 DECIMAL(30, 20)  NULL ,c_1_5 DATETIME NULL ,c_1_6 FLOAT NOT NULL ,c_1_7 BOOLEAN NULL ,c_1_8 ARRAY<INT> NOT NULL ,c_1_9 ARRAY<STRING> NOT NULL ,c_1_10 INT NULL ) DUPLICATE KEY (c_1_0) PARTITION BY RANGE(c_1_0) (START ("2010-01-01") END ("2022-12-31") EVERY (INTERVAL 263 day)) DISTRIBUTED BY HASH (c_1_0) BUCKETS 3 properties("replication_num"="3", "bloom_filter_columns"="c_1_1") ;
CREATE TABLE t2 (c_2_0 DATE NOT NULL ,c_2_1 INT NOT NULL ,c_2_2 BOOLEAN NOT NULL ,c_2_3 BOOLEAN NULL ,c_2_4 DECIMAL(26, 18)  NOT NULL ,c_2_5 SMALLINT NOT NULL ,c_2_6 BIGINT NOT NULL ,c_2_7 DATE NOT NULL ,c_2_8 DECIMAL(35, 10)  NULL ,c_2_9 VARCHAR(51) NOT NULL ,c_2_10 CHAR(21) NOT NULL ,c_2_11 BOOLEAN NOT NULL ,c_2_12 BOOLEAN NOT NULL ,c_2_13 VARCHAR(1) NULL ,c_2_14 VARCHAR(31) NULL ,c_2_15 DOUBLE NULL ,c_2_16 BOOLEAN NOT NULL ,c_2_17 ARRAY<INT> NOT NULL ,c_2_18 DECIMAL(17, 5)  NULL ) UNIQUE KEY (c_2_0,c_2_1,c_2_2,c_2_3,c_2_4,c_2_5,c_2_6,c_2_7,c_2_8,c_2_9) PARTITION BY RANGE(c_2_0) (START ("2010-01-01") END ("2022-12-31") EVERY (INTERVAL 182 day)) DISTRIBUTED BY HASH (c_2_6,c_2_5,c_2_9,c_2_1,c_2_8,c_2_7) BUCKETS 3 properties("replication_num"="3") ;
INSERT INTO t0 VALUES ('2010-01-27', [-1428600826, -1428600826, -1428600826]), ('2010-01-14', [-535441640, 1725011445]);
INSERT INTO t1 VALUES ('2010-01-01', -203923421, '2010-01-24', '', 9.410147749E-11, '2010-01-04 08:00:14', 0.17632807059729227, true, [-1166910224, 1725011445, -1166910224], ["yoI", "761RI", "", "VJWE", "M", "ek", "", "5Pew", "", "GYa", "VVg", ""], 14);
INSERT INTO t1 VALUES ('2010-01-02', 46191983, '2009-12-31', '', 4.653792254E-11, '2010-01-28 08:00:14', -1.166910224E9, true, [1968279354, 2136126066, -1174893871, 1826794269, 46191983, -203923421, -892997256, -973774990, 1968279354], ["CfnLfrl", "Va", "C"], 7), ('2010-01-19', NULL, '2010-01-27', NULL, 4.082505959E-11, '2010-01-31 08:00:14', 0.17632807059729227, false, [1968279354, -679647234, 909639583], ["0jZ", "", "", "", "", "J", "ww3ob"], 10), ('2010-01-11', -1784487627, '2010-01-14', '', 7.274901312E-11, '2010-01-23 08:00:14', 0.5126818613664658, true, [1971103827, 2027706737, -510237736, -679647234, -1166910224, 817446804], ["pTzs", "wanq8"], 17);
INSERT INTO t0 VALUES ('2010-01-04', [333457613, -1731666321, -1833955123, -535441640, -1568050200, -535441640, -1575674283, 333457613, -1074706109, 815949512]), ('2010-01-19', [-512202002, -1016440750, -256740182, -813717814]), ('2010-01-01', []);
CREATE MATERIALIZED VIEW v0 AS SELECT t0_167.c_0_0 FROM t0 AS t0_167;
CREATE VIEW v0 AS SELECT t0_170.c_0_0, t0_170.c_0_1, t2_172.c_2_0, t2_172.c_2_1, t2_172.c_2_2, t2_172.c_2_3, t2_172.c_2_4, t2_172.c_2_5, t2_172.c_2_6, t2_172.c_2_7, t2_172.c_2_8, t2_172.c_2_9, t2_172.c_2_10, t2_172.c_2_11, t2_172.c_2_12, t2_172.c_2_13, t2_172.c_2_14, t2_172.c_2_15, t2_172.c_2_16, t2_172.c_2_17, t2_172.c_2_18 FROM t0 AS t0_170, t2 AS t2_172 WHERE true ORDER BY t2_172.c_2_1, t2_172.c_2_3, t2_172.c_2_8, t2_172.c_2_16, t2_172.c_2_15, t2_172.c_2_13, t2_172.c_2_3, t2_172.c_2_10, t2_172.c_2_15, t2_172.c_2_15, t2_172.c_2_16, t2_172.c_2_10;
INSERT INTO t1 VALUES ('2010-01-05', NULL, '2010-01-25', '', 8.25949610E-12, '2009-12-31 08:00:14', 0.5109775968080823, false, [-1004683309, -1731513027, -857076874, -1025707256], ["3", "", "SJVaHlhZp", "SRp4", "s5U", "e14fGS0V", "", "XWl2oneOl", "", "l", "", "p", "", "", "I"], 29), ('2010-01-15', 814722949, '2010-01-03', '', NULL, '2010-01-18 08:00:14', 0.9759157023270741, true, [2027706737, -974627687, -466708891, -1044030241, -535441640, -2037642478, -1820761804, -759047806, 855569974, -1025707256, 1028929808], ["1X", "9guR"], NULL), ('2010-01-04', -857076874, '2010-01-17', '', 4.762296618E-11, '2010-01-08 08:00:14', 0.5109775968080823, true, [683795258, -1784487627, -203923421, 817446804, -1166910224, 1725011445, 68729856, 1241109802, 815949512, 1099282295, 876135876, -857076874, -857076874, -512202002, -1401948337], ["f3", "", "", "", "", "", "JzF2PGGl"], 19);
INSERT INTO t0 VALUES ('2010-01-22', [-177590918, 2027706737, -974627687, 329341396, 1241109802, 1725011445, -1428600826, -699281366, -973774990, 604321448, 1734012160]);
INSERT INTO t0 VALUES ('2010-01-15', [1971103827, -1496050679, -1784487627, 951855532, -1174893871, 1971103827, -1166910224, -597090392, -635021091, 2130262587, -1904799204, 682345750, -1338888592, -1651665967]), ('2010-01-25', [46191983, -1568050200, -2085798206, -242059914]);
INSERT INTO t0 VALUES ('2010-01-14', [1475411627, 1453614787, -1636386905, -1061863933, -1401948337, -1428600826, 320946309, 329341396, 683795258, 1028929808, -966210091]);
TRUNCATE TABLE t0;
INSERT INTO t2 VALUES ('2010-01-17', 15, true, false, 3.6628112E-11, 15, 703921872, '2010-01-26', 319362465946764.6509369843, 'N', 'T', true, true, '', NULL, NULL, false, [], NULL), ('2010-01-10', 17, false, true, 4.9199912E-11, 1, -902179836, '2010-01-24', 682731021794618.9752070006, 'X4', 'zYChbLg', false, true, NULL, '', 0.05294851904373743, false, [46191983, 326347268, -636576406, -922236758, -2036510618, -849915060, 1013922623, -1497469481, 1241109802, -1044030241, 745600792, 93495344], 8120403.65894), ('2010-01-14', 22, true, true, 8.4813834E-11, 12, -201401078, '2010-01-14', 587369111950626.3547123170, 'qzjH', 'B', false, true, '', 'uk', 0.9759157023270741, true, [-1053860375, -849915060, -780400270, 1807487015, 93495344, -349173016, 2040921735, 186963887, 604321448, 1028929808, 1519157297, -2076439344, -719206815, -39513613, 1826794269], 269834.82248);
INSERT INTO t2 VALUES ('2010-01-24', 3, true, false, 8.2217800E-11, 9, -1097429831, '2010-01-24', 869704499761934.5352291573, 'n', 'm0', false, true, NULL, 'u', -8.13717814E8, false, [-392883904, -1061863933], 2735609.00326), ('2010-01-11', 26, false, true, 3.8757391E-11, 0, 1515354397, '2010-01-21', 219506681252389.5904973874, 'sy', 't', true, true, '', NULL, NULL, false, [9223372036854775807, 2068533410, -2076439344, -450599827, 1635819980, 1519157297, 1738408227, -1218213045], 239101.75432), ('2010-01-07', 7, true, true, 9.4077732E-11, 10, -1024087315, '2010-01-01', 879015383724374.8213836625, 'mJ', 'gwIS', true, false, '', 't', 0.5109775968080823, true, [-1638359378, -114288077, 656567034], 3780758.15385);
INSERT INTO t0 VALUES ('2010-01-26', [-164392480, 1434503231, -1833955123, 817446804, 516230746, -1166910224, -277022786]), ('2010-01-09', [-910508953, 683795258, 1475411627, -495891518, -2135221969]);
INSERT INTO t1 VALUES ('2010-01-05', 670840392, '2010-01-17', '', 6.923725483E-11, '2010-01-02 08:00:14', 0.48449808778733894, false, [990425465, -1016440750, 1339527346, -563084830, 1696964076, 2027706737], ["gEGIAPPP", "", "2n", "Su", "E2", "", "hSpALQ"], 0), ('2010-01-15', NULL, '2010-01-25', '', 1.494230915E-11, '2010-01-03 08:00:14', 0.6970394936088213, true, [-638999281, -1284307815, -141107802, 326347268], ["MBrRBVb8", "dN", "Eiy", "Fq", "ioOxfQ7", "7", "F"], 3);
INSERT INTO t0 VALUES ('2010-01-01', []), ('2010-01-24', [-1777777805, 533493062]);
INSERT INTO t0 VALUES ('2010-01-24', [-1963196042]), ('2009-12-31', [-1780509726]);
INSERT INTO t0 VALUES ('2010-01-06', [1, -1428600826, -704903995, 1958306830, 531677089]), ('2010-01-29', [-460896187, 1475411627, 1013922623, 1772364718, 1734012160, 864070607, -1488028775, -965704297, -1061863933, -1820761804, 1734012160, 720944306]);
INSERT INTO t0 VALUES ('2010-01-01', [959684350, 1131513406, -94911318, -1460626836, -759047806, -780400270, -1404204612, 682345750, 534664341, -177590918, -2085798206, -1578920021, 765417439]), ('2010-01-23', [-1401948337, -586229551, 1515354397, -1698909779, -135353317, 235218971, 1849193099, -1507231799, 1635819980, -679647234]);
INSERT INTO t0 VALUES ('2010-01-14', [1732726737]);
INSERT INTO t0 VALUES ('2010-01-19', [-1855047065, -221428330, 1343789133, 817446804, -1122710424, 1019635211, -922236758, 351830688, -21289605]), ('2010-01-04', [-1450560860, 1264204683, -1104225790, 604343799, -1080429518, 909639583, -450599827, 333457613, 1221745434, -1125303987, 46191983, 752961287]), ('2010-01-22', [93495344, -323258933, -1681409399, -1817446850, -2064878108]);
INSERT INTO t1 VALUES ('2010-01-22', 1510123089, '2010-01-28', '', 7.12888586E-12, '2010-01-14 08:00:14', 0.7714758344294707, false, [-368342224, -743875394, 1464381795, -719206815, 1748376927, -1820761804, -1559687315, 428507647, -537668183, -1782559587], ["y", "WAuEesg5", "", "v1", "GT", "Tx", "", "e", "", "81q5", "h8n", "X", "w", "7k3bQze5X", "2"], 11), ('2010-01-02', NULL, '2010-01-21', '', 9.302341616E-11, NULL, 0.9759157023270741, false, [1264716426, -2037642478, 855569974, -450599827], ["", "5r", "jU", "MnufoP", "g", "B", "S6", "1", "GQtv7if"], 27);
INSERT INTO t2 VALUES ('2010-01-18', 2, true, true, 4.4626569E-11, 6, 1319394194, '2010-01-14', NULL, '4Z', 'iBRSvV', false, false, '', 'xB9', 0.33907445193537833, true, [2079311072, 2040921735], 7363818.74264), ('2010-01-21', 23, false, true, 6.2686971E-11, 14, 1968279354, '2010-01-04', 469975760083209.5150167334, 'CDNzUR0R3', 'tOr', false, true, '', '01LtrL', 0.38463227757409735, true, [-1230463004, -1137220082, 204698449, 1942790377, -55317905, -1285787574, 1227205989, 1778832418, 1784579725, -242059914], 4816760.56414);

SELECT DISTINCT '1970-01-15' FROM t0 AS t0_177, v0 AS v0_180,  (SELECT t1_178.c_1_0, t1_178.c_1_1, t1_178.c_1_2, t1_178.c_1_3, t1_178.c_1_4, t1_178.c_1_5, t1_178.c_1_6, t1_178.c_1_7, t1_178.c_1_10 FROM t1 AS t1_178 WHERE CAST(CAST(((t1_178.c_1_4) IS NOT NULL) AS BOOLEAN )  AS BOOLEAN ) ) subt1 LEFT ANTI JOIN (SELECT t2_179.c_2_0, t2_179.c_2_1, t2_179.c_2_2, t2_179.c_2_3, t2_179.c_2_4, t2_179.c_2_5, t2_179.c_2_6, t2_179.c_2_7, t2_179.c_2_8, t2_179.c_2_9, t2_179.c_2_10, t2_179.c_2_11, t2_179.c_2_12, t2_179.c_2_13, t2_179.c_2_14, t2_179.c_2_15, t2_179.c_2_16, t2_179.c_2_18 FROM t2 AS t2_179 WHERE  ( t2_179.c_2_1 ) >= ( t2_179.c_2_1 ) ) subt2 ON subt1.c_1_10 = subt2.c_2_10 AND subt1.c_1_10 = subt2.c_2_10;

Expected behavior (Required)

pass

Real behavior (Required)

mysql> SELECT DISTINCT '1970-01-15' FROM t0 AS t0_177, v0 AS v0_180, (SELECT t1_178.c_1_0, t1_178.c_1_1, t1_178.c_1_2, t1_178.c_1_3, t1_178.c_1_4, t1_178.c_1_5, t1_178.c_1_6, t1_178.c_1_7, t1_178.c_1_10 FROM t1 AS t1_178 WHERE CAST(CAST(((t1_178.c_1_4) IS NOT NULL) AS BOOLEAN ) AS BOOLEAN ) ) subt1 LEFT ANTI JOIN (SELECT t2_179.c_2_0, t2_179.c_2_1, t2_179.c_2_2, t2_179.c_2_3, t2_179.c_2_4, t2_179.c_2_5, t2_179.c_2_6, t2_179.c_2_7, t2_179.c_2_8, t2_179.c_2_9, t2_179.c_2_10, t2_179.c_2_11, t2_179.c_2_12, t2_179.c_2_13, t2_179.c_2_14, t2_179.c_2_15, t2_179.c_2_16, t2_179.c_2_18 FROM t2 AS t2_179 WHERE ( t2_179.c_2_1 ) >= ( t2_179.c_2_1 ) ) subt2 ON subt1.c_1_10 = subt2.c_2_10 AND subt1.c_1_10 = subt2.c_2_10;
ERROR 1064 (HY000): Backend not found. Check if any backend is down or not

be.out
terminate called after throwing an instance of 'std::length_error'
what(): vector::_M_range_insert
query_id:a97a0317-5fc9-4fe5-87b1-13543e0a493f, fragment_instance:a97a0317-5fc9-4fe5-87b1-13543e0a4940
*** Aborted at 1668052008 (unix time) try "date -d @1668052008" if you are using GNU date ***
PC: @ 0x7fb6d8959387 __GI_raise
*** SIGABRT (@0x3e800007962) received by PID 31074 (TID 0x7fb65d9b3700) from PID 31074; stack trace: ***
@ 0x4825332 google::(anonymous namespace)::FailureSignalHandler()
@ 0x7fb6d940e630 (unknown)
@ 0x7fb6d8959387 __GI_raise
@ 0x7fb6d895aa78 __GI_abort
@ 0x1c4b44f _ZN9__gnu_cxx27__verbose_terminate_handlerEv.cold
@ 0x62a7bb6 __cxxabiv1::__terminate()
@ 0x62a7c21 std::terminate()
@ 0x62a7d74 __cxa_throw
@ 0x1c4d033 std::__throw_length_error()
@ 0x1e35732 std::vector<>::_M_range_insert<>()
@ 0x1e389c4 starrocks::vectorized::BinaryColumnBase<>::append()
@ 0x21ef7a7 starrocks::pipeline::NLJoinProbeOperator::_permute_probe_row()
@ 0x21efe7f starrocks::pipeline::NLJoinProbeOperator::_permute_chunk()
@ 0x21f1507 starrocks::pipeline::NLJoinProbeOperator::pull_chunk()
@ 0x1e57e23 starrocks::pipeline::PipelineDriver::process()
@ 0x3c95d43 starrocks::pipeline::GlobalDriverExecutor::_worker_thread()
@ 0x3762a65 starrocks::ThreadPool::dispatch_thread()
@ 0x375df8a starrocks::Thread::supervise_thread()
@ 0x7fb6d9406ea5 start_thread
@ 0x7fb6d8a21b0d __clone
@ 0x0 (unknown)

core stack:
#0 0x00007fb6d8959387 in raise () from /lib64/libc.so.6
#1 0x00007fb6d895aa78 in abort () from /lib64/libc.so.6
#2 0x0000000001c4b44f in __gnu_cxx::__verbose_terminate_handler() [clone .cold] ()
#3 0x00000000062a7bb6 in __cxxabiv1::__terminate(void ()()) ()
#4 0x00000000062a7c21 in std::terminate() ()
#5 0x00000000062a7d74 in __cxa_throw ()
#6 0x0000000001c4d033 in std::__throw_length_error(char const) ()
#7 0x0000000001e35732 in void std::vector<unsigned char, starrocks::raw::RawAllocator<unsigned char, 16ul, std::allocator > >::_M_range_insert<unsigned char const*>(__gnu_cxx::__normal_iterator<unsigned char*, std::vector<unsigned char, starrocks::raw::RawAllocator<unsigned char, 16ul, std::allocator > > >, unsigned char const*, unsigned char const*, std::forward_iterator_tag) [clone .constprop.0] ()
#8 0x0000000001e389c4 in starrocks::vectorized::BinaryColumnBase::append(starrocks::vectorized::Column const&, unsigned long, unsigned long) ()
#9 0x00000000021ef7a7 in starrocks::pipeline::NLJoinProbeOperator::_permute_probe_row(starrocks::RuntimeState*, std::shared_ptrstarrocks::vectorized::Chunk) ()
#10 0x00000000021efe7f in starrocks::pipeline::NLJoinProbeOperator::_permute_chunk(starrocks::RuntimeState*) ()
#11 0x00000000021f1507 in starrocks::pipeline::NLJoinProbeOperator::pull_chunk(starrocks::RuntimeState*) ()
#12 0x0000000001e57e23 in starrocks::pipeline::PipelineDriver::process(starrocks::RuntimeState*, int) ()
#13 0x0000000003c95d43 in starrocks::pipeline::GlobalDriverExecutor::_worker_thread() ()
#14 0x0000000003762a65 in starrocks::ThreadPool::dispatch_thread() ()
#15 0x000000000375df8a in starrocks::Thread::supervise_thread(void*) ()
#16 0x00007fb6d9406ea5 in start_thread () from /lib64/libpthread.so.0
#17 0x00007fb6d8a21b0d in clone () from /lib64/libc.so.6

StarRocks version (Required)

• You can get the StarRocks version by executing SQL select current_version()
  mysql> select current_version();
  +----------------------------+
  | current_version() |
  +----------------------------+
  | BRANCH-2.4-RELEASE cc3c302 |
  +----------------------------+
  1 row in set (0.01 sec)