starrocks icon indicating copy to clipboard operation
starrocks copied to clipboard

Published 20 hours ago • verified publisher icon StarRocks

[sqlancer] query unknow error

Open wanpengfei-git opened this issue 3 years ago • 0 comments

Steps to reproduce the behavior (Required)

DROP DATABASE IF EXISTS n5;
CREATE DATABASE n5;
USE n5;
admin set frontend config ("enable_decimal_v3" = "true");
CREATE TABLE t0 (c_0_0 DATETIME NOT NULL,c_0_1 BOOLEAN NOT NULL,c_0_2 LARGEINT NOT NULL,c_0_3 DECIMAL(14, 11)  NOT NULL,c_0_4 DECIMAL(23, 19)  NOT NULL,c_0_5 BOOLEAN NOT NULL,c_0_6 VARCHAR(1) NOT NULL) PRIMARY KEY (c_0_0,c_0_1,c_0_2) PARTITION BY RANGE(c_0_0) (START ("2010-01-01") END ("2022-12-31") EVERY (INTERVAL 121 day)) DISTRIBUTED BY HASH (c_0_0,c_0_2) BUCKETS 3 properties("replication_num"="3") ;
CREATE TABLE IF NOT EXISTS t1 (c_1_0 VARCHAR(21) NULL ,c_1_1 DATE NOT NULL ,c_1_2 SMALLINT NULL ,c_1_3 DATE NOT NULL ,c_1_4 CHAR(11) NULL ,c_1_5 CHAR(1) NOT NULL ,c_1_6 DATETIME NULL ,c_1_7 BOOLEAN NULL ,c_1_8 FLOAT NULL ,c_1_9 ARRAY<INT> NULL ,c_1_10 BOOLEAN NOT NULL ,c_1_11 ARRAY<INT> NULL ,c_1_12 JSON NOT NULL ,c_1_13 ARRAY<STRING> NOT NULL ,c_1_14 BIGINT NULL ,c_1_15 CHAR(31) NOT NULL ,c_1_16 DOUBLE NULL ,c_1_17 TINYINT NULL ,c_1_18 VARCHAR(61) NULL , INDEX index1_c_1_3(`c_1_3`) USING BITMAP, INDEX index1_c_1_4(`c_1_4`) USING BITMAP, INDEX index1_c_1_7(`c_1_7`) USING BITMAP, INDEX index1_c_1_14(`c_1_14`) USING BITMAP, INDEX index1_c_1_17(`c_1_17`) USING BITMAP) DUPLICATE KEY (c_1_0,c_1_1,c_1_2,c_1_3,c_1_4,c_1_5,c_1_6) PARTITION BY RANGE(c_1_1) (START ("2010-01-01") END ("2022-12-31") EVERY (INTERVAL 791 day)) DISTRIBUTED BY HASH (c_1_3) BUCKETS 3 properties("replication_num"="3") ;
INSERT INTO t1 VALUES ('l9vLSGncr', '2010-01-27', 7, '2010-01-24', 'mC81IS', '', '2010-01-24 08:00:14', true, 0.5115205235692859, [], false, [-1356700484, 751290504], parse_json('{"cr10sfnr": -1356700484, "Y": 0.682449882098722, "z": 7.51290504E8, "hgTtA": false, "t57Jj": null, "uHglp9": null}'), ["V", "R", "bMQRxu", "9KYnRM", "a2GOEHLn", "", "iw", ""], 778654219, 'z', 0.36906364218505294, 3, '1'), ('5', '2010-01-28', 10, '2010-01-29', NULL, '', NULL, false, 0.3807426490630974, [-926902957, 751290504, 1885570457, 947317524, 1251090212, 88589641, -1356700484, -844274180, -780933074, -926902957, 2025348055, -1223796611, 72395636], true, [470105689, 88589641, -1356700484, 88589641, 1251090212, 88589641, -1353395308, -510074026, -2097108402], parse_json('{"yi": false, "SR2": [false, "", null, "2", 707286569, null, false], "4": 248392398, "mH": null, "eakFjpId": 0.11020476121649214, "zPg6": true, "YX": 0.3877328076250577}'), ["8ankR4", "", "v", "emhqs6i", "aOQwen", "raBcN", "", "a", "aPy4G"], 1209269894, 'tGvfOzp', 0.10934151696417371, 5, 'c'), ('', '2010-01-21', 8, '2010-01-11', 'p', '', NULL, NULL, 0.36906364218505294, [-915643827, -2111829625], false, [-679070389, -107223610, 923676019, 514772673], parse_json('{"E9RZs": null, "Ar": null, "4": -520072678, "LwA": 0.1369305163688419, "Zr": true, "9": null, "7xQ1H": 0.7706616567000917, "7T": 707286569, "43": ""}'), ["GBH4O0Kv", "", "", "5WI8HI", "BBsB3"], 150025104, 'cd4', 0.7906545610836649, 3, 'R8O');
INSERT INTO t1 VALUES ('IUrpan', '2010-01-14', 0, '2010-01-26', NULL, '', '2010-01-20 08:00:14', false, 0.007470751812945653, [-1254404267, -1336877320, 2025348055, 863061030, 11049143, -780933074, -1476349442, -653777501, 1796893961, 976787251, 940459868, -1254264392, 1969008479, 1039293830, 245758959], true, [], parse_json('{"Fy": null, "sYJJFBHr": null, "G": null, "6rGnUzzP": ["JK3jjTv8", false, false, true], "l": "1vb"}'), ["dLQ4VMuxJ", "oU", "Ii3", "3RPmYb", "X3"], 2025348055, 'Oi0', 0.5015939200478444, 0, '');
TRUNCATE TABLE t1;
INSERT INTO t1 VALUES ('Jb', '2010-01-19', 10, '2010-01-05', '', '', '2010-01-03 08:00:14', true, 0.8500427726144888, [72395636], true, [402507511, -1370824283, 2043858686, 470105689, -1230725075, 1133450910, -1895562991, 88589641, -1453531018, -1453531018, -472702076, 1796893961, 929106509], parse_json('{"BD": 0.687621831603136, "3": true, "tI": 1056015209, "9Kx": null, "x": -1, "ai": false, "d8Mp": "bIq", "FPB": true, "CSat": "AXKUM5C", "bf71BEC": "1"}'), ["", "", "h", "", "wlvmeuV5", "", "35ca", "N", "uZXP8G", "Lp2lKF", "jB", "g7KSp", "TSM", "R", "EDvvb9V"], -600374530, 'B', -6.53777501E8, 1, '');
INSERT INTO t0 VALUES ('2010-01-26 08:00:14', false, -12685604, 9.21E-9, 3.416E-16, true, ''), ('2010-01-10 08:00:14', true, 1381636332, 4.41E-9, 8.869E-16, false, '');
INSERT INTO t0 VALUES ('2010-01-07 08:00:14', true, -1230725075, 6.51E-9, 1.491E-16, true, ''), ('2010-01-17 08:00:14', false, -915643827, 5.86E-9, 4.430E-16, false, ''), ('2010-01-14 08:00:14', false, -1017548755, 5.25E-9, 1.180E-16, true, '');
INSERT INTO t1 VALUES ('e', '2010-01-13', 3, '2010-01-12', 'C', '', '2010-01-11 08:00:14', true, 0.8331582728159889, [-2111829625, -17278235, -268973116, -1075540090, -1928606050, -529659761], true, [-231728823, 1251090212, -283648412, 778654219, 1366726101], parse_json('{"Eh": false, "iHa": false, "KbRR4": true, "d": 0.9996174090483505, "5XO8": 0.8500427726144888, "l": null, "vCl5u6x": -1017548755, "Z6K": ["T", {"Mth": null, "BD": null, "d": true, "9mx": -1.07554009E9, "i": true, "aYs5h0B": true, "1": "t", "Q": "mMAyq", "6qObtaS": true, "u": "", "TwhV": 429707913, "xQbJ7": true, "s2BlT1": null, "lHAT": 0.6036112337300238}, "kW1", null, -510074026, null, 0.22614708513102977, "k", [true, 0.6223692061255834, "nBD2w", "gu0", null], [null, 254965161, null, "4aC", null, false, null, 0.46077192806161604, null, true, null, true, 132405076, 0.5281262283783867], null, null, {"o8I": null, "ftN": 2043858686, "nhz": false, "EOcxPH": 929106509, "7AhwrF": -6.53777501E8, "Th": "1QeF", "U": -1876857966, "CWx": null, "UjZhwH": false, "Dh3qDEHNG": "GT", "Hr": null}, {"qLTfi": 0.3877328076250577, "0fI0h1tCB": null, "QE": null, "0iTl3": -2058514684, "9": true, "ghi": -225023250, "gq": -802427435, "m": null, "M": 0.20081706599965565, "o": false}]}'), ["5uz", "", "k7", "Y", "rS", "", "DvG", "", "lEgv", "mjecHqYs", "", "sh", "yxHSfBI3Q", "39v", ""], NULL, '', NULL, 5, 'v'), ('3IS', '2010-01-05', 3, '2010-01-19', 'v', '', '2010-01-21 08:00:14', false, NULL, [-600374530, -1330997476, -268973116, -721817465, -994664114, 923676019, 747699851, -2108991165, -1048160561, -1654733636], true, [-717496761, -520072678, 88589641, -1645680442, -580708426, -1283592537, 1007692777, 632506471, -1485742327, -1688230310], parse_json('{"5enTnz": 144535609, "X2GoQPHU": false, "vA": 0.8580728755642595, "dDjIx076": {}, "HW": {"c3": {"g6TpsK": 1.648808623E9, "s": null, "47": 0.6036112337300238, "HkvoZLCz": 0.886515352837687, "4": null, "RFb": "V"}, "Q": {"0": null, "9J": "Kf", "arFlnS": "", "bk5ldal8": false, "vNfDfJH7N": true, "Z": true, "K": true, "J8": null, "R1": 0.8827936374551316, "L0QysCwcv": 0.5281262283783867}, "wlAb2q": 2017491872, "e": {"tWedRi": false, "izxriNR33": -1895562991, "RE": true, "M2NJFstC6": null, "C5g": true, "MC7Yfb": false, "ZV": 0.11114605143168643, "M7uW4Za": false, "smbgjr": "1", "vO8Hg": null, "OMy0y2m": null, "ML": "6kR"}, "hMjnkDe": "y8gNi", "9jj": [true, false, null, null, false], "s0": "XjPiODrM", "iX": [1648808623, "", -13006310, true, 0.5208492976196939, false, true, 0, -1688230310, true, 0.6036112337300238, null]}, "ohi05yz": 964929883}'), ["", "7y2", "", "b", "", "", "0", "tSSrXO", "", "V6QH", "1", "P", "mTV", "w8"], 1502310143, 'K', 0.34818217778414995, 4, ''), ('t', '2010-01-26', 8, '2010-01-04', '', '', '2010-01-17 08:00:14', true, 0.6195044364699819, [-721817465, 91338385, 456604975, -664107036, -1268842384, -509635007, -265247261, -1127980105, -802427435], true, [-225023250, -682767700, -2034208341, -2111829625, 514772673, 1353086837, -643000625, 581598330, -753343871, -1750892413, 400181194, 940459868, -1645680442, 1209269894, -1499522862], parse_json('{}'), ["w1"], -41566235, '6rHo', 0.018181222149265874, 4, 'Zm');
DELETE FROM t1 WHERE c_1_1='1970-01-09' AND c_1_4='TYK8' AND c_1_3='1970-01-22' AND c_1_5='' AND c_1_0='m' AND c_1_6='1970-01-12 21:55:14';
INSERT INTO t0 VALUES ('2010-01-05 08:00:14', false, 970315703, 3.92E-9, 7.033E-16, false, '');
INSERT INTO t0 VALUES ('2010-01-04 08:00:14', false, 1133450910, 6.88E-9, 4.511E-16, true, ''), ('2010-01-05 08:00:14', true, -679070389, 8.56E-9, 7.332E-16, false, ''), ('2010-01-17 08:00:14', true, -1594031458, 2.46E-9, 2.210E-16, false, '');
INSERT INTO t0 VALUES ('2010-01-31 08:00:14', true, 827616553, 5.89E-9, 9.471E-16, true, ''), ('2010-01-19 08:00:14', true, -1645680442, 3.98E-9, 3.818E-16, false, '');
INSERT INTO t0 VALUES ('2010-01-15 08:00:14', false, -641687189, 2.24E-9, 9.199E-16, true, ''), ('2010-01-06 08:00:14', true, 2050133093, 6.39E-9, 4.6E-18, true, '');
INSERT INTO t1 VALUES ('HnlHAaq', '2010-01-09', 7, '2010-01-05', 'vKeE', '', '2010-01-29 08:00:14', false, -6.827677E8, [-1017548755, 1107079909, 6924980, -1115977904, 132405076, 514772673, 1956538419, 341756914, -1303873399, -198522558, 52789604], true, [-1375716524, 2070788345, 1999267345, 2136856445], parse_json('{"b": [true, false], "zROsxTJ": 1651398821, "g": {"c0CD": -1154312112, "q6": null, "G": true, "pX": false, "hIwo": 958430360, "L": 0.291468504258122, "MS2": false, "R": true, "7K": 1186732306, "duE": 0.840383850510731, "qNW": 0.2882094687259945, "ic6": 0.0, "6S": false, "L4Oc": null}, "02BHzA": [true, null, null, false, true, true, null, false, true, false, "bk", null, 7.47699851E8], "ozE3GuS": [0.7763418907052873, 0.2668548921464713], "5QD9l": true, "Cq": 1105218348, "et": "kjXz", "Fw": {"2wqIx": null, "v": false, "dNnOZ": "8y", "pnjxph": true, "b7T": 747699851}, "t": 1092674901, "w": -1.654733636E9, "ha": "gEynt", "e4g": false, "uU4QEMe0": null}'), ["m", "tT", "", "G0", "vMs58my", "R", "WStzEQ2LC"], -394259968, 'V', 0.840383850510731, 2, ''), ('O', '2010-01-30', 3, '2010-01-16', '', '', '2010-01-05 08:00:14', false, 0.3807426490630974, [-404681432, 2038002415], true, [-1213760169, -284355149, -1353945871, -273644575, 505860856, 1517892763, -1027231843, -17278235, -727009958], parse_json('{"P": "u", "7I": -2040134564, "uAI2NC": false, "3FR20w": true, "8N1iU": 0.8500427726144888}'), ["", "nyIOv", "", "", "0Sa0br", "R", "NMrDy3W1", "pp5A0lsz", "Wb", "HGIHUyNPz", "2", "l", "e"], 1956861790, 'H', 0.7424291123251613, 3, '');
INSERT INTO t0 VALUES ('2010-01-30 08:00:14', true, 976787251, 4.21E-9, 1.737E-16, false, ''), ('2010-01-20 08:00:14', true, 1100173425, 8.0E-10, 1.531E-16, false, '');
CREATE MATERIALIZED VIEW v0 AS SELECT t1_134.c_1_1, t1_134.c_1_2, t1_134.c_1_3, t1_134.c_1_4, t1_134.c_1_5, t1_134.c_1_6, t1_134.c_1_10, t1_134.c_1_14, t1_134.c_1_16, t1_134.c_1_18, MIN(t1_134.c_1_0) , MAX(t1_134.c_1_7) , MAX(t1_134.c_1_8) , MAX(t1_134.c_1_15) , SUM(t1_134.c_1_17)  FROM t1 AS t1_134 GROUP BY t1_134.c_1_1, t1_134.c_1_2, t1_134.c_1_3, t1_134.c_1_4, t1_134.c_1_5, t1_134.c_1_6, t1_134.c_1_10, t1_134.c_1_14, t1_134.c_1_16, t1_134.c_1_18 ORDER BY t1_134.c_1_1 ASC, t1_134.c_1_2, t1_134.c_1_3, t1_134.c_1_4 DESC, t1_134.c_1_5, t1_134.c_1_6 ASC, t1_134.c_1_10, t1_134.c_1_14 ASC, t1_134.c_1_16, t1_134.c_1_18;
CREATE MATERIALIZED VIEW v0 AS SELECT t0_135.c_0_1, t0_135.c_0_4, t0_135.c_0_6, MIN(t0_135.c_0_0) , MAX(t0_135.c_0_2) , SUM(t0_135.c_0_3) , MAX(t0_135.c_0_5)  FROM t0 AS t0_135 GROUP BY t0_135.c_0_1, t0_135.c_0_4, t0_135.c_0_6 ORDER BY t0_135.c_0_1 DESC, t0_135.c_0_4 ASC, t0_135.c_0_6;
INSERT INTO t0 VALUES ('2010-01-06 08:00:14', true, -651521296, 1.90E-9, 4.903E-16, true, '');
WITH with_t_0 as (SELECT t0_139.c_0_0, t0_139.c_0_1, t0_139.c_0_2, t0_139.c_0_3, t0_139.c_0_4, t0_139.c_0_5, t0_139.c_0_6 FROM t0 AS t0_139 WHERE (t0_139.c_0_3)  BETWEEN (t0_139.c_0_3) AND (t0_139.c_0_3) ) SELECT COUNT(*) FROM  (SELECT t0_139.c_0_0, t0_139.c_0_1, t0_139.c_0_2, t0_139.c_0_3, t0_139.c_0_4, t0_139.c_0_5, t0_139.c_0_6 FROM t0 AS t0_139) subt0 LEFT ANTI JOIN (SELECT with_t_0.c_0_0, with_t_0.c_0_1, with_t_0.c_0_2, with_t_0.c_0_3, with_t_0.c_0_4, with_t_0.c_0_5, with_t_0.c_0_6 FROM with_t_0 AS with_t_0 WHERE true) subwith_t_0 ON subt0.c_0_1 = subwith_t_0.c_0_0 AND subt0.c_0_1 != subwith_t_0.c_0_0 WHERE  ( (SELECT t1_140.c_1_0 FROM t1 AS t1_140 WHERE (subt0.c_0_1)  BETWEEN (subt0.c_0_1) AND ((subt0.c_0_3)  BETWEEN (subt0.c_0_3) AND (subt0.c_0_3) ) )  ) <= ( (SELECT t1_140.c_1_0 FROM t1 AS t1_140 WHERE  ( t1_140.c_1_6 ) > ( t1_140.c_1_6 ) )  ) ;


