starrocks
starrocks copied to clipboard
Published
20 hours ago •
StarRocks
StarRocks
query result error
trafficstars
Steps to reproduce the behavior (Required)
DROP DATABASE IF EXISTS w15;
CREATE DATABASE w15;
USE w15;
admin set frontend config ("enable_decimal_v3" = "true");
CREATE TABLE IF NOT EXISTS t0 (c_0_0 CHAR(1) NULL ,c_0_1 INT NULL ,c_0_2 DATE NOT NULL ,c_0_3 BIGINT NOT NULL ,c_0_4 SMALLINT NULL ,c_0_5 BOOLEAN NOT NULL ,c_0_6 DATE NOT NULL ,c_0_7 DECIMAL(12, 3) NOT NULL ,c_0_8 ARRAY<INT> NULL ) UNIQUE 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) PARTITION BY RANGE(c_0_2) (START ("2010-01-01") END ("2022-12-31") EVERY (INTERVAL 153 day)) DISTRIBUTED BY HASH (c_0_6,c_0_2) BUCKETS 3 properties("replication_num"="3", "bloom_filter_columns"="c_0_0") ;
CREATE TABLE IF NOT EXISTS t1 (c_1_0 DATE NULL ,c_1_1 BOOLEAN NULL ,c_1_2 SMALLINT NULL ,c_1_3 BOOLEAN NULL ,c_1_4 ARRAY<INT> NOT NULL ,c_1_5 JSON NULL ,c_1_6 CHAR(1) NULL ,c_1_7 VARCHAR(11) NULL ) DUPLICATE KEY (c_1_0,c_1_1,c_1_2) PARTITION BY RANGE(c_1_0) (START ("2010-01-01") END ("2022-12-31") EVERY (INTERVAL 182 day)) DISTRIBUTED BY HASH (c_1_2,c_1_0) BUCKETS 3 properties("replication_num"="3") ;
INSERT INTO t1 VALUES (NULL, true, 7, false, [-1938951462, 1935928862, -1938951462], parse_json('{"w": "P", "Ah": [null, null, -1680418621, false, null], "SMLmqb": 530025622}'), '', 'iv');
INSERT INTO t1 VALUES ('2010-01-11', true, 1, true, [-1680418621, 530025622, -1680418621], parse_json('{"IJV": null, "ek": 1935928862, "NCoGwZe3": null, "V0LGrYL1": 1118149720}'), '', '2');
INSERT INTO t1 VALUES ('2010-01-15', true, 1, false, [-1321059728, 1786644020], parse_json('{"vZ8": {"P": null, "G": -811406928, "vabZf9N": false}, "h": false}'), '', '6y');
INSERT INTO t1 VALUES ('2010-01-21', true, 6, false, [747152624, -430539008, 1118149720, 2127667603], parse_json('{"RrVpR": "N4T", "A": 0.35135720161655715, "ws2GyUS": 1030909425, "q5": null, "nVN3qcmHP": true, "H": false, "xC4g": -108723805, "ozERhnJ": null, "BdZ8q2a4": null, "ca": true}'), '', 'Io');
INSERT INTO t0 VALUES ('', 23, '2010-01-24', 1730559595, NULL, true, '2010-01-25', 82557.301, [1292300869, -136730551, -1290225045, 1935928862, -2022806996, -2022806996, -2022806996, 1380757652, 1155287629, 2127667603, -1290225045, 69557164, 604860462, 643079901]);
INSERT INTO t0 VALUES ('', 2, '2010-01-08', 9223372036854775807, 3, true, '2010-01-12', 407022.504, [449695286, -1683999041, -413427866, -923855042, -129573506, 1831110532, 1476033309]), ('', 16, '2010-01-02', 1831110532, 10, true, '2010-01-04', 764754.147, [1625640297, -2046938164, -681840275, -1066430293, 332804852, -1772033890]), ('', 27, '2010-01-12', 530025622, 6, false, '2010-01-10', 932384.663, [785947911, 461141482, 771528435, -923855042, 604860462, 1118149720, -1066430293]);
INSERT INTO t0 VALUES ('', 27, '2010-01-03', 1900173520, 2, false, '2010-01-10', 334522.331, [-1785351451, 826082541, 556034360, -2046938164, -129573506, 512689937, 970337040, 821447494, 747152624, -1669211505, 1002828331, 461141482]);
INSERT INTO t0 VALUES ('', 31, '2010-01-21', 1831110532, 0, false, '2010-01-08', 417058.102, [1464459690, -811406928, 1002828331, 2108291216, 1625640297, 1332228393, -1105230898, -1290225045, -597609596, 821447494, 1]), ('', 27, '2010-01-22', 364985466, 14, true, '2010-01-19', 408351.374, [-809440648, -67311876, -637915714, 332804852, -954315127, 452418048, 747152624, 1286783691, 69557164, -1278247615, -1669211505, 1730559595, 970337040]);
INSERT INTO t0 VALUES ('', NULL, '2010-01-27', 840351561, 14, true, '2010-01-01', 736756.020, [1247586401, 1457438384, 530025622, 2096084444, -136730551, -293835951, 578964650, -430539008, 951390092, -1290225045, -129573506, -1935403799, 1030909425]);
INSERT INTO t0 VALUES ('', 13, '2010-01-06', -508453111, 5, false, '2010-01-18', 426274.489, [2088238105, 181737105, 1957347985, 1115920654, 1002828331]), (NULL, 6, '2010-01-01', 306392824, 7, true, '2010-01-15', 733713.978, [-108723805, -1249170764, 1876275394, 181737105, -650052807, 273411131, 604860462, 2023478400, -820294822]), ('', 1, '2010-01-13', 1295267639, 8, false, '2010-01-20', 560431.163, [1609761833, 1292300869, 28164977, 1641466144, 1876275394, 1443228703, -2095301303, -125163138, 1443228703, 2046101154, -1760926032, -859849331, 1831110532]);
INSERT INTO t1 VALUES ('2010-01-26', false, 5, false, [-1066430293, 834237547, 1295267639, 207755657], parse_json('{"6jIYznI": true, "1": 1.935928862E9, "pr": null, "lQ": "gQfA", "j": 0.2856100765966545, "hsWW": 5.7896465E8, "an": null}'), '', 'xyBC'), (NULL, true, 1, false, [-275083989, 20350742, 0, -1680418621, -779727265], parse_json('{"Td": 0.2856100765966545}'), '', 'a0S');
INSERT INTO t0 VALUES ('', 30, '2010-01-05', -885437745, 6, true, '2010-01-14', 685214.432, [-820294822, -1632122035, -517678896, 840351561, 273411131, 1641466144, 721250245, -293835951, 1429547331, -152143697, -650052807]), ('', 2, '2010-01-14', -1657475260, 3, true, '2010-01-02', 635852.891, [-519153949, 866004664, -2010118828, 345460817, -1347697757, 1757894123, 623883789, 942212607, 332804852, 1115920654, 771528435, -1604232293, 209690893, 712217935]);
INSERT INTO t1 VALUES ('2010-01-03', false, 0, false, [694489842, -1645109106, -1584854017, -492778788, -1638531823, 1787081972, -192729962, 1523219547, -363092275, -968290900, 1975100489, 876376851, -1365753742, 749499091, -189431805], parse_json('{"2S": true, "yCrEqYR": -8.85437745E8, "C": false, "t": 273411131, "Xa": null, "3xYarFVN": null, "m": null, "EjOaTD": null, "n": null}'), '', NULL), ('2010-01-17', false, 9, false, [1155287629, -885437745, 1730559595], parse_json('{"jc6e7mm": 8.34237547E8, "cF": null, "X3Fv": {"0": null, "VV": 0.880754558440645, "oyP5bpHxt": null, "T": "4", "Pkr": 821447494, "zQm": -72489794, "YVZK": false, "X": 0.9347438829284209, "Z": null, "yxs7Dw": -1674861308, "j7": true, "t88CSJN": null}, "DMPIVU88m": [false], "LMknhiz": "epk", "d": "4", "5": "", "i": 0.12300914869173563, "xhH": {"Uux7yNebh": null, "zZ8bYHE": true, "oZ5": 0.3572888804982164, "O": "W", "1": "", "q": 0.9340727552824042, "V": 72454472, "6": "AFl", "hzV6TEab": true, "W": true, "0j": null, "KJM0a": null, "pL": true, "vanVF": 0.31657481201559545}, "qK": 0.35135720161655715, "N": true, "n": [null, null, false, false, null, true, 0.31657481201559545, false, 0.8821033544709623, -1090679771]}'), '', 'u');
INSERT INTO t1 VALUES ('2010-01-08', NULL, 7, false, [-129573506, 721250245, -954315127, -1669211505, 1476033309, -472451426, -1899774374, 832258604, -822686887, 1594357775, -324798515, -1952732670, -400260364], parse_json('{"s3": true, "fhrt6orrB": null, "B": null, "Lgb": false, "JP": "Dnk", "iQN": -842509308, "ndA": 0.5414697059536099, "o8gVy8HKY": 0.9779306831283846, "m": "", "yEX": "aA", "o": 0.9340727552824042, "dX": false, "x": "6x9zF", "wIr7PGj1H": null}'), '', 'c'), ('2010-01-26', false, 1, true, [-1178361094, -508453111, 1625640297, 1786644020, -67311876], parse_json('{"00iuF": "", "Y": "7", "QjVpTMXF": null}'), NULL, '5lhtKCvq'), ('2010-01-10', false, 14, true, [671806549, 1012178815, 658729703, -637915714, -15268600, 2109892541, 1167132858, 1758392416, -1890531533, -1422267185, -627537380, -129573506, 1486192160, -130836943, 115497610], parse_json('{"HW5KRjCp": -851962784, "0CIgjK2": {"h": 0.5744304916017732}, "F51W": [{"9prIyI3mK": null, "walY": true, "xfmMf": false, "ZMx": null, "BW": null, "sPWZ8jdM": "HyrMu1", "F": -2125691177, "myb": null, "x": null, "ks": null, "JxTG2GsRF": -2094928284, "kYe2MhfK": null}, {"dLJP": "IoY", "uPje": true, "Uw": null, "l": null, "n": null, "S": "g8", "s": 556034360, "he2": 0.5744304916017732, "JnWdB": true, "7": 2.046101154E9, "8Yr15R": 0.31657481201559545, "GGyKD": null, "6P": null, "Z": true, "VZKfz": true}, 776183952, false, "7oyiM", [68168344, false, true, false], {"g5ttfm": false, "2": false, "wgiJ": null, "Mc": null, "aLbHXKL": -108723805}, [null, "09", "jW", 0.2279816485564502, null, true, 328211034, "Zg", false, 0.4716235546924724, -112624897, "", false, true]], "1y": null, "k": [{"SdaNnH": false, "Z": null, "L": 0.8190579587542226, "ms4": "M"}, "78", null, false, [null, null, null, true, 1923504309, null, true, 1507693379, 0.35135720161655715, true], false, 0.6244543135009234, -2046938164, [null, null, true, null, true, 0.3703343926345183, true, true, false, false, "a", null, false], ["e", null, -1221701976, "MwNonYfa"], true, 1637882194], "tKCu": {"A": null, "C": -1312085167, "d": 460540677, "T": false, "E": [771528435, null, "UX", -293835951], "U": false, "Mc": 69557164, "BoxAgU": {"U5": 0.5744304916017732, "noWbZw": null, "ym": 0.06272280436751831, "uk": 0.5408826368611905, "FOVZf": 0.9263138600275852, "9": 0.258626596328429, "Xk0v6MJX": -517678896}, "dIk": {"P": null, "nBlJ": null, "Q": false, "ZOxRry": "vw3t", "N1": 102979260, "E": 0.831483152116189, "vboR": -954315127, "j2r": "", "6Zs": 0.12300914869173563}, "JQ": 0.620644600868485, "u0": 0.12300914869173563, "l": "ToWOSRZ11"}, "Q1L": false, "nLKcLo": {"p": false, "6bFejH4nY": [true, "", false, false, null, false, true, null, true, null, null, false, true], "ez": "I", "hU4": -5.97609596E8, "Y1B": 1115920654, "EqfW": "", "X6": [null], "o": [null, false, -557486160, true, null, null, null, true, 0.7425259439704583, 1957347985, false, true, -1.7976931348623157E308, null, false]}}'), '', '');
INSERT INTO t1 VALUES ('2010-01-01', false, 1, false, [-1935403799, 1641466144, 1247586401, 295955894, 333263449, -1348555420, -1252083845], parse_json('{"T2kE0HLhZ": true, "672": 1.78664402E9, "4": {"2": true, "G": false, "BEAs7TZT": null, "TzAt4Q": "s", "w8769Jwa": true}, "oNt": [null, 0, null, true, false, null, "mYmjv6hZI", null, 0.36033034214285486, null, false, 679599529], "eeRqgzk0": 12759691, "v": {"8H": -1.066430293E9, "AYQ8": null, "oP4": 0.9779306831283846, "HaWTpI": -568434053, "h0DLpNNTL": "SLP1", "WQk2TNZqh": -1278247615, "gcpy": "", "66V": null, "OlF": 1464459690, "Up": false, "X89eE": true, "9SqUqi": 1.295267639E9}, "Q8": "co", "GE": [false, false, 0.6790287854389122], "sQ": -421470424}'), '', ''), ('2010-01-22', false, 0, true, [], parse_json('{"zfhU": null, "cjssJ1c": "Es9TZ", "d": -1.08723805E8, "99d": null, "NC": 0.9219619167444837, "yTQE": false, "k": "Jj5", "DrnL": "EQMTx", "YsNVjxysU": true, "7Fq7K": null}'), '', '77H3f2t'), ('2010-01-31', true, NULL, NULL, [422419541, 1952467824, -1445376790, -1733051756, 1052850681, 1113814704], parse_json('{"vIv": {"KQMWV": [0.5490583422357965, "23nYf", true, -551662999, null], "c": null, "3te": 0.8740744387035099, "VAO": false, "g": 1030909425, "ht": 0.6014575091152488, "O": 0.5406494704056168, "3": 1740929341, "h0mZVz": 1.247586401E9, "QIxVlnL": ["aTm4acgAg", false, 0.06451490305830554, null, 0.455158920860673, 0.427742135578435, "zRj", null, 0.831483152116189, null, "Ksd1BW", null, -838505565, null], "jLOz": {"UPT": -772179337, "YB": true, "zC": null}, "Um4": false, "QN": ["", null, false, 0.9849131598164723, true, false], "GkJE": 1295267639}, "PxVlfHe": [null, [false], 0.5606576758174652], "hOWD": [true, [false, 0.45515861112645695, 1900173520, false, true, null, "qZkc", true, -1657550774, true, 1900173520], 2.096084444E9, "fmpxkQli"], "BwQ5": {"Vy": true, "T": [null, "nmww", null, "", 1154426318, -859392092, false, -481505795, true, -190297778, null, null, 0.427742135578435, null], "2i": null, "w": {"Naa0W1": 0.9131926825333921, "H": true, "L": null, "6C": true, "Hu": null, "1dtZ": -636862970, "Gv": "b7Dr7nM7", "ZaEtF": "olZJxJk", "S": "ng", "zpj": 449695286, "zfYrxKo": null, "Dl6awe8T": true, "z": 0.6244543135009234, "oj": -561031938}, "LXfIoJqqg": false, "Fa6": true, "LJH8Ni": null, "wmOO1v": 1115920654}, "qDmyo": "rYE", "kU": 0.3415287965245075, "qNTP8n8Z": 0.9155837183376868, "pGK": [true, [null, false, false, false, null, 0.991521743652963, true, "", -251205298, 1881525147, null, 1431485980], {"1": 0.9441980865297356, "Kho": "MiVT", "u": 683807505, "7qo": null, "m3": false, "w": 332804852, "o8hs": false, "4K": true, "A99UyWRs": true, "gq2qZbvH": null, "i6": 1734997031, "O": "YbVw"}, null, {"jJ": -980498169, "hWVJIvM": null, "H": false, "cfT8": false, "J": null, "4F6W": -5.17678896E8, "Cnn0": "o", "0": null, "q": "xE", "2IW1B": true, "QxMdj8": "0j", "nhom1g9": 0.8073331998375392, "z": null, "qD5rUCBQH": 0.0340692719106207}], "jag7": [false, null, 0.9865897613639392, "0b", "", -275083989], "FIA6": 0.0025640312458008463, "8tY": false, "Pn": -2023234274, "DC57QUc": "58jvYe9"}'), '', '');
INSERT INTO t0 VALUES ('', 1, '2010-01-12', -1856810409, 4, true, '2010-01-04', 262320.797, [-885437745, 990462644, 41955100, -125163138, 940227090, -125163138, -78403687, -1263938590, -712138278]);
INSERT INTO t1 VALUES (NULL, true, 12, false, [2118287933, 165820232, -1285405115, -480454288, 1158915844], parse_json('{"KNc": null, "b3jRJLPN": "RiNk", "txRU": [{"W5cmPUT": null, "d": true, "fvch": "j", "W": null, "S6Y5": false, "vcTE": false, "PRuuHrv": 0.23347505885467035, "XfqrzZAJB": false}, -866119848, {"1P6hz2x": -221864598, "r": 0.4359260694810442, "M0": "", "bXlGi": true, "WIUKuD81o": true, "M": false, "xTEy7maTP": "68BlSkBi", "qp": ""}, [-2141847152, -9.23855042E8, false, null, 1850210196, true, false, "fFSih8m0l", 188795748, "d", "KHA", false], [0.36033034214285486, false, null, "", 308396776, "D", null], false, {"qQZN": null, "f": true, "J": null, "TcHb": -1680418621, "lJO": true, "JiRD": "", "nIBh": true, "t0kvRE0Q": null, "A6": null, "ARF": null, "rg": "", "DxPnPpM": null, "lynN": true}], "aaADFoS2": null, "gL": [0.9230861075818526, [false, "ym"], -669284316, 0.9182714832708858, null, [null], true, null, 1771010420, -2034368573, {"H08VKte": 720035125, "V4kKwg": 0, "2": null, "b": ""}], "5": {"P": true, "Ot9x": null, "u": true, "F": -517678896, "hofnQ9e9b": [false, "", null], "Gv2Q": 892358639, "Emtz6fU": false, "TXaNbT": 1447199608, "sr": null}, "X": -1627729100}'), '', NULL), (NULL, NULL, 13, NULL, [-1467397602, 785947911, -948090436, 1014172323, 2046101154], parse_json('{"lxnoVBof": null, "7": null, "izBA4ka": null, "Z": "H", "StYJkM": 1961883136, "hR": -1.683999041E9, "Ep": null, "l": "9", "m": true, "Xh2zYQaNi": true, "Jmq": null}'), NULL, 'W6h3');
INSERT INTO t1 VALUES ('2010-01-22', true, 0, false, [66858594, 1831110532, -1632122035, 2062059834, -2058171805, 1464459690, -1938951462, 1314266655], parse_json('{"Q": false, "NS": null, "ko61Rv1c": null, "8": "a", "3DK6s": 0.5977308798449991, "9cc": 585688325, "btol2K": 1571290783, "dJxxD": null, "CxXiHiv3": 297733207, "An9xY85": ""}'), '', NULL), ('2010-01-27', true, 14, false, [-1129845403, 452418048, 1373524313, -1253737161], parse_json('{"9j": false, "qB": true, "GAK5z": -637915714, "T": false, "Wi2jX": null, "JIIOOvI": 1904194952, "6": "RC", "uK": null, "UFBv73": 0.2856100765966545, "XR": null}'), '', ''), ('2010-01-02', true, 0, NULL, [], parse_json('{"2Zh": "j5", "A": false, "uU4i": false, "JnTlt0": "J", "f": 1295267639, "w": 0.5744304916017732, "JB5siWoi7": null, "6r": null, "Myg0al": null}'), '', 'xa'), ('2010-01-20', false, 0, false, [-407603566], parse_json('{"x8wDrB1Yo": 0.35135720161655715, "ik": true, "C": null, "TkmwV": null, "Aob3HaK": 0.5279952530258368, "UF": false, "HceG3Y4": null, "V": true, "qW8o0Wm": -5.08453111E8, "IA": null, "OG": true, "Y": null, "Wq": false, "zPwUdiRH2": 511526028}'), NULL, 'Kl');
INSERT INTO t1 VALUES ('2010-01-15', false, 3, true, [-809440648, 1457438384, 1292300869, 61075970], parse_json('{"2": [""], "7bzeoIl": 0.6428806021767631, "F": -1165709880, "fXXxaG": false, "gxrCRBi": null}'), '', 'Q0'), ('2010-01-04', false, 12, true, [1778770423, -2015197429, -301242522, 1258680748, 380606496], parse_json('{"LYikUl2N0": null, "yhdM": "He", "vIgK": [[false, "UR6f"], 2096084444, {"fs5uO": null, "P": null, "DZaV8ta": null, "6v": 1.11814972E9, "Kx6P": null, "2H": 1717168597, "L3": true, "H": "DD", "HVe0": -808981973, "oj": false}, 461141482, [null, 921856692, -1278247615, 366593170, 0.4674478669140748, -1935403799, null, true, "BWtigZUaG", 0.21400563930451344, 1888608842], false, "0", true, false, [null]], "Q": [true, {"e": true, "7W7V": -1347176177}, [], 0.9398121717978497, {}, [null, "IbKOUD2l", false, "1", "x", 9.7033704E8, "", 0.21945035036163096, "Cq", 1.831110532E9, null, "a3"], -136730551, {"QKf0o": false, "ex": true, "BtEjz": null, "w8CA": 971607244, "Y": 1690872095, "i": false, "Wn4M05m": "Y", "xMd": false, "RxT": false, "gf": true}], "B": "w8OdU", "IL": 0.5634943906763488, "C": false, "yg6": "", "5zB": true, "o": null}'), '', 'bQ'), ('2010-01-11', true, 7, false, [-2046938164, -129573506, 530025622, -235280600, -597609596, -1099972901, -1984531472, 1476033309, -1739742509, 757080092], parse_json('{"1": [true, {"7zT5flY": "a", "Ekg": 1115920654, "5h": null, "kUoHLPAE": -854580470, "IJqVXq0US": "U6", "L6": true, "i5Xg5": -1789627448, "L": "", "tcaM": null}, [null, -1201234443, 0.33493010209207186, null, 0.5495003796379848, true, true, true, "Xm", 0.7049761805909679, null, "Swhr"], [false, true, false, "Sf", -1466461244, null, 141686512, null, 0.11369986467941606], [false, false, true, false, 0.7164356596331181, null, 1380757652, 0.6768740845632674, true], 181737105, {"q": 0.7055580425241865, "RD4f": true, "D7": true, "oTbIP": null, "Ala": null, "7P": 0.5495003796379848, "uGFArN": true, "NZwI": 181737105, "PT37yWz19": null, "s2agu6": "NPMYZVprR", "H9P": 0.2469999845796491}, true, [0.599497887044272, "nFFY", true, false, "pg", null, "", null, null, false, 0.6421226124318764, "Mez57"], {"g57jH3F": true, "lp": 8.26082541E8, "G": 1030909425, "8": null}, 1095745081, [false, 0.6127793528504333, true, null, 1115920654, null, true, 0.21945035036163096, "FB", false, true]], "eN8l": {"Ex": true, "BwJ": 0.0340692719106207, "AW": true, "h": [true, -1396610539, false], "hN5NUj": "LH4XB", "t9kA": [-1928537271, 673927949, false, "Scd4G", "qgxz7C", "Bv63bKVdL"]}, "vTYy0K4b": false, "7kXp": 1676762915, "ORfRKC": 0.933664734765918, "G": false, "X2": null, "mX4PZri": null}'), '', 'RRK');
INSERT INTO t0 VALUES ('', 10, '2010-01-03', 997543366, 9, true, '2010-01-28', 293180.207, [-534795796, 1712222384, 688073282, -1760926032, 1900173520, -203763815, -681840275, 1875157383, -2106668405, 1720393294]), ('', 10, '2010-01-02', 751803756, 5, false, '2010-01-17', 7328.256, [2027683806]), ('', 21, '2010-01-13', 721250245, 14, true, '2010-01-16', 411779.283, [461141482, -206379526, 1397617158, -1023245948, 1934755536, -1005233893, -278108582, 1487048833, -809440648, -1809616109, 452418048]);
INSERT INTO t1 VALUES ('2010-01-04', true, 4, false, [-254027502, 904219402, 2100890803, 656669749], parse_json('{"2": -1.278247615E9, "r": "Zv", "S": -2008997225, "T": true, "U": 0.9206536202929666, "e": true, "qG": null, "H5FjWVgTy": null, "Oye2e": null, "tcE2mhO": 2.088238105E9}'), '', 'X'), ('2010-01-30', false, 3, false, [2105308586, 1491710314, 207755657], parse_json('{"A": [null, 332804852, false, null, false, null, false, null, 0.738626330618827, true, null, true, 0.03587761736248252, null, 1332228393], "3UYr": true, "1oboM": [-1295062525, true, 0.023925615708650594, 935687155, true, 306392824, 0.9632969242074472], "mHb": 167980902, "IzX": {"uU": false, "BHO6ZUQ": "0U1M9", "lo": false, "TxH": null, "k": true, "42M": null, "2zY": false, "1": null, "U": true, "5": 1273475579, "JVuVzUOZc": false, "ay": -466477534, "2J": false, "U3": null}, "o1xrRt": [0.16960427147760637], "MZ": "z0ko", "n": "Gzq", "2": false, "vWDky": {"0": -1037010682, "W0dDB7t": null, "aLBqADS": -1897899011, "Pqz": 0.9259962721126023, "o": 0.9097152025274006}, "lC": {"DEadbG4m": -637915714, "Wg": null, "81J": "", "dRZsj": -313216843, "f": 933511944, "F": 2108291216, "h": 0.18221546502494967, "gG8KG": 1900173520, "Y": 245060333, "nHLBiC1r1": true, "uDkFUU5": true, "Xtrwa": "A83"}, "7": ["T2I", 0.7109196781891479, null, 2.0234784E9, null], "o2Y": 0.14198774973114847, "lI": ""}'), '', '');
INSERT INTO t1 VALUES ('2010-01-13', false, 11, false, [2046101154, 784468072], parse_json('{"0wp6JpiDt": null, "XI": 667644444, "LUSGyQxcS": false, "ne": false, "Ssxx": 3.32804852E8, "f6Gw4uT2d": 1399203835, "VHth56": {"6Y": null, "6c": 0.9140261093451028, "uc": 771528435, "Fck5Sd": {"6TcoLx": null, "dqfU": null, "F": 995079642, "7OvZ3FH": "", "x": -1993542948, "vdkueN": false}, "ptlu59cm": {"2": 0.620644600868485, "9L": 1957192533, "D": null, "x": null, "4c0db5rXM": 0.6926887545754952, "J": 0.991521743652963, "HMQZC": null}, "ssP": {"RETmtX": null, "B": "4ql2YRF", "8GIF": null, "Lw": 1741728707, "Nj": true, "5OvAOW": null}, "q": "M", "yK": 2073143478, "Re": "YU", "cvMHJ": false, "ccXp": [false, false, 1, 0.9182714832708858, null], "v": {"9MVj": 0.6921326803329888, "jUzTtDyQf": 1680942780, "bNVy6Fsm": false, "BY": "", "g": null, "XFMx6Z3": 0.7182211700211931, "Hb": false, "WJXzYEOcc": 0.46085494808933725, "h4aS": true}, "V": "l", "W9nTvw6Ga": "", "vBQ2wWD": {"1": "3dj1", "H": null, "o8A": 0.9807178439582477}}, "UO": null, "YVf8a": [[true, null, true, null, true, false, -570559859, true, false, ""], "ff", ["O", false, 0.04276513737974874, 332804852, true, 578964650, 578964650, "WlHh", true, -1334425238, null, false, -2046938164], ""], "m8lo": -1249170764, "d0Bw": null}'), '', '');
CREATE VIEW v0 AS SELECT t0_160.c_0_0, t0_160.c_0_1, t0_160.c_0_2, t0_160.c_0_3, t0_160.c_0_4, t0_160.c_0_5, t0_160.c_0_6, t0_160.c_0_7, t0_160.c_0_8, t1_161.c_1_0, t1_161.c_1_1, t1_161.c_1_2, t1_161.c_1_3, t1_161.c_1_4, t1_161.c_1_5, t1_161.c_1_6, t1_161.c_1_7 FROM t0 AS t0_160, t1 AS t1_161 WHERE true ORDER BY t1_161.c_1_1, t0_160.c_0_1, t0_160.c_0_3, t0_160.c_0_4, t0_160.c_0_2, t1_161.c_1_6, t0_160.c_0_4, t0_160.c_0_7, t1_161.c_1_6, t0_160.c_0_6, t0_160.c_0_3, t0_160.c_0_3, t0_160.c_0_0;
-- SELECT v0_167.c_0_0 FROM v0 AS v0_167 LEFT JOIN t0 AS t0_165 ON v0_167.c_1_2 = t0_165.c_0_1 AND v0_167.c_1_2 = t0_165.c_0_1 AND v0_167.c_0_4 >= t0_165.c_0_6 AND v0_167.c_0_4 < t0_165.c_0_6;
-- cardinality: 357
-- SELECT v0_167.c_0_0 FROM v0 AS v0_167 LEFT JOIN t0 AS t0_165 ON v0_167.c_1_2 = t0_165.c_0_1 AND v0_167.c_1_2 = t0_165.c_0_1 AND v0_167.c_0_4 >= t0_165.c_0_6 AND v0_167.c_0_4 < t0_165.c_0_6 WHERE CAST(t0_165.c_0_5 AS BOOLEAN ) UNION ALL SELECT v0_167.c_0_0 FROM v0 AS v0_167 LEFT JOIN t0 AS t0_165 ON v0_167.c_1_2 = t0_165.c_0_1 AND v0_167.c_1_2 = t0_165.c_0_1 AND v0_167.c_0_4 >= t0_165.c_0_6 AND v0_167.c_0_4 < t0_165.c_0_6 WHERE (NOT (CAST(t0_165.c_0_5 AS BOOLEAN ) )) UNION ALL SELECT v0_167.c_0_0 FROM v0 AS v0_167 LEFT JOIN t0 AS t0_165 ON v0_167.c_1_2 = t0_165.c_0_1 AND v0_167.c_1_2 = t0_165.c_0_1 AND v0_167.c_0_4 >= t0_165.c_0_6 AND v0_167.c_0_4 < t0_165.c_0_6 WHERE ((CAST(t0_165.c_0_5 AS BOOLEAN ) ) IS NULL);
-- cardinality: 442
StarRocks version (Required)
- You can get the StarRocks version by executing SQL
select current_version() - mysql> select current_version(); +----------------------+ | current_version() | +----------------------+ | MAIN-RELEASE e8ba97d | +----------------------+