2022-08-11 23:38:50,693 WARN (starrocks-mysql-nio-pool-5|1523) [StmtExecutor.execute():491] execute Exception, sql WITH with_t_0 as (SELECT t0_139.c_0_0, t0_139.c_0_1, t0_139.c_0
_2, t0_139.c_0_3, t0_139.c_0_4, t0_139.c_0_5, t0_139.c_0_6 FROM t0 AS t0_139 WHERE (t0_139.c_0_3)  BETWEEN (t0_139.c_0_3) AND (t0_139.c_0_3) ) SELECT COUNT(*) FROM  (SELECT t0_13
9.c_0_0, t0_139.c_0_1, t0_139.c_0_2, t0_139.c_0_3, t0_139.c_0_4, t0_139.c_0_5, t0_139.c_0_6 FROM t0 AS t0_139) subt0 LEFT ANTI JOIN (SELECT with_t_0.c_0_0, with_t_0.c_0_1, with_t
_0.c_0_2, with_t_0.c_0_3, with_t_0.c_0_4, with_t_0.c_0_5, with_t_0.c_0_6 FROM with_t_0 AS with_t_0 WHERE true) subwith_t_0 ON subt0.c_0_1 = subwith_t_0.c_0_0 AND subt0.c_0_1 != s
ubwith_t_0.c_0_0 WHERE  ( (SELECT t1_140.c_1_0 FROM t1 AS t1_140 WHERE (subt0.c_0_1)  BETWEEN (subt0.c_0_1) AND ((subt0.c_0_3)  BETWEEN (subt0.c_0_3) AND (subt0.c_0_3) ) )  ) <= 
( (SELECT t1_140.c_1_0 FROM t1 AS t1_140 WHERE  ( t1_140.c_1_6 ) > ( t1_140.c_1_6 ) )  ) ;
java.lang.IllegalStateException: null
        at com.google.common.base.Preconditions.checkState(Preconditions.java:494) ~[spark-dpp-1.0.0.jar:?]
        at com.starrocks.sql.optimizer.statistics.Statistics.getColumnStatistic(Statistics.java:56) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.ExpressionStatisticCalculator$ExpressionStatisticVisitor.visitVariableReference(ExpressionStatisticCalculator.java:62) ~[starroc
ks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.ExpressionStatisticCalculator$ExpressionStatisticVisitor.visitVariableReference(ExpressionStatisticCalculator.java:41) ~[starroc
ks-fe.jar:?]
        at com.starrocks.sql.optimizer.operator.scalar.ColumnRefOperator.accept(ColumnRefOperator.java:99) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.ExpressionStatisticCalculator.calculate(ExpressionStatisticCalculator.java:38) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.ExpressionStatisticCalculator.calculate(ExpressionStatisticCalculator.java:34) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.visitOperator(StatisticsCalculator.java:192) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.computeOlapScanNode(StatisticsCalculator.java:239) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.visitLogicalOlapScan(StatisticsCalculator.java:202) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.visitLogicalOlapScan(StatisticsCalculator.java:137) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.operator.logical.LogicalOlapScanOperator.accept(LogicalOlapScanOperator.java:120) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.estimatorStats(StatisticsCalculator.java:153) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.task.DeriveStatsTask.execute(DeriveStatsTask.java:76) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.task.SeriallyTaskScheduler.executeTasks(SeriallyTaskScheduler.java:42) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.Optimizer.memoOptimize(Optimizer.java:166) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.Optimizer.optimize(Optimizer.java:105) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.StatementPlanner.createQueryPlan(StatementPlanner.java:89) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.StatementPlanner.plan(StatementPlanner.java:54) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:348) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:316) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:429) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:667) ~[starrocks-fe.jar:?]
        at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:55) ~[starrocks-fe.jar:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_272]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_272]
        at java.lang.Thread.run(Thread.java:748) [?:1.8.0_272]


DROP DATABASE IF EXISTS d8;
CREATE DATABASE d8;
USE d8;
admin set frontend config ("enable_decimal_v3" = "true");
CREATE TABLE IF NOT EXISTS t0 (c_0_0 DATETIME NOT NULL,c_0_1 BOOLEAN NOT NULL,c_0_2 INT NOT NULL,c_0_3 VARCHAR(11) NOT NULL,c_0_4 VARCHAR(11) NOT NULL,c_0_5 BIGINT NOT NULL,c_0_6 VARCHAR(31) NOT NULL,c_0_7 DATE NOT NULL,c_0_8 DATETIME NOT NULL,c_0_9 VARCHAR(11) NOT NULL,c_0_10 VARCHAR(41) NOT NULL,c_0_11 DATETIME NOT NULL,c_0_12 DATETIME NOT NULL,c_0_13 DATETIME NOT NULL,c_0_14 DECIMAL(34, 16)  NOT NULL,c_0_15 DATE NOT NULL,c_0_16 BIGINT NOT NULL, INDEX index1_c_0_7(`c_0_7`) USING BITMAP) PRIMARY KEY (c_0_0,c_0_1,c_0_2,c_0_3,c_0_4,c_0_5,c_0_6,c_0_7,c_0_8,c_0_9,c_0_10,c_0_11,c_0_12,c_0_13) PARTITION BY RANGE(c_0_0) (START ("2010-01-01") END ("2022-12-31") EVERY (INTERVAL 316 day)) DISTRIBUTED BY HASH (c_0_6,c_0_8,c_0_11,c_0_2,c_0_3,c_0_10,c_0_5,c_0_0,c_0_12) BUCKETS 3 properties("replication_num"="3") ;
CREATE TABLE IF NOT EXISTS t1 (c_1_0 DATETIME NOT NULL ,c_1_1 INT NULL ) UNIQUE KEY (c_1_0) PARTITION BY RANGE(c_1_0) (START ("2010-01-01") END ("2022-12-31") EVERY (INTERVAL 226 day)) DISTRIBUTED BY HASH (c_1_0) BUCKETS 3 properties("replication_num"="3") ;
CREATE TABLE t2 (c_2_0 CHAR(51) NOT NULL ,c_2_1 DATETIME NOT NULL ,c_2_2 LARGEINT NULL ,c_2_3 BIGINT NOT NULL ,c_2_4 SMALLINT NOT NULL ,c_2_5 DECIMAL(33, 17)  NULL ,c_2_6 TINYINT NOT NULL ,c_2_7 BIGINT NOT NULL ,c_2_8 TINYINT NOT NULL ,c_2_9 BOOLEAN NULL ,c_2_10 CHAR(11) REPLACE_IF_NOT_NULL NOT NULL , INDEX index1_c_2_4(`c_2_4`) USING BITMAP, INDEX index1_c_2_8(`c_2_8`) USING BITMAP) AGGREGATE 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_1) (START ("2010-01-01") END ("2022-12-31") EVERY (INTERVAL 110 day)) DISTRIBUTED BY HASH (c_2_7,c_2_9) BUCKETS 3 properties("replication_num"="3") ;
CREATE VIEW v0 AS SELECT t1_100.c_1_0, t1_100.c_1_1 FROM t1 AS t1_100 WHERE (NOT (true)) ORDER BY t1_100.c_1_0;
INSERT INTO t1 VALUES ('2010-01-27 08:00:14', 7);
INSERT INTO t1 VALUES ('2010-01-08 08:00:14', 20);
INSERT INTO t0 VALUES ('2010-01-28 08:00:14', true, 7, 'p', 'W9IN', 69476548, 'jUjG', '2010-01-07', '2010-01-15 08:00:14', '6G', '', '2010-01-29 08:00:14', '2010-01-18 08:00:14', '2010-01-28 08:00:14', 34.6935069558888742, '2010-01-31', -1005997352), ('2010-01-31 08:00:14', true, 18, 'GZZ27dF', '1h4OW', -913920134, '3i', '2010-01-13', '2010-01-14 08:00:14', 'AWtj', '', '2010-01-13 08:00:14', '2010-01-13 08:00:14', '2010-01-21 08:00:14', 80.1601161456526461, '2010-01-12', -1313875519);
INSERT INTO t2 VALUES ('hNy36kvN', '2010-01-21 08:00:14', NULL, -91295271, 6, 0.06479629217812190, 5, -1313875519, 6, NULL, NULL), ('ZV', '2010-01-06 08:00:14', -2091640775, -91295271, 11, 0.02943190101295586, 4, -1512250315, 2, false, NULL);
INSERT INTO t1 VALUES ('2010-01-13 08:00:14', 8);
INSERT INTO t1 VALUES ('2010-01-16 08:00:14', 16), ('2010-01-05 08:00:14', 13);
INSERT INTO t1 VALUES ('2010-01-23 08:00:14', 27), ('2010-01-10 08:00:14', 17);
INSERT INTO t0 VALUES ('2010-01-24 08:00:14', false, 11, 'LbPS', '', -1436120801, 'B', '2010-01-19', '2010-01-03 08:00:14', '', 'pb', '2010-01-31 08:00:14', '2010-01-17 08:00:14', '2010-01-28 08:00:14', 78.4726510981907818, '2010-01-25', -523609);
INSERT INTO t1 VALUES ('2010-01-11 08:00:14', 30);
DELETE FROM t1 WHERE c_1_0='1969-12-29 21:02:16';
INSERT INTO t2 VALUES ('po', '2010-01-19 08:00:14', -1313875519, 1356438391, 5, 0.04329679291915338, 4, -1781285996, 6, true, 'P5nxy'), ('FSX', '2010-01-05 08:00:14', 533255603, 2028473188, 12, 0.09713596622231778, 4, -1436120801, 4, false, ''), ('g', '2009-12-31 08:00:14', NULL, -1816325122, 8, 0.08100007056473791, 2, -1512250315, 5, true, '');
INSERT INTO t1 VALUES ('2010-01-21 08:00:14', 11), ('2010-01-04 08:00:14', 1);
INSERT INTO t0 VALUES ('2010-01-17 08:00:14', true, 30, 'S8r', '2czr2', 69476548, '', '2010-01-28', '2010-01-20 08:00:14', '', '', '2010-01-31 08:00:14', '2010-01-30 08:00:14', '2010-01-06 08:00:14', 77.4119947366062792, '2010-01-09', -135863436), ('2010-01-31 08:00:14', true, 12, 'NH9', 'AY', -1695153987, 'c', '2010-01-22', '2010-01-06 08:00:14', '', 'SV', '2010-01-16 08:00:14', '2010-01-16 08:00:14', '2010-01-27 08:00:14', 61.4480582946221495, '2010-01-04', 699877462);
INSERT INTO t2 VALUES ('E', '2010-01-09 08:00:14', -1816325122, 1056037869, 7, NULL, 1, 399172512, 3, true, '');
INSERT INTO t1 VALUES ('2010-01-23 08:00:14', 6);
INSERT INTO t0 VALUES ('2010-01-26 08:00:14', false, 8, '', '18', -2142712571, '', '2010-01-06', '2010-01-09 08:00:14', 'M', 'k', '2010-01-22 08:00:14', '2010-01-24 08:00:14', '2010-01-30 08:00:14', 29.8958888898655932, '2010-01-17', -1695153987), ('2010-01-10 08:00:14', false, 31, 'Ly', 'gKr', 1084319300, '', '2010-01-27', '2010-01-29 08:00:14', 'Q', '', '2010-01-24 08:00:14', '2010-01-21 08:00:14', '2010-01-21 08:00:14', 45.5575992197246082, '2010-01-01', 1), ('2010-01-30 08:00:14', true, 1, 'BFE', '', -951109993, 'VzTl7Z', '2010-01-15', '2010-01-23 08:00:14', 'Po', 'EdN', '2010-01-18 08:00:14', '2010-01-02 08:00:14', '2010-01-04 08:00:14', 6.9007267706834241, '2010-01-21', -2142712571), ('2010-01-07 08:00:14', true, 27, 'ooUeJ', 'd', 869330883, 'NZo', '2010-01-31', '2010-01-07 08:00:14', 'T', 'Xf5HXFQ', '2009-12-31 08:00:14', '2010-01-13 08:00:14', '2010-01-23 08:00:14', 32.1786467629974979, '2010-01-20', -523609);
INSERT INTO t0 VALUES ('2010-01-04 08:00:14', false, 25, 'W', 'f', -1393874890, 'P', '2010-01-03', '2010-01-16 08:00:14', 'i', 'BQudfvZO', '2010-01-05 08:00:14', '2010-01-12 08:00:14', '2010-01-26 08:00:14', 13.5847386882931842, '2010-01-19', -1410740257), ('2009-12-31 08:00:14', false, 19, 'qNuT', 'ET', 869330883, 't', '2010-01-27', '2010-01-01 08:00:14', 'C', 'mHfp5O', '2010-01-18 08:00:14', '2010-01-27 08:00:14', '2010-01-21 08:00:14', 8.3382303974903460, '2010-01-29', -1219823653), ('2010-01-23 08:00:14', true, 13, '', 'wua', -1405048962, 'J', '2010-01-24', '2010-01-16 08:00:14', '', '3ZZvxL', '2010-01-10 08:00:14', '2010-01-26 08:00:14', '2010-01-16 08:00:14', 37.7117323053491826, '2010-01-06', 317165558), ('2010-01-20 08:00:14', true, 22, 'lb6y8C', 'NB', 744899597, 'uwDgnnh', '2010-01-13', '2010-01-31 08:00:14', 'VsC', 'iR', '2010-01-10 08:00:14', '2010-01-28 08:00:14', '2010-01-15 08:00:14', 2.4062379679749768, '2010-01-12', 978903277);
INSERT INTO t2 VALUES ('7jEs', '2010-01-14 08:00:14', -5643806, -437495081, 10, 0.04568929696831191, 7, 162665549, 6, true, 'jHH'), ('tIJ4v', '2010-01-02 08:00:14', -1313875519, 794988406, 4, 0.02880777678590242, 4, 2045875314, 4, false, 'OlJ');
INSERT INTO t1 VALUES ('2010-01-29 08:00:14', 12), ('2010-01-08 08:00:14', 6), ('2010-01-23 08:00:14', NULL);
INSERT INTO t0 VALUES ('2009-12-31 08:00:14', false, 1, 'ptqX', 'fUe', 1356438391, 'K1C', '2010-01-19', '2010-01-05 08:00:14', '', 'vI', '2010-01-14 08:00:14', '2010-01-19 08:00:14', '2010-01-03 08:00:14', 36.9072643823741042, '2010-01-15', -2091640775), ('2010-01-26 08:00:14', false, 17, 'Dj', 'f', -1393874890, 'KLeuw1Zl', '2010-01-25', '2010-01-08 08:00:14', 'Z', 'T3M0M36ks', '2010-01-04 08:00:14', '2010-01-17 08:00:14', '2010-01-04 08:00:14', 18.0753101691317329, '2010-01-22', -1127575307);
INSERT INTO t2 VALUES ('', '2010-01-13 08:00:14', 1143121802, 869330883, 3, 0.09373937116768992, 4, -2093477741, 5, false, 'd'), ('qT', '2010-01-08 08:00:14', 2045875314, 1519955612, 1, NULL, 6, -1147801970, 6, NULL, '8A');
INSERT INTO t0 VALUES ('2010-01-24 08:00:14', true, 0, '5', 'Gj', 427078750, '', '2010-01-06', '2010-01-03 08:00:14', '', 'vYbYSLA', '2009-12-31 08:00:14', '2010-01-05 08:00:14', '2010-01-09 08:00:14', 93.1707497675590123, '2010-01-09', -91295271);
INSERT INTO t2 VALUES ('', '2010-01-31 08:00:14', 317165558, 1650490095, 7, 0.03658849881750208, 1, 1967113655, 7, false, '');
WITH with_t_0 as (SELECT t1_107.c_1_0, t1_107.c_1_1 FROM t1 AS t1_107 WHERE  ( (SELECT t1_107.c_1_0 FROM t2 AS t2_108, v0 AS v0_109, t1 AS t1_107 WHERE CAST('' AS BOOLEAN ) )  ) >= ( (SELECT v0_109.c_1_0 FROM v0 AS v0_109, t2 AS t2_108 WHERE (t1_107.c_1_0)  BETWEEN (CAST(t1_107.c_1_1 AS DATE ) ) AND (t1_107.c_1_0) )  ) ) , with_t_1 as (SELECT t1_107.c_1_0, t1_107.c_1_1 FROM t1 AS t1_107 WHERE true) SELECT DISTINCT t1_107.c_1_0 FROM t1 AS t1_107, with_t_0 AS with_t_0, with_t_1 AS with_t_1;


java.lang.IllegalStateException: null
        at com.google.common.base.Preconditions.checkState(Preconditions.java:494) ~[spark-dpp-1.0.0.jar:?]
        at com.starrocks.sql.optimizer.statistics.Statistics.getColumnStatistic(Statistics.java:56) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.ExpressionStatisticCalculator$ExpressionStatisticVisitor.visitVariableReference(ExpressionStatisticCalculator.java:62) ~[starroc
ks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.ExpressionStatisticCalculator$ExpressionStatisticVisitor.visitVariableReference(ExpressionStatisticCalculator.java:41) ~[starroc
ks-fe.jar:?]
        at com.starrocks.sql.optimizer.operator.scalar.ColumnRefOperator.accept(ColumnRefOperator.java:99) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.ExpressionStatisticCalculator.calculate(ExpressionStatisticCalculator.java:38) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.ExpressionStatisticCalculator.calculate(ExpressionStatisticCalculator.java:34) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.PredicateStatisticsCalculator$PredicateStatisticsCalculatingVisitor.getExpressionStatistic(PredicateStatisticsCalculator.java:30
8) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.PredicateStatisticsCalculator$PredicateStatisticsCalculatingVisitor.visitBinaryPredicate(PredicateStatisticsCalculator.java:196)
 ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.PredicateStatisticsCalculator$PredicateStatisticsCalculatingVisitor.visitBinaryPredicate(PredicateStatisticsCalculator.java:32) 
~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.operator.scalar.BinaryPredicateOperator.accept(BinaryPredicateOperator.java:62) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.PredicateStatisticsCalculator.statisticsCalculate(PredicateStatisticsCalculator.java:29) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.estimateStatistics(StatisticsCalculator.java:1303) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.visitOperator(StatisticsCalculator.java:173) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.computeJoinNode(StatisticsCalculator.java:865) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.visitLogicalJoin(StatisticsCalculator.java:742) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.visitLogicalJoin(StatisticsCalculator.java:137) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.operator.logical.LogicalJoinOperator.accept(LogicalJoinOperator.java:127) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.estimatorStats(StatisticsCalculator.java:153) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.task.DeriveStatsTask.execute(DeriveStatsTask.java:76) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.task.SeriallyTaskScheduler.executeTasks(SeriallyTaskScheduler.java:42) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.Optimizer.memoOptimize(Optimizer.java:166) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.Optimizer.optimize(Optimizer.java:105) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.StatementPlanner.createQueryPlan(StatementPlanner.java:89) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.StatementPlanner.plan(StatementPlanner.java:54) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:348) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:316) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:429) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:667) ~[starrocks-fe.jar:?]
        at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:55) ~[starrocks-fe.jar:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_272]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_272]
        at java.lang.Thread.run(Thread.java:748) [?:1.8.0_272]

DROP DATABASE IF EXISTS h19;
CREATE DATABASE h19;
USE h19;
admin set frontend config ("enable_decimal_v3" = "true");
CREATE TABLE t0 (c_0_0 DATE NULL ,c_0_1 DATE NOT NULL ,c_0_2 DATETIME NULL ,c_0_3 DECIMAL(5, 2)  NOT NULL ,c_0_4 DECIMAL(12, 4)  NULL ,c_0_5 DATETIME NOT NULL ,c_0_6 JSON NOT NULL ,c_0_7 BOOLEAN NOT NULL ,c_0_8 FLOAT NOT NULL ,c_0_9 ARRAY<STRING> NOT NULL ,c_0_10 ARRAY<INT> NULL , INDEX index1_c_0_0(`c_0_0`) USING BITMAP, INDEX index1_c_0_2(`c_0_2`) USING BITMAP, INDEX index1_c_0_7(`c_0_7`) USING BITMAP) DUPLICATE KEY (c_0_0,c_0_1,c_0_2,c_0_3,c_0_4,c_0_5) PARTITION BY RANGE(c_0_1) (START ("2010-01-01") END ("2022-12-31") EVERY (INTERVAL 94 day)) DISTRIBUTED BY HASH (c_0_3,c_0_0,c_0_4,c_0_5,c_0_1,c_0_2) BUCKETS 3 properties("replication_num"="3") ;
CREATE TABLE IF NOT EXISTS t1 (c_1_0 DATETIME NOT NULL ,c_1_1 INT NULL ,c_1_2 DATE NOT NULL ,c_1_3 DOUBLE NOT NULL ,c_1_4 BOOLEAN NULL ,c_1_5 FLOAT NULL ,c_1_6 BOOLEAN NULL ,c_1_7 TINYINT NOT NULL ,c_1_8 CHAR(1) NOT NULL ,c_1_9 JSON NULL ,c_1_10 BOOLEAN NOT NULL ,c_1_11 DATE NOT NULL ,c_1_12 DATETIME NULL ,c_1_13 DECIMAL(7, 6)  NOT NULL ,c_1_14 FLOAT NOT NULL , INDEX index1_c_1_8(`c_1_8`) USING BITMAP) DUPLICATE KEY (c_1_0,c_1_1) PARTITION BY RANGE(c_1_0) (START ("2010-01-01") END ("2022-12-31") EVERY (INTERVAL 431 day)) DISTRIBUTED BY HASH (c_1_1) BUCKETS 3 properties("replication_num"="3", "bloom_filter_columns"="c_1_8") ;
INSERT INTO t1 VALUES ('2010-01-30 08:00:14', NULL, '2010-01-26', 0.050536429803313965, false, 0.6132230111262739, false, 1, '', parse_json('{"BUA5Rw": {"AVj": {"UQP": true, "7": true, "y": false, "z": false, "L": false, "hF": -871155555, "uS": -8.71155555E8}, "kPJL": ["", null, "Kr", null, false, -871155555, false, 0.36548900091592107, false, 998073306, "1"], "Z": false, "N": -871155555, "UOFF31XnZ": {"j": true, "K": 0.36548900091592107}}, "XnTH": -8.71155555E8, "1U": -8.71155555E8, "o5": -871155555, "pXSGw": [null, 2133028651, {"p": 2.133028651E9, "Z80": null, "n": false, "Zy": null, "03tsD": "OFrLOi"}, false, 0.6256905729566034, null, "", null], "l": [-157617982, 998073306, 0.6132230111262739, 0.3643731777489658, "lpK", {"o1": "", "e": 0.27889628042674797, "nEl0": null, "PLG": true, "w9vEGRai9": null, "l": null, "31HE": 0.3919917210863647, "n": "LOK", "gO8": true, "rxBWqgar": false, "8Jd2ny2YV": 0.33340965478757145, "9M": 9.98073306E8, "Z": null, "NN0lQ5": 1516363432, "Ok": true}, [null, null, null, 0.066237355687915], "rO8mqX", [-1.57617982E8, null], false, 0.24475707234042554, ["NWT", 0.36548900091592107, null, 1.516363432E9, false, null, "ps63", -2137367269, null], {"ohLN7": true, "RN5": false, "JnuY2OOUU": true}, 872992536, null]}'), false, '2010-01-13', '2010-01-04 08:00:14', 0.000004, 0.9283926144687834), ('2010-01-22 08:00:14', 31, '2010-01-24', 0.36548900091592107, false, -1.7976931348623157E308, false, 2, '', parse_json('{"Z": null, "7vh5RBb8": 0.6130020929804714, "GjkXzpJKS": null, "L": 0.8378079839014922}'), false, '2010-01-13', '2010-01-04 08:00:14', 0.000005, 0.28784307745369253);
INSERT INTO t0 VALUES ('2010-01-28', '2010-01-09', '2010-01-15 08:00:14', 5.99, 7059.9845, '2010-01-19 08:00:14', parse_json('{"l6s8BP": [null, null, true, null], "m2": 2.133028651E9, "lFsUcPfh": "x", "Y7c1R3vhO": "", "o": null}'), false, 8.72992536E8, ["Trcf", "kj", "z0sQD8", "vwbGGUr", "tcJSDSB", "ciBquY", "SN", "x", "hz", "Ltfo"], []), ('2010-01-06', '2010-01-03', '2010-01-31 08:00:14', 8.14, 6306.9201, '2010-01-23 08:00:14', parse_json('{"r4": true, "Cih": 0.6700158087701034, "Jp": "san", "o8": 1857246736, "wUh9H": 623483914, "JU7": -871155555, "0": "", "q": null, "6dS5R83o": null, "fz": -309336679, "U": 775964023, "kB": null, "1JR": false, "obIhI": false}'), true, 0.4020277256082425, ["", "lpAcOYhr", "", "", "6pLr", "ViNUQ6", "Yhp7Rt", "gh9P"], [1901777408, -2104629989, 1726944454, 1129662867]), ('2010-01-13', '2010-01-24', '2010-01-03 08:00:14', 9.41, 1176.0793, '2010-01-21 08:00:14', parse_json('{"Kg2FL2vz": -1952392677, "Q": false, "SjkZ": null, "R": true, "WVGzcH": true, "J4ctllVIn": false, "e": "", "H": 0.4080807802398726, "f0": false, "URu92BnAp": "Gz9L2", "TkJN": null, "Tq": null}'), true, 0.8882947916755042, ["4IPmUtz4", "eieHfZYU", "eq1lGpZ4", "t4", "M9yS", "", "0r", "e", "p", "wtCv78HFC", "PB"], [-159199418, -1383506186, 1516363432]);
INSERT INTO t1 VALUES ('2010-01-29 08:00:14', 27, '2010-01-24', 0.6698985556591559, false, NULL, true, 2, '', parse_json('{"XNL1jAw": ["", false, false, -375850987, false, 2133028651, -62745217, 0.6917617934167272, null, null, null], "O0dg": false, "JpNu9I3m": null, "q": -2.137367269E9, "Tlm": null, "5": "X", "BvEZ": "mot", "pjpT": 1071262337, "k43": 0.6700158087701034, "l": false, "EWN": -965382152, "n": 1516363432}'), false, '2010-01-22', '2009-12-31 08:00:14', 0.000002, 0.8454943335677249), ('2010-01-24 08:00:14', NULL, '2010-01-06', 0.40000031221038124, true, 0.8548361804461706, true, 1, '', parse_json('{"NMvMgaOuK": true, "XBz9v5x": null}'), false, '2010-01-19', '2009-12-31 08:00:14', 0.000002, 0.591143808317427);
INSERT INTO t1 VALUES ('2010-01-08 08:00:14', 9, '2010-01-25', 0.0995337735074645, NULL, 0.050536429803313965, false, 1, '', parse_json('{"a": 0.46721861829354994, "GOxDQ6": "QnhTtVxt", "q": 0.1885638694413171, "nd81WJ": 1848972457, "S": -257994311, "OS": 0.696344220876534, "pu": 1654970416, "4I": "9I6Bl", "y": false, "PF9PVmAj": false, "5D1A60Pr": true, "M": "D"}'), true, '2010-01-30', NULL, 0.000000, -2.137367269E9);
INSERT INTO t0 VALUES ('2010-01-04', '2010-01-11', '2010-01-10 08:00:14', 1.98, 3856.2129, '2010-01-24 08:00:14', parse_json('{"pm3j": true, "c": null, "Px85tKElj": true, "uWWD51CQj": 1171334812, "j": 0.8881707492514014, "sZGKVlc": null, "f5": "FDAs", "WZPE": "i8W8", "P": "X3", "KbAyiWh": -3.09336679E8, "S1P": true, "TAFw": false, "Y": 0.4068486207064794, "4nTT8pS": false}'), true, 0.30585061523576573, ["M", "", "", "jFQ"], []), ('2010-01-14', '2010-01-14', '2010-01-15 08:00:14', 6.44, 5617.0360, '2010-01-20 08:00:14', parse_json('{"uy": 961754748, "A6SKWqMU": [-159199418, true, false, -1239565312, "2t6", null, "KG8G"], "i": -1481161541, "yy5YTF": {"qff": "", "1TaIssm": true, "WwBRKxGvz": "Ur", "jSuIqrI": "kVVnw", "F": 0.9501427410771273, "V": null, "hO": null, "JjOy": true, "k": true, "oL": true, "q2KDe9nz": 1716695346}, "L": [null, null, true, true, null, null, -965382152, null], "ExrVH1Hbs": 0.15742831489896492, "P": null, "p": 0.5742506562549703, "cYYhMT8": "aaLcfkBC", "wj": ["eC9yWdze", -1992074260, 0.9042415096760071, null, false], "T": 0.39474955280076396, "gtb": {"qOa": true, "s5": null, "J": "Jpr3Z6", "Mz": true, "Ov8CzM": null, "RAOrXn": true, "gV": false, "P": false, "6G": false, "u": null, "SYhT": -1942169552, "2lp": -1899405258, "7": "", "z": false, "1OidEU8Z": true}, "Ey": -1.239565312E9, "Xiw7i1Z": {"r1": null, "JiPm": true}, "60pYJf5D": -9.65382152E8}'), true, 0.24608499213999835, [], [872992536, -1794119338, 167999741, -871155555, -1707047972, 1901777408, 352895835, 1129662867, 981131417, -760164362, -568894043]);
INSERT INTO t1 VALUES ('2010-01-20 08:00:14', 5, '2010-01-05', 0.4332084941503791, false, 6.23483914E8, true, 4, '', parse_json('{"hqJan": 1490609981, "df": 0.04168408870307305, "4": true, "e": "njIY4oF", "0X0": [-157617982, [], -1.707047972E9, "E", ["WhSaa69ME", null, null, true, null, true, 167999741, null, null, true, null, false, false, 1516363432, 116335269], [false, "2", false, false, null, 1376482104, false, "133G", true, null, null, true, 1158802116], 0.21261053660580642], "9rU": null, "yDUlH": null}'), true, '2010-01-20', '2010-01-02 08:00:14', 0.000001, 0.18541895038302791), ('2010-01-01 08:00:14', 13, '2010-01-19', 3.52895835E8, NULL, NULL, false, 3, '', parse_json('{"4SdZI": false, "OR": true, "T4C5WU": null, "x": "", "Tr": false}'), true, '2010-01-06', NULL, 0.000004, 0.3643731777489658), ('2010-01-28 08:00:14', NULL, '2010-01-22', 0.37133737982358994, false, 0.2965304400360561, false, 1, '', parse_json('{"aZzkqKJp": null, "Zj": -157617982, "QXJKXm0gd": null, "mBeYOBrqX": null, "mu": false, "y": false, "VlMLCh": 649060175, "Eq": null, "l": 0.35692884682612114, "Rtbq3DGw9": null, "FunsZYd": true}'), false, '2010-01-12', '2010-01-18 08:00:14', 0.000002, 0.1662203349622947), ('2010-01-14 08:00:14', 31, '2010-01-31', 0.1635759280227579, true, 0.4020277256082425, true, 2, '', parse_json('{"9z": 269668324, "Jk0HHV": null, "wNaJ": -1279516663, "WJX70yQbG": 1.857246736E9, "pNunIem8": -1033894427}'), false, '2010-01-17', '2010-01-23 08:00:14', 0.000007, 0.041240751857496094);
INSERT INTO t0 VALUES ('2010-01-06', '2010-01-01', '2010-01-23 08:00:14', 6.18, 9722.8044, '2010-01-27 08:00:14', parse_json('{"ii": null, "b": "HFCn5ey0", "6o": null}'), false, 0.35025506168867415, ["76w9xjfAD", "vA", "55"], [1937099127, 1863804733, -1329368310, -2731822, -1239565312]);
DELETE FROM t0 WHERE c_0_3=3.47 AND c_0_5='1969-12-09 22:36:38' AND c_0_2='1969-12-31 17:30:09' AND c_0_1='1969-12-28' AND c_0_4=9006.1289 AND c_0_0='1969-12-22';
TRUNCATE TABLE t1;
INSERT INTO t0 VALUES ('2010-01-24', '2010-01-21', '2010-01-01 08:00:14', 6.45, NULL, '2010-01-13 08:00:14', parse_json('{"qbTdLr3XF": 1490609981, "a": 0.4080807802398726, "jL": 649060175, "nP": null, "jLj": "D", "I": false, "cEw143": 2070801792, "kGG": true, "QNTWcqBRc": -1817630084, "D8": false, "e7iO": 0.36548900091592107, "w": true, "3FO": null, "4z6w2b6": true}'), true, 0.4068486207064794, ["0sZ"], [711298130, -1847979962, 1795122505, 1591440349, -1303377808]);
INSERT INTO t1 VALUES ('2010-01-16 08:00:14', 19, '2010-01-26', 0.8170874954535485, true, 0.44949601556477126, false, 3, '', parse_json('{"MspZMcQ": "x", "UB": 0.6715441987993978, "7Sbch3y": [[false, false, "01", true, null], -1.32936831E9, null, {"hH": null, "a": "jWudY50Z", "JXEnaMW": 0.3529060675233746, "e": 0.3919917210863647, "E": null, "Ne": null, "g": "dU651Mdq"}, null, 0.6917617934167272]}'), false, '2010-01-26', '2010-01-12 08:00:14', 0.000003, 0.00490097312911264), ('2010-01-27 08:00:14', 12, '2010-01-27', 0.7847954443267038, true, 0.764794289709754, true, 6, '', parse_json('{"pFjdTrM7h": -157617982, "p": 0.8263102039011172, "q": true, "KP": false, "0w": null, "cKwV": "", "CyQ": [-157617982, true, false], "ji": "X", "tC": "51GJWrUo"}'), false, '2010-01-16', '2010-01-17 08:00:14', 0.000008, 0.2475470788859181), ('2010-01-01 08:00:14', 6, '2010-01-12', 0.6812728251326916, NULL, NULL, NULL, 1, '', parse_json('{"jpk": false, "PVZ": false, "i": -1594955578, "Pw3": 0.46933642940006626}'), true, '2010-01-16', '2010-01-07 08:00:14', 0.000005, 0.37050795985837315);
INSERT INTO t1 VALUES ('2009-12-31 08:00:14', 23, '2010-01-15', 0.7821518208946259, false, -2.137367269E9, false, 3, '', parse_json('{"A": -1.942169552E9, "F": null, "Xq": false, "2zwFMq": "", "O": -7.60164362E8}'), false, '2010-01-08', '2010-01-04 08:00:14', 0.000005, 0.7531902005783518), ('2010-01-26 08:00:14', 8, '2010-01-24', 0.015339873551336813, true, -1.481161541E9, false, 2, '', parse_json('{"ZJ": -1777536794, "t": 1777653654, "KQ": {"bU": true, "5": null, "qyHQPV1U": 0.16139280500737874, "EC7": 0.5663470421821649, "vvZ6RyeX": null, "m": null, "4SjP5AmU": 636701654, "iW": "jTN", "5c": 0.6812728251326916}, "8k4x15": null, "0K4wB3D": 0.46721861829354994, "q0": "FL"}'), false, '2010-01-25', '2010-01-18 08:00:14', 0.000004, 0.06440078091432333);
INSERT INTO t0 VALUES ('2010-01-12', '2010-01-01', NULL, 5.98, NULL, '2010-01-15 08:00:14', parse_json('{"MMa": false, "fny": true, "UoGfFX": 0.43114713305976693, "C": true, "T": "y", "at49": "5C", "f": true, "JI2jgk": null, "yh9": 0.4719465732080175, "Bko6hS": null}'), false, 0.27046214113305145, ["", "mu", "sGk", "GXN", "l", "pJw", "YGrJ57Y"], [1126330734, 534735530, 1938362625, -562544453]);
INSERT INTO t1 VALUES ('2010-01-01 08:00:14', 12, '2010-01-23', 0.7921601113929743, NULL, NULL, false, 6, '', parse_json('{"ai": false}'), false, '2010-01-02', '2010-01-05 08:00:14', 0.000003, 0.7348690315104871), ('2010-01-04 08:00:14', 16, '2010-01-27', 0.16139280500737874, false, 0.7479804888369419, NULL, 6, '', parse_json('{"d4": 0.1447207959292709, "nn": false, "Q": [false, -1794119338, 0.8419650225557288], "R": {"hY54": false, "hC2h19w5R": "ABs", "gu5": 0.33340965478757145, "R4I": null, "I": 1129662867, "j92vm9Z": false, "6mprrbf": null, "1a": true, "1": null, "6d8syD": true, "hQb7rQ4": null, "UN": true, "FMEaU6s": 2017047694, "So": -1329368310, "K8P8ohG5": "tu"}, "E": false, "h": true, "xa": 46001764, "2mG": "rKqcdX7l", "wmKzQV": "P15RrZHW"}'), false, '2010-01-18', NULL, 0.000001, 0.8881707492514014);
INSERT INTO t1 VALUES ('2010-01-21 08:00:14', 13, '2010-01-11', 0.5742506562549703, true, 0.5742506562549703, true, 3, '', parse_json('{"CW": false, "P8zu": {"fYIR": ["nBRZ55Pr7", null, 386515228, "8WZ1eA88w", null, true, false], "HdFJ5SUW": 1932364097, "3V": {"ee": false, "kL": null, "iQJ": -5.68894043E8, "bTsGIL": null, "G": true, "i": null, "c56ILOg": null, "PaVfjNJk": "Y", "lLvXI": 1912214767, "T": null, "939N": "C", "K1PNpSlvd": -1922566999, "EkYO0eF": 1078186881}, "aL5r": {"lp": null, "XhiG": null, "M": false, "O": 1.516363432E9, "Db5UG1dY": 0.4536455182985213, "tdqhUhTbF": "", "rB": null, "u": -833125016, "V": 0.01288912700849787, "v": true, "nG": "VBZnw", "grrR": true, "VLR": null}}, "dbgm9r": {"IFM": "P4dPVG", "2uvIguUgU": -1942169552, "SZ": [null, 1376482104], "Tpi": -2114146092}, "Le": true, "nEPJr7Th6": [null, [1591440349, "wU", "D", null], [null], false]}'), false, '2010-01-24', '2010-01-22 08:00:14', 0.000007, 0.5584620071558515), ('2010-01-30 08:00:14', 26, '2010-01-04', 0.14405128374205634, false, 0.35228327664247316, true, 3, '', parse_json('{"rZcXC4": "aqLUnF8", "bI": null, "HjES9J3": 6.23483914E8, "YcJvM4": 0.579219604023521, "I": true, "rbHDrP7wr": [null, {"wcA": null, "XlRjhVl": "5", "vDVD": null, "EA": false}, -371924983, [false, false, true, "d5Y", null, null, false, false, true, false, "Gu", "1", 0.4919572488053796], {"qYzKOmNH": null, "jYaeBYrjV": false, "X": false, "iiUH5i": true, "yg": false, "Ji": false}, -1655117258, [null, "", true, null, -990024949, null, null, "hWslsdY", true, "4", null, 623483914, 0.6700158087701034], [null, "", "", null, false, "Nd", null, null, true, null, false, true, true, ""], 1542949167], "1ws1XL8": "34LddUy", "sW22": "", "S": [1.654970416E9, {"a": "", "fg": 0.29029673303985926, "S": true, "D": -1725352340, "U": null, "G": false, "W6jGkoV": null, "qp": false}, -1120616693, false, 167999741, [null, 0.09074008484987084, null]], "F8w4lwt2": [null, true, [null, null, 1158802116, false, null, true, 0.47549699732341044, 0.2876833472938486, 0.5740698243887552, null, null, null, null, true, 2017047694], "Vban89hU", false, null, -1303377808, [true, 1901777408, true, 0.7114028703174853, "xtpp61S", "", null, null, null, false, null, 636701654, "n", true], "WgfcfQgz"], "YV3": null, "zM0": {"BR": false, "f7": null, "B": -990024949, "J": [-1794119338], "Jt": "To0", "qVcdJF": 0.15742831489896492, "FxZtKD": {"FKIDdy": false, "LQ": null, "OW": true, "4rh": true, "8vz9hZ0": true, "l": 0.35025506168867415, "m9KBg5w": "O", "JZ": null, "BHY": null, "WcCtPlkk": "G", "W": "TnbnfM", "yr": false, "0m": false}}, "SP": "", "kH": null}'), true, '2010-01-03', '2010-01-05 08:00:14', 0.000007, 0.9655000990857106);
SELECT subt1.c_1_0 FROM  (SELECT t1_259.c_1_0, t1_259.c_1_1, t1_259.c_1_2, t1_259.c_1_3, t1_259.c_1_4, t1_259.c_1_5, t1_259.c_1_6, t1_259.c_1_7, t1_259.c_1_8, t1_259.c_1_10, t1_259.c_1_11, t1_259.c_1_12, t1_259.c_1_13, t1_259.c_1_14 FROM t1 AS t1_259) subt1 RIGHT JOIN (SELECT t0_258.c_0_0, t0_258.c_0_1, t0_258.c_0_2, t0_258.c_0_3, t0_258.c_0_4, t0_258.c_0_5, t0_258.c_0_7, t0_258.c_0_8 FROM t0 AS t0_258) subt0 ON subt1.c_1_7 = subt0.c_0_0 AND ((-776825360)/(-605606936)) != subt0.c_0_0 AND subt1.c_1_13 <= subt0.c_0_5 AND subt1.c_1_13 != subt0.c_0_5 WHERE  ( (SELECT t1_259.c_1_7 FROM t1 AS t1_259 WHERE (subt1.c_1_12)  BETWEEN (MICROSECONDS_ADD('1970-01-25 08:03:37', CAST(subt1.c_1_14 AS INT ) ) ) AND (CAST(subt0.c_0_2 AS DATE ) ) )  ) != ( subt1.c_1_7 )  GROUP BY subt1.c_1_0, CAST(subt0.c_0_1 AS STRING ) , subt0.c_0_0, subt1.c_1_11;


fe.log:
java.lang.IllegalStateException: null
        at com.google.common.base.Preconditions.checkState(Preconditions.java:494) ~[spark-dpp-1.0.0.jar:?]
        at com.starrocks.sql.optimizer.statistics.Statistics.getColumnStatistic(Statistics.java:56) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.ExpressionStatisticCalculator$ExpressionStatisticVisitor.visitVariableReference(ExpressionStatisticCalculator.java:62) ~[starroc
ks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.ExpressionStatisticCalculator$ExpressionStatisticVisitor.visitVariableReference(ExpressionStatisticCalculator.java:41) ~[starroc
ks-fe.jar:?]
        at com.starrocks.sql.optimizer.operator.scalar.ColumnRefOperator.accept(ColumnRefOperator.java:99) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.ExpressionStatisticCalculator$ExpressionStatisticVisitor.visitCastOperator(ExpressionStatisticCalculator.java:101) ~[starrocks-f
e.jar:?]
        at com.starrocks.sql.optimizer.statistics.ExpressionStatisticCalculator$ExpressionStatisticVisitor.visitCastOperator(ExpressionStatisticCalculator.java:41) ~[starrocks-fe
.jar:?]
        at com.starrocks.sql.optimizer.operator.scalar.CastOperator.accept(CastOperator.java:68) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.ExpressionStatisticCalculator$ExpressionStatisticVisitor.lambda$visitCall$0(ExpressionStatisticCalculator.java:142) ~[starrocks-
fe.jar:?]
        at java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193) ~[?:1.8.0_272]
        at java.util.ArrayList$ArrayListSpliterator.forEachRemaining(ArrayList.java:1384) ~[?:1.8.0_272]
        at java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:482) ~[?:1.8.0_272]
        at java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:472) ~[?:1.8.0_272]
        at java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708) ~[?:1.8.0_272]
        at java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234) ~[?:1.8.0_272]
        at java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:566) ~[?:1.8.0_272]
        at com.starrocks.sql.optimizer.statistics.ExpressionStatisticCalculator$ExpressionStatisticVisitor.visitCall(ExpressionStatisticCalculator.java:142) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.ExpressionStatisticCalculator$ExpressionStatisticVisitor.visitCall(ExpressionStatisticCalculator.java:41) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.operator.scalar.CallOperator.accept(CallOperator.java:173) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.ExpressionStatisticCalculator.calculate(ExpressionStatisticCalculator.java:38) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.ExpressionStatisticCalculator.calculate(ExpressionStatisticCalculator.java:34) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.visitOperator(StatisticsCalculator.java:192) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.computeOlapScanNode(StatisticsCalculator.java:239) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.visitLogicalOlapScan(StatisticsCalculator.java:202) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.visitLogicalOlapScan(StatisticsCalculator.java:137) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.operator.logical.LogicalOlapScanOperator.accept(LogicalOlapScanOperator.java:120) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.estimatorStats(StatisticsCalculator.java:153) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.task.DeriveStatsTask.execute(DeriveStatsTask.java:76) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.task.SeriallyTaskScheduler.executeTasks(SeriallyTaskScheduler.java:42) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.Optimizer.memoOptimize(Optimizer.java:166) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.Optimizer.optimize(Optimizer.java:105) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.StatementPlanner.createQueryPlan(StatementPlanner.java:89) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.StatementPlanner.plan(StatementPlanner.java:54) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.StmtExecutor.execute(StmtExecutor.java:348) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:316) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:429) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:667) ~[starrocks-fe.jar:?]
        at com.starrocks.mysql.nio.ReadListener.lambda$handleEvent$0(ReadListener.java:55) ~[starrocks-fe.jar:?]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_272]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_272]
        at java.lang.Thread.run(Thread.java:748) [?:1.8.0_272]

StarRocks version (Required)

  • You can get the StarRocks version by executing SQL select current_version()
  • mysql> select current_version(); +----------------------+ | current_version() | +----------------------+ | MAIN-RELEASE e8ba97d | +----------------------+

wanpengfei-git avatar Aug 12 '22 07:08 wanpengfei-git