text:
[sqlancer] unknow error

Steps to reproduce the behavior (Required)
DROP DATABASE IF EXISTS v11;
CREATE DATABASE v11;
USE v11;
admin set frontend config ("enable_decimal_v3" = "true");
CREATE TABLE IF NOT EXISTS t0 (c_0_0 DATETIME NOT NULL,c_0_1 DATETIME NOT NULL,c_0_2 FLOAT NOT NULL) PRIMARY KEY (c_0_0,c_0_1) PARTITION BY RANGE(c_0_0) (START ("2010-01-01") END ("2022-12-31") EVERY (INTERVAL 153 day)) DISTRIBUTED BY HASH (c_0_0) BUCKETS 3 properties("replication_num"="3") ;
CREATE TABLE t1 (c_1_0 DATETIME NOT NULL ,c_1_1 BOOLEAN NOT NULL ) DUPLICATE KEY (c_1_0) PARTITION BY RANGE(c_1_0) (START ("2010-01-01") END ("2022-12-31") EVERY (INTERVAL 98 day)) DISTRIBUTED BY HASH (c_1_0) BUCKETS 3 properties("replication_num"="3") ;
CREATE TABLE IF NOT EXISTS t2 (c_2_0 DATETIME NOT NULL ,c_2_1 DATE NULL ,c_2_2 SMALLINT NULL ,c_2_3 BOOLEAN NOT NULL ,c_2_4 CHAR(11) NOT NULL ,c_2_5 VARCHAR(31) NOT NULL ,c_2_6 CHAR(11) NOT NULL ,c_2_7 DATE NOT NULL ,c_2_8 CHAR(11) NOT NULL ,c_2_9 DECIMAL(8, 4)  NOT NULL ,c_2_10 BOOLEAN NULL ,c_2_11 DECIMAL(17, 11)  NOT NULL ,c_2_12 VARCHAR(1) NOT NULL ,c_2_13 DATETIME NOT NULL ,c_2_14 BOOLEAN NOT NULL ,c_2_15 DECIMAL(24, 3)  NOT NULL ,c_2_16 BOOLEAN NULL ,c_2_17 BOOLEAN NULL ,c_2_18 ARRAY<INT> NOT NULL , INDEX index1_c_2_8(`c_2_8`) USING BITMAP) DUPLICATE 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,c_2_10,c_2_11,c_2_12,c_2_13,c_2_14,c_2_15,c_2_16,c_2_17) PARTITION BY RANGE(c_2_0) (START ("2010-01-01") END ("2022-12-31") EVERY (INTERVAL 139 day)) DISTRIBUTED BY HASH (c_2_13,c_2_7,c_2_4) BUCKETS 3 properties("replication_num"="3") ;
INSERT INTO t1 VALUES ('2010-01-08 08:00:14', true);
INSERT INTO t2 VALUES ('2010-01-31 08:00:14', NULL, 13, true, '9', 'Aq', 'ew', '2010-01-04', 'MqzKl3Sg8', 0.1037, true, 0.00000215987, '', '2010-01-08 08:00:14', true, 216735606197673431.786, false, true, [1276906457, -1493105545, -2021723370, 1073883125, -190394447, -238791723, -1988775753]), ('2010-01-08 08:00:14', '2010-01-14', 7, false, '', 'OZT2', 'w', '2010-01-01', 'd', 0.9598, true, 0.00000246145, '', '2010-01-15 08:00:14', true, 996382295928770279.116, false, true, [-1557623199, 194662602, 194662602, 716230046, 272767082, -1748297090, -1988775753, -1101291077]);
DELETE FROM t0 WHERE c_0_1='1969-12-16 11:20:36' AND c_0_0='1969-12-16 11:20:36';
INSERT INTO t0 VALUES ('2010-01-03 08:00:14', '2010-01-19 08:00:14', 0.7373940165194264);
INSERT INTO t0 VALUES ('2010-01-12 08:00:14', '2010-01-08 08:00:14', -1.988775753E9), ('2010-01-12 08:00:14', '2010-01-10 08:00:14', -1.493105545E9);
CREATE VIEW v0 AS WITH with_t_0 as (SELECT t1_6291.c_1_0, t1_6291.c_1_1 FROM t1 AS t1_6291 WHERE false) , with_t_1 as (SELECT t1_6291.c_1_0, t1_6291.c_1_1 FROM t1 AS t1_6291 WHERE  ( t1_6291.c_1_0 ) != ( t1_6291.c_1_0 ) ) SELECT t1_6291.c_1_0 FROM t1 AS t1_6291, with_t_0 AS with_t_0, with_t_1 AS with_t_1;
CREATE VIEW v1 AS WITH with_t_0 as (SELECT t1_6291.c_1_0, t1_6291.c_1_1 FROM t1 AS t1_6291 WHERE false) , with_t_1 as (SELECT t1_6291.c_1_0, t1_6291.c_1_1 FROM t1 AS t1_6291 WHERE  ( t1_6291.c_1_0 ) != ( t1_6291.c_1_0 ) ) SELECT t1_6291.c_1_0 FROM t1 AS t1_6291, with_t_0 AS with_t_0, with_t_1 AS with_t_1 WHERE false;
CREATE VIEW v2 AS WITH with_t_0 as (SELECT t1_6291.c_1_0, t1_6291.c_1_1 FROM t1 AS t1_6291 WHERE false) , with_t_1 as (SELECT t1_6291.c_1_0, t1_6291.c_1_1 FROM t1 AS t1_6291 WHERE  ( t1_6291.c_1_0 ) != ( t1_6291.c_1_0 ) ) SELECT t1_6291.c_1_0 FROM t1 AS t1_6291, with_t_0 AS with_t_0, with_t_1 AS with_t_1 WHERE (NOT (false));
CREATE VIEW v3 AS WITH with_t_0 as (SELECT t1_6291.c_1_0, t1_6291.c_1_1 FROM t1 AS t1_6291 WHERE false) , with_t_1 as (SELECT t1_6291.c_1_0, t1_6291.c_1_1 FROM t1 AS t1_6291 WHERE  ( t1_6291.c_1_0 ) != ( t1_6291.c_1_0 ) ) SELECT t1_6291.c_1_0 FROM t1 AS t1_6291, with_t_0 AS with_t_0, with_t_1 AS with_t_1 WHERE ((false) IS NULL);
CREATE VIEW v4 AS (WITH with_t_0 as (SELECT t1_6291.c_1_0, t1_6291.c_1_1 FROM t1 AS t1_6291 WHERE false) , with_t_1 as (SELECT t1_6291.c_1_0, t1_6291.c_1_1 FROM t1 AS t1_6291 WHERE  ( t1_6291.c_1_0 ) != ( t1_6291.c_1_0 ) ) (SELECT t1_6291.c_1_0 FROM t1 AS t1_6291, with_t_0 AS with_t_0, with_t_1 AS with_t_1 WHERE false) UNION ALL (SELECT t1_6291.c_1_0 FROM t1 AS t1_6291, with_t_0 AS with_t_0, with_t_1 AS with_t_1 WHERE (NOT (false))) UNION ALL (SELECT t1_6291.c_1_0 FROM t1 AS t1_6291, with_t_0 AS with_t_0, with_t_1 AS with_t_1 WHERE ((false) IS NULL)) );
CREATE VIEW v5 AS SELECT v4_6322.c_1_0 FROM v4 AS v4_6322, t0 AS t0_6315;
CREATE VIEW v6 AS SELECT v4_6322.c_1_0 FROM v4 AS v4_6322, t0 AS t0_6315 WHERE true;
CREATE VIEW v7 AS SELECT v4_6322.c_1_0 FROM v4 AS v4_6322, t0 AS t0_6315 WHERE (NOT (true));
CREATE VIEW v8 AS SELECT v4_6322.c_1_0 FROM v4 AS v4_6322, t0 AS t0_6315 WHERE ((true) IS NULL);
CREATE VIEW v9 AS ((SELECT v4_6322.c_1_0 FROM v4 AS v4_6322, t0 AS t0_6315 WHERE true) UNION ALL (SELECT v4_6322.c_1_0 FROM v4 AS v4_6322, t0 AS t0_6315 WHERE (NOT (true))) UNION ALL (SELECT v4_6322.c_1_0 FROM v4 AS v4_6322, t0 AS t0_6315 WHERE ((true) IS NULL)) );
CREATE VIEW v10 AS SELECT v9_6377.c_1_0 FROM v9 AS v9_6377;
CREATE VIEW v95 AS SELECT v9_6377.c_1_0 FROM v9 AS v9_6377 WHERE (('1969-12-15 16:46:46') IS NOT NULL);
CREATE VIEW v11 AS SELECT v9_6377.c_1_0 FROM v9 AS v9_6377 WHERE (NOT ((('1969-12-15 16:46:46') IS NOT NULL)));
CREATE VIEW v12 AS SELECT v9_6377.c_1_0 FROM v9 AS v9_6377 WHERE (((('1969-12-15 16:46:46') IS NOT NULL)) IS NULL);
CREATE VIEW v99 AS ((SELECT v9_6377.c_1_0 FROM v9 AS v9_6377 WHERE (('1969-12-15 16:46:46') IS NOT NULL)) UNION ALL (SELECT v9_6377.c_1_0 FROM v9 AS v9_6377 WHERE (NOT ((('1969-12-15 16:46:46') IS NOT NULL)))) UNION ALL (SELECT v9_6377.c_1_0 FROM v9 AS v9_6377 WHERE (((('1969-12-15 16:46:46') IS NOT NULL)) IS NULL)) );
CREATE VIEW v13 AS SELECT subv12.c_1_0 FROM t2 AS t2_6442, v0 AS v0_6443,  (SELECT v12_6447.c_1_0 FROM v12 AS v12_6447) subv12 RIGHT JOIN v10 AS v10_6445 ON subv12.c_1_0 = v10_6445.c_1_0 AND subv12.c_1_0 = v10_6445.c_1_0 AND subv12.c_1_0 <= v10_6445.c_1_0 AND subv12.c_1_0 >= v10_6445.c_1_0 AND subv12.c_1_0 != v10_6445.c_1_0 AND subv12.c_1_0 <= CASE  WHEN false THEN v10_6445.c_1_0  WHEN false THEN v10_6445.c_1_0  WHEN false THEN v10_6445.c_1_0 END;
CREATE VIEW v14 AS SELECT subv12.c_1_0 FROM t2 AS t2_6442, v0 AS v0_6443,  (SELECT v12_6447.c_1_0 FROM v12 AS v12_6447) subv12 RIGHT JOIN v10 AS v10_6445 ON subv12.c_1_0 = v10_6445.c_1_0 AND subv12.c_1_0 = v10_6445.c_1_0 AND subv12.c_1_0 <= v10_6445.c_1_0 AND subv12.c_1_0 >= v10_6445.c_1_0 AND subv12.c_1_0 != v10_6445.c_1_0 AND subv12.c_1_0 <= CASE  WHEN false THEN v10_6445.c_1_0  WHEN false THEN v10_6445.c_1_0  WHEN false THEN v10_6445.c_1_0 END WHERE false;
CREATE VIEW v15 AS SELECT subv12.c_1_0 FROM t2 AS t2_6442, v0 AS v0_6443,  (SELECT v12_6447.c_1_0 FROM v12 AS v12_6447) subv12 RIGHT JOIN v10 AS v10_6445 ON subv12.c_1_0 = v10_6445.c_1_0 AND subv12.c_1_0 = v10_6445.c_1_0 AND subv12.c_1_0 <= v10_6445.c_1_0 AND subv12.c_1_0 >= v10_6445.c_1_0 AND subv12.c_1_0 != v10_6445.c_1_0 AND subv12.c_1_0 <= CASE  WHEN false THEN v10_6445.c_1_0  WHEN false THEN v10_6445.c_1_0  WHEN false THEN v10_6445.c_1_0 END WHERE (NOT (false));
CREATE VIEW v16 AS SELECT subv12.c_1_0 FROM t2 AS t2_6442, v0 AS v0_6443,  (SELECT v12_6447.c_1_0 FROM v12 AS v12_6447) subv12 RIGHT JOIN v10 AS v10_6445 ON subv12.c_1_0 = v10_6445.c_1_0 AND subv12.c_1_0 = v10_6445.c_1_0 AND subv12.c_1_0 <= v10_6445.c_1_0 AND subv12.c_1_0 >= v10_6445.c_1_0 AND subv12.c_1_0 != v10_6445.c_1_0 AND subv12.c_1_0 <= CASE  WHEN false THEN v10_6445.c_1_0  WHEN false THEN v10_6445.c_1_0  WHEN false THEN v10_6445.c_1_0 END WHERE ((false) IS NULL);
CREATE VIEW v75 AS ((SELECT subv12.c_1_0 FROM t2 AS t2_6442, v0 AS v0_6443,  (SELECT v12_6447.c_1_0 FROM v12 AS v12_6447) subv12 RIGHT JOIN v10 AS v10_6445 ON subv12.c_1_0 = v10_6445.c_1_0 AND subv12.c_1_0 = v10_6445.c_1_0 AND subv12.c_1_0 <= v10_6445.c_1_0 AND subv12.c_1_0 >= v10_6445.c_1_0 AND subv12.c_1_0 != v10_6445.c_1_0 AND subv12.c_1_0 <= CASE  WHEN false THEN v10_6445.c_1_0  WHEN false THEN v10_6445.c_1_0  WHEN false THEN v10_6445.c_1_0 END WHERE false) UNION ALL (SELECT subv12.c_1_0 FROM t2 AS t2_6442, v0 AS v0_6443,  (SELECT v12_6447.c_1_0 FROM v12 AS v12_6447) subv12 RIGHT JOIN v10 AS v10_6445 ON subv12.c_1_0 = v10_6445.c_1_0 AND subv12.c_1_0 = v10_6445.c_1_0 AND subv12.c_1_0 <= v10_6445.c_1_0 AND subv12.c_1_0 >= v10_6445.c_1_0 AND subv12.c_1_0 != v10_6445.c_1_0 AND subv12.c_1_0 <= CASE  WHEN false THEN v10_6445.c_1_0  WHEN false THEN v10_6445.c_1_0  WHEN false THEN v10_6445.c_1_0 END WHERE (NOT (false))) UNION ALL (SELECT subv12.c_1_0 FROM t2 AS t2_6442, v0 AS v0_6443,  (SELECT v12_6447.c_1_0 FROM v12 AS v12_6447) subv12 RIGHT JOIN v10 AS v10_6445 ON subv12.c_1_0 = v10_6445.c_1_0 AND subv12.c_1_0 = v10_6445.c_1_0 AND subv12.c_1_0 <= v10_6445.c_1_0 AND subv12.c_1_0 >= v10_6445.c_1_0 AND subv12.c_1_0 != v10_6445.c_1_0 AND subv12.c_1_0 <= CASE  WHEN false THEN v10_6445.c_1_0  WHEN false THEN v10_6445.c_1_0  WHEN false THEN v10_6445.c_1_0 END WHERE ((false) IS NULL)) );
CREATE VIEW v17 AS SELECT CAST(v7_6557.c_1_0 AS DATE )  FROM  v99 AS v99_6562 RIGHT SEMI JOIN v10 AS v10_6545 ON v99_6562.c_1_0 = v10_6545.c_1_0 AND v99_6562.c_1_0 <= v10_6545.c_1_0 AND v99_6562.c_1_0 <= v10_6545.c_1_0 AND v99_6562.c_1_0 >= v10_6545.c_1_0 AND v99_6562.c_1_0 != v10_6545.c_1_0 AND v99_6562.c_1_0 != v10_6545.c_1_0,  v7 AS v7_6557 INNER JOIN (SELECT v16_6551.c_1_0 FROM v16 AS v16_6551) subv16 ON v7_6557.c_1_0 = subv16.c_1_0 AND v7_6557.c_1_0 < subv16.c_1_0,  v9 AS v9_6560 RIGHT SEMI JOIN (SELECT v8_6559.c_1_0 FROM v8 AS v8_6559) subv8 ON v9_6560.c_1_0 = subv8.c_1_0 AND v9_6560.c_1_0 <= subv8.c_1_0 AND v9_6560.c_1_0 < subv8.c_1_0 AND v9_6560.c_1_0 < subv8.c_1_0,  (SELECT v14_6549.c_1_0 FROM v14 AS v14_6549 WHERE NULL) subv14 INNER JOIN (SELECT t1_6541.c_1_0, t1_6541.c_1_1 FROM t1 AS t1_6541) subt1 ON subv14.c_1_0 = subt1.c_1_1 AND subv14.c_1_0 >= subt1.c_1_1 AND subv14.c_1_0 > subt1.c_1_1 AND MONTHS_ADD('1969-12-10 09:18:35', 272767082)  >= CAST(subt1.c_1_1 AS BOOLEAN ) ;
CREATE VIEW v18 AS SELECT CAST(v7_6557.c_1_0 AS DATE )  FROM  v99 AS v99_6562 RIGHT SEMI JOIN v10 AS v10_6545 ON v99_6562.c_1_0 = v10_6545.c_1_0 AND v99_6562.c_1_0 <= v10_6545.c_1_0 AND v99_6562.c_1_0 <= v10_6545.c_1_0 AND v99_6562.c_1_0 >= v10_6545.c_1_0 AND v99_6562.c_1_0 != v10_6545.c_1_0 AND v99_6562.c_1_0 != v10_6545.c_1_0,  v7 AS v7_6557 INNER JOIN (SELECT v16_6551.c_1_0 FROM v16 AS v16_6551) subv16 ON v7_6557.c_1_0 = subv16.c_1_0 AND v7_6557.c_1_0 < subv16.c_1_0,  v9 AS v9_6560 RIGHT SEMI JOIN (SELECT v8_6559.c_1_0 FROM v8 AS v8_6559) subv8 ON v9_6560.c_1_0 = subv8.c_1_0 AND v9_6560.c_1_0 <= subv8.c_1_0 AND v9_6560.c_1_0 < subv8.c_1_0 AND v9_6560.c_1_0 < subv8.c_1_0,  (SELECT v14_6549.c_1_0 FROM v14 AS v14_6549 WHERE NULL) subv14 INNER JOIN (SELECT t1_6541.c_1_0, t1_6541.c_1_1 FROM t1 AS t1_6541) subt1 ON subv14.c_1_0 = subt1.c_1_1 AND subv14.c_1_0 >= subt1.c_1_1 AND subv14.c_1_0 > subt1.c_1_1 AND MONTHS_ADD('1969-12-10 09:18:35', 272767082)  >= CAST(subt1.c_1_1 AS BOOLEAN )  WHERE false ORDER BY v10_6545.c_1_0, subv14.c_1_0 DESC, subv8.c_1_0;
CREATE VIEW v19 AS SELECT CAST(v7_6557.c_1_0 AS DATE )  FROM  v99 AS v99_6562 RIGHT SEMI JOIN v10 AS v10_6545 ON v99_6562.c_1_0 = v10_6545.c_1_0 AND v99_6562.c_1_0 <= v10_6545.c_1_0 AND v99_6562.c_1_0 <= v10_6545.c_1_0 AND v99_6562.c_1_0 >= v10_6545.c_1_0 AND v99_6562.c_1_0 != v10_6545.c_1_0 AND v99_6562.c_1_0 != v10_6545.c_1_0,  v7 AS v7_6557 INNER JOIN (SELECT v16_6551.c_1_0 FROM v16 AS v16_6551) subv16 ON v7_6557.c_1_0 = subv16.c_1_0 AND v7_6557.c_1_0 < subv16.c_1_0,  v9 AS v9_6560 RIGHT SEMI JOIN (SELECT v8_6559.c_1_0 FROM v8 AS v8_6559) subv8 ON v9_6560.c_1_0 = subv8.c_1_0 AND v9_6560.c_1_0 <= subv8.c_1_0 AND v9_6560.c_1_0 < subv8.c_1_0 AND v9_6560.c_1_0 < subv8.c_1_0,  (SELECT v14_6549.c_1_0 FROM v14 AS v14_6549 WHERE NULL) subv14 INNER JOIN (SELECT t1_6541.c_1_0, t1_6541.c_1_1 FROM t1 AS t1_6541) subt1 ON subv14.c_1_0 = subt1.c_1_1 AND subv14.c_1_0 >= subt1.c_1_1 AND subv14.c_1_0 > subt1.c_1_1 AND MONTHS_ADD('1969-12-10 09:18:35', 272767082)  >= CAST(subt1.c_1_1 AS BOOLEAN )  WHERE (NOT (false)) ORDER BY v10_6545.c_1_0, subv14.c_1_0 DESC, subv8.c_1_0;
CREATE VIEW v74 AS SELECT CAST(v7_6557.c_1_0 AS DATE )  FROM  v99 AS v99_6562 RIGHT SEMI JOIN v10 AS v10_6545 ON v99_6562.c_1_0 = v10_6545.c_1_0 AND v99_6562.c_1_0 <= v10_6545.c_1_0 AND v99_6562.c_1_0 <= v10_6545.c_1_0 AND v99_6562.c_1_0 >= v10_6545.c_1_0 AND v99_6562.c_1_0 != v10_6545.c_1_0 AND v99_6562.c_1_0 != v10_6545.c_1_0,  v7 AS v7_6557 INNER JOIN (SELECT v16_6551.c_1_0 FROM v16 AS v16_6551) subv16 ON v7_6557.c_1_0 = subv16.c_1_0 AND v7_6557.c_1_0 < subv16.c_1_0,  v9 AS v9_6560 RIGHT SEMI JOIN (SELECT v8_6559.c_1_0 FROM v8 AS v8_6559) subv8 ON v9_6560.c_1_0 = subv8.c_1_0 AND v9_6560.c_1_0 <= subv8.c_1_0 AND v9_6560.c_1_0 < subv8.c_1_0 AND v9_6560.c_1_0 < subv8.c_1_0,  (SELECT v14_6549.c_1_0 FROM v14 AS v14_6549 WHERE NULL) subv14 INNER JOIN (SELECT t1_6541.c_1_0, t1_6541.c_1_1 FROM t1 AS t1_6541) subt1 ON subv14.c_1_0 = subt1.c_1_1 AND subv14.c_1_0 >= subt1.c_1_1 AND subv14.c_1_0 > subt1.c_1_1 AND MONTHS_ADD('1969-12-10 09:18:35', 272767082)  >= CAST(subt1.c_1_1 AS BOOLEAN )  WHERE ((false) IS NULL) ORDER BY v10_6545.c_1_0, subv14.c_1_0 DESC, subv8.c_1_0;
CREATE VIEW v20 AS ((SELECT CAST(v7_6557.c_1_0 AS DATE )  FROM  v99 AS v99_6562 RIGHT SEMI JOIN v10 AS v10_6545 ON v99_6562.c_1_0 = v10_6545.c_1_0 AND v99_6562.c_1_0 <= v10_6545.c_1_0 AND v99_6562.c_1_0 <= v10_6545.c_1_0 AND v99_6562.c_1_0 >= v10_6545.c_1_0 AND v99_6562.c_1_0 != v10_6545.c_1_0 AND v99_6562.c_1_0 != v10_6545.c_1_0,  v7 AS v7_6557 INNER JOIN (SELECT v16_6551.c_1_0 FROM v16 AS v16_6551) subv16 ON v7_6557.c_1_0 = subv16.c_1_0 AND v7_6557.c_1_0 < subv16.c_1_0,  v9 AS v9_6560 RIGHT SEMI JOIN (SELECT v8_6559.c_1_0 FROM v8 AS v8_6559) subv8 ON v9_6560.c_1_0 = subv8.c_1_0 AND v9_6560.c_1_0 <= subv8.c_1_0 AND v9_6560.c_1_0 < subv8.c_1_0 AND v9_6560.c_1_0 < subv8.c_1_0,  (SELECT v14_6549.c_1_0 FROM v14 AS v14_6549 WHERE NULL) subv14 INNER JOIN (SELECT t1_6541.c_1_0, t1_6541.c_1_1 FROM t1 AS t1_6541) subt1 ON subv14.c_1_0 = subt1.c_1_1 AND subv14.c_1_0 >= subt1.c_1_1 AND subv14.c_1_0 > subt1.c_1_1 AND MONTHS_ADD('1969-12-10 09:18:35', 272767082)  >= CAST(subt1.c_1_1 AS BOOLEAN )  WHERE false ORDER BY v10_6545.c_1_0, subv14.c_1_0 DESC, subv8.c_1_0) UNION ALL (SELECT CAST(v7_6557.c_1_0 AS DATE )  FROM  v99 AS v99_6562 RIGHT SEMI JOIN v10 AS v10_6545 ON v99_6562.c_1_0 = v10_6545.c_1_0 AND v99_6562.c_1_0 <= v10_6545.c_1_0 AND v99_6562.c_1_0 <= v10_6545.c_1_0 AND v99_6562.c_1_0 >= v10_6545.c_1_0 AND v99_6562.c_1_0 != v10_6545.c_1_0 AND v99_6562.c_1_0 != v10_6545.c_1_0,  v7 AS v7_6557 INNER JOIN (SELECT v16_6551.c_1_0 FROM v16 AS v16_6551) subv16 ON v7_6557.c_1_0 = subv16.c_1_0 AND v7_6557.c_1_0 < subv16.c_1_0,  v9 AS v9_6560 RIGHT SEMI JOIN (SELECT v8_6559.c_1_0 FROM v8 AS v8_6559) subv8 ON v9_6560.c_1_0 = subv8.c_1_0 AND v9_6560.c_1_0 <= subv8.c_1_0 AND v9_6560.c_1_0 < subv8.c_1_0 AND v9_6560.c_1_0 < subv8.c_1_0,  (SELECT v14_6549.c_1_0 FROM v14 AS v14_6549 WHERE NULL) subv14 INNER JOIN (SELECT t1_6541.c_1_0, t1_6541.c_1_1 FROM t1 AS t1_6541) subt1 ON subv14.c_1_0 = subt1.c_1_1 AND subv14.c_1_0 >= subt1.c_1_1 AND subv14.c_1_0 > subt1.c_1_1 AND MONTHS_ADD('1969-12-10 09:18:35', 272767082)  >= CAST(subt1.c_1_1 AS BOOLEAN )  WHERE (NOT (false)) ORDER BY v10_6545.c_1_0, subv14.c_1_0 DESC, subv8.c_1_0) UNION ALL (SELECT CAST(v7_6557.c_1_0 AS DATE )  FROM  v99 AS v99_6562 RIGHT SEMI JOIN v10 AS v10_6545 ON v99_6562.c_1_0 = v10_6545.c_1_0 AND v99_6562.c_1_0 <= v10_6545.c_1_0 AND v99_6562.c_1_0 <= v10_6545.c_1_0 AND v99_6562.c_1_0 >= v10_6545.c_1_0 AND v99_6562.c_1_0 != v10_6545.c_1_0 AND v99_6562.c_1_0 != v10_6545.c_1_0,  v7 AS v7_6557 INNER JOIN (SELECT v16_6551.c_1_0 FROM v16 AS v16_6551) subv16 ON v7_6557.c_1_0 = subv16.c_1_0 AND v7_6557.c_1_0 < subv16.c_1_0,  v9 AS v9_6560 RIGHT SEMI JOIN (SELECT v8_6559.c_1_0 FROM v8 AS v8_6559) subv8 ON v9_6560.c_1_0 = subv8.c_1_0 AND v9_6560.c_1_0 <= subv8.c_1_0 AND v9_6560.c_1_0 < subv8.c_1_0 AND v9_6560.c_1_0 < subv8.c_1_0,  (SELECT v14_6549.c_1_0 FROM v14 AS v14_6549 WHERE NULL) subv14 INNER JOIN (SELECT t1_6541.c_1_0, t1_6541.c_1_1 FROM t1 AS t1_6541) subt1 ON subv14.c_1_0 = subt1.c_1_1 AND subv14.c_1_0 >= subt1.c_1_1 AND subv14.c_1_0 > subt1.c_1_1 AND MONTHS_ADD('1969-12-10 09:18:35', 272767082)  >= CAST(subt1.c_1_1 AS BOOLEAN )  WHERE ((false) IS NULL) ORDER BY v10_6545.c_1_0, subv14.c_1_0 DESC, subv8.c_1_0) );
CREATE VIEW v21 AS SELECT v10_6670.c_1_0 FROM v10 AS v10_6670, v99 AS v99_6692, v0 AS v0_6668, v20 AS v20_6681, v74 AS v74_6687;
CREATE VIEW v22 AS SELECT v10_6670.c_1_0 FROM v10 AS v10_6670, v99 AS v99_6692, v0 AS v0_6668, v20 AS v20_6681, v74 AS v74_6687 WHERE false;
CREATE VIEW v66 AS SELECT v10_6670.c_1_0 FROM v10 AS v10_6670, v99 AS v99_6692, v0 AS v0_6668, v20 AS v20_6681, v74 AS v74_6687 WHERE (NOT (false));
CREATE VIEW v23 AS SELECT v10_6670.c_1_0 FROM v10 AS v10_6670, v99 AS v99_6692, v0 AS v0_6668, v20 AS v20_6681, v74 AS v74_6687 WHERE ((false) IS NULL);
SELECT * FROM v22 UNION ALL SELECT * FROM v66 UNION ALL SELECT * FROM v23;

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.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.computeJoinNode(StatisticsCalculator.java:865) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.visitPhysicalHashJoin(StatisticsCalculator.java:747) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.visitPhysicalHashJoin(StatisticsCalculator.java:137) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.operator.physical.PhysicalHashJoinOperator.accept(PhysicalHashJoinOperator.java:28) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.statistics.StatisticsCalculator.estimatorStats(StatisticsCalculator.java:153) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.task.EnforceAndCostTask.computeCurrentGroupStatistics(EnforceAndCostTask.java:359) ~[starrocks-fe.jar:?]
        at com.starrocks.sql.optimizer.task.EnforceAndCostTask.execute(EnforceAndCostTask.java:176) ~[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:347) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.handleQuery(ConnectProcessor.java:317) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.dispatch(ConnectProcessor.java:432) ~[starrocks-fe.jar:?]
        at com.starrocks.qe.ConnectProcessor.processOnce(ConnectProcessor.java:670) ~[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_252]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_252]
        at java.lang.Thread.run(Thread.java:748) [?:1.8.0_252]

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 51a59f4 |
+----------------------------+

fixed by https://github.com/StarRocks/starrocks/pull/10743

please cherry pick to 2.4

@ABingHuang can't cherry-pick this pr to resolve the bug

authors: ABingHuang Seaven wanpengfei-git

repo: StarRocks/starrocks


text:
【BUG】union query of clickhouse(use jdbc) and hive will cause NPE while we using the cast

Steps to reproduce the behavior (Required)
1、hive table
CREATE EXTERNAL CATALOG hive_catalog
PROPERTIES (
"hive.metastore.type"  =  "hive",
"hive.metastore.uris"  =  "thrift://xxx:7004",
"type"  =  "hive"
);
CREATE TABLE hive_t1 (
event_date STRING
)
PARTITIONED BY (sale_worker STRING)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS TEXTFILE
LOCATION 'xxxx';
INSERT INTO TABLE hive_t1 PARTITION(sale_worker='xixi') values ('2024-09-09'), ('2024-09-10'), ('2024-09-11'),('2024-09-12'),('2024-09-13'),('2024-09-14'),('2024-09-15'),('2024-09-16');
2、clickhouse table
CREATE EXTERNAL CATALOG ck
PROPERTIES
(
"type"="jdbc",
"user"="xxxx",
"password"="xxxxx",
"jdbc_uri"="jdbc:clickhouse://xxxx:8123",
"driver_url"="https://dayu-bylink.obs.cn-north-4.myhuaweicloud.com/TEH/new/clickhouse-jdbc-0.4.6.jar",
"driver_class"="com.clickhouse.jdbc.ClickHouseDriver"
);
create table ckdb.ckt1 ON CLUSTER default_cluster(event_date date) ENGINE =MergeTree() ORDER BY (event_date);
// insert into values to ckt1. here we operate it on the web site
3、query
select * from (
SELECT
cast(event_date as date) as event_date
FROM
(
SELECT
event_date
FROM hive_catalog.default.hive_t1 AS t1
UNION ALL
select
event_date AS event_date
FROM jdbc.ckdb.ckt1 AS t
where event_date='2024-09-09'
) as t
GROUP BY
event_date
) as a
where event_date='2024-09-09'  limit 10;

Expected behavior (Required)
query success
Real behavior (Required)
query fail
StarRocks version (Required)

You can get the StarRocks version by executing SQL select current_version()
3.3.2

the problem is about this.

select cp_id, count(1) as cnt from default_catalog.test by cp_id having count(1)>1;
will throw
ERROR 1064 (HY000): Constant 1 can't compare with Constant 1

Thanks. You had found the cause of the NPE problem. Could you help us fix the first NPE problem?
It seems the AST2StringBuilderVisitor.vistCast() is wrong. It should be same with castExpr.toSqlImpl()
@Override
    public String toSqlImpl() {
        if (targetTypeDef == null) {
            return "CAST(" + getChild(0).toSql() + " AS " + type.toString() + ")";
        } else {
            return "CAST(" + getChild(0).toSql() + " AS " + targetTypeDef + ")";
        }
    }

OK. I will fix it. The second problem looks like is same with the first problem.I had fix the first problem in my env, and the second problem is fixed also.

source: gharchive/issue

license_type: permissive

license_source: github-api


text:
sqlancer query result error

Steps to reproduce the behavior (Required)
DROP DATABASE IF EXISTS w12;
CREATE DATABASE w12;
USE w12;
admin set frontend config ("enable_decimal_v3" = "true");
CREATE TABLE t0 (c_0_0 DATE NOT NULL ,c_0_1 BOOLEAN NOT NULL ,c_0_2 DATETIME NOT NULL ,c_0_3 CHAR(21) NOT NULL ,c_0_4 DECIMAL(1, 0)  NULL ,c_0_5 VARCHAR(21) NOT NULL ,c_0_6 SMALLINT REPLACE_IF_NOT_NULL NULL ,c_0_7 BIGINT SUM NOT NULL , INDEX index1_c_0_3(`c_0_3`) USING BITMAP) AGGREGATE KEY (c_0_0,c_0_1,c_0_2,c_0_3,c_0_4,c_0_5) PARTITION BY RANGE(c_0_0) (START ("2010-01-01") END ("2021-12-31") EVERY (INTERVAL 132 day)) DISTRIBUTED BY HASH (c_0_5,c_0_0,c_0_3,c_0_4) BUCKETS 3 properties("replication_num"="3") ;
CREATE TABLE t1 (c_1_0 VARCHAR(1) NOT NULL ) UNIQUE KEY (c_1_0) DISTRIBUTED BY HASH (c_1_0) BUCKETS 3 properties("replication_num"="3") ;
CREATE TABLE t2 (c_2_0 DATE NULL ,c_2_1 ARRAY<INT> NULL ,c_2_2 ARRAY<STRING> NOT NULL ,c_2_3 DATE NULL ,c_2_4 JSON NULL ,c_2_5 VARCHAR(1) NULL ,c_2_6 TINYINT NULL ,c_2_7 ARRAY<INT> NULL ,c_2_8 DATETIME NULL ,c_2_9 ARRAY<INT> NULL ,c_2_10 ARRAY<INT> NOT NULL ,c_2_11 ARRAY<STRING> NULL ,c_2_12 BOOLEAN NOT NULL ,c_2_13 DATE NOT NULL ,c_2_14 BOOLEAN NOT NULL ,c_2_15 LARGEINT NULL ,c_2_16 DOUBLE NULL ,c_2_17 SMALLINT NULL , INDEX index1_c_2_0(`c_2_0`) USING BITMAP) DUPLICATE KEY (c_2_0) PARTITION BY RANGE(c_2_0) (START ("2010-01-01") END ("2021-12-31") EVERY (INTERVAL 141 day)) DISTRIBUTED BY HASH (c_2_0) BUCKETS 3 properties("replication_num"="3") ;
CREATE TABLE t3 (c_3_0 VARCHAR(11) NOT NULL ,c_3_1 DATE NULL ,c_3_2 DATE NULL ,c_3_3 BOOLEAN NOT NULL ,c_3_4 VARCHAR(41) REPLACE NULL ,c_3_5 TINYINT MAX NOT NULL ,c_3_6 FLOAT MAX NOT NULL ,c_3_7 SMALLINT REPLACE NOT NULL ,c_3_8 BOOLEAN REPLACE NOT NULL ,c_3_9 VARCHAR(11) REPLACE NULL ,c_3_10 INT MIN NULL ,c_3_11 PERCENTILE PERCENTILE_UNION NULL ) AGGREGATE KEY (c_3_0,c_3_1,c_3_2,c_3_3) PARTITION BY RANGE(c_3_1) (START ("2010-01-01") END ("2021-12-31") EVERY (INTERVAL 112 day)) DISTRIBUTED BY HASH (c_3_0,c_3_3,c_3_2,c_3_1) BUCKETS 3 properties("replication_num"="3") ;
INSERT INTO t1 VALUES (''), (''), ('');
INSERT INTO t0 VALUES ('2010-01-12', true, '2010-01-18 08:00:14', 'H', 8, 'F', 2, -880367617), ('2010-01-17', false, '2010-01-01 08:00:14', 'a', NULL, 'C', 12, 1605127065);
INSERT INTO t3 VALUES ('O', NULL, '2010-01-29', true, 'UZjkFW1', 7, 0.11901123505597944, 14, false, '', NULL, percentile_hash('830541178')), ('J', '2010-01-28', '2010-01-05', true, 'C76hM', 3, 0.45870023962511464, 12, true, 'o', NULL, percentile_hash('1405313990'));
INSERT INTO t3 VALUES ('FL', '2010-01-04', '2010-01-05', true, 'Z', 6, 0.45870023962511464, 4, false, 'Av8eh2', 4, percentile_hash('7349293')), ('', '2010-01-20', NULL, false, 'R9HZOsE6', 6, 0.45870023962511464, 1, false, 'L', 14, percentile_hash('984827878')), ('7', '2010-01-29', '2010-01-02', true, 'Rqx', 6, 0.5950632745515321, 4, true, 'WAlXd', 4, percentile_hash('984827878'));
INSERT INTO t0 VALUES ('2010-01-07', false, '2010-01-09 08:00:14', 'Y', 6, 'DVw', 4, 650761866), ('2010-01-06', true, '2010-01-14 08:00:14', '07', 5, 'xD', 2, -1971511574);
INSERT INTO t0 VALUES ('2010-01-14', false, '2009-12-31 08:00:14', 'GJ', 0, 'i4E', 3, 1605127065);
INSERT INTO t0 VALUES ('2010-01-26', true, '2010-01-10 08:00:14', 'SZGcc', 6, '', 12, 1405313990);
INSERT INTO t3 VALUES ('IjSCyD', '2010-01-10', '2010-01-30', true, '', 6, 0.3740758288863695, 14, true, '', 5, percentile_hash('1835224399')), ('', '2010-01-02', '2010-01-30', true, 'IC', 0, 0.4804763636506355, 13, false, '', 10, percentile_hash('-1042879418'));
DELETE FROM t1 WHERE c_1_0='';
INSERT INTO t3 VALUES ('', '2010-01-04', '2010-01-16', false, '', 4, 0.7332403435268632, 12, false, '', 5, percentile_hash('-1559218778')), ('f0o', '2010-01-08', '2010-01-11', false, 'k56pfhU', 3, 0.8635504366291691, 4, false, 'f', 30, percentile_hash('-177058655')), ('I80', '2010-01-11', NULL, false, 'F', 4, -8.80367617E8, 2, false, 'GrRdy', 28, percentile_hash('1209187627')), ('uP', '2010-01-30', '2009-12-31', false, '', 3, 0.913786591005344, 9, true, '', 6, percentile_hash('-1065582939'));
INSERT INTO t1 VALUES ('');
INSERT INTO t3 VALUES ('1GHO', '2010-01-04', '2010-01-27', true, 'r', 3, 6.50761866E8, 11, true, 'V4ghi', 25, percentile_hash('969199519'));
INSERT INTO t3 VALUES ('Gbq', '2010-01-17', '2010-01-07', false, 'T0v', 3, -8.80367617E8, 2, true, '6Z', NULL, percentile_hash('-2131071162')), ('', '2010-01-01', '2010-01-24', false, '0cMVdrD', 3, 0.09805922669251566, 7, true, '', 21, percentile_hash('1287338031'));
INSERT INTO t3 VALUES ('', '2010-01-29', '2010-01-01', false, 'XL', 1, 0.4804763636506355, 1, false, 'Eq', 23, percentile_hash('1141777937'));
INSERT INTO t3 VALUES ('E8GG9C', NULL, '2010-01-02', false, 'zj', 2, -1.065582939E9, 9, true, 'fm', 24, percentile_hash('1278729076')), ('O8', '2010-01-15', '2010-01-18', true, '6XXo', 3, 0.05417989089522712, 6, true, '40wwr', 5, percentile_hash('-362151856'));
INSERT INTO t0 VALUES ('2010-01-15', false, '2010-01-08 08:00:14', 'd', 8, 'fYimo5', 3, 1209187627);
-- SELECT t1_129.c_1_0 FROM  t1 AS t1_129 FULL JOIN t0 AS t0_128 ON t1_129.c_1_0 = t0_128.c_0_0 AND t1_129.c_1_0 <= t0_128.c_0_0 AND t1_129.c_1_0 <= t0_128.c_0_1 AND (('')||(NULL)) = (('1970-01-21') IS NULL);
-- cardinality: 8
-- SELECT t1_129.c_1_0 FROM  t1 AS t1_129 FULL JOIN t0 AS t0_128 ON t1_129.c_1_0 = t0_128.c_0_0 AND t1_129.c_1_0 <= t0_128.c_0_0 AND t1_129.c_1_0 <= t0_128.c_0_1 AND (('')||(NULL)) = (('1970-01-21') IS NULL) WHERE (t0_128.c_0_1) IN ((SELECT t1_129.c_1_0 FROM t1 AS t1_129, t3 AS t3_131, t2 AS t2_130 WHERE (t0_128.c_0_2) IN ('1969-12-21 20:46:18') ) )  UNION ALL SELECT t1_129.c_1_0 FROM  t1 AS t1_129 FULL JOIN t0 AS t0_128 ON t1_129.c_1_0 = t0_128.c_0_0 AND t1_129.c_1_0 <= t0_128.c_0_0 AND t1_129.c_1_0 <= t0_128.c_0_1 AND (('')||(NULL)) = (('1970-01-21') IS NULL) WHERE (NOT ((t0_128.c_0_1) IN ((SELECT t1_129.c_1_0 FROM t1 AS t1_129, t3 AS t3_131, t2 AS t2_130 WHERE (t0_128.c_0_2) IN ('1969-12-21 20:46:18') ) ) )) UNION ALL SELECT t1_129.c_1_0 FROM  t1 AS t1_129 FULL JOIN t0 AS t0_128 ON t1_129.c_1_0 = t0_128.c_0_0 AND t1_129.c_1_0 <= t0_128.c_0_0 AND t1_129.c_1_0 <= t0_128.c_0_1 AND (('')||(NULL)) = (('1970-01-21') IS NULL) WHERE (((t0_128.c_0_1) IN ((SELECT t1_129.c_1_0 FROM t1 AS t1_129, t3 AS t3_131, t2 AS t2_130 WHERE (t0_128.c_0_2) IN ('1969-12-21 20:46:18') ) ) ) IS NULL);
-- cardinality: 9

Expected behavior (Required)
Real behavior (Required)
StarRocks version (Required)

You can get the StarRocks version by executing SQL select current_version()

mysql> select current_version();
+----------------------+
| current_version()    |
+----------------------+
| MAIN-RELEASE c728f6e |
+----------------------+

2.4验证未修复

+----------------------------+
| current_version()          |
+----------------------------+
| BRANCH-2.4-RELEASE 5f5713d |
+----------------------------+

authors: colorfulu lvchenyang-maker


text:
String长度太短，没办法存大数据

starrock类型的字符串最大长度 65533 字节，在UTF-8下只能存两万多个字，强烈建议将它修改成像hive一样能存2g，医疗行业有很多家族史这种大文本，或者经常有列转行的操作，很容易超出，目前很多业务已经不可用，希望能够尽快添加，感谢，上个月已经提出过这个issue！

Replied in previous issue.

authors: Mile-Z mofeiatwork


text:
[Doc] Add Load trigger

What type of PR is this：

[ ] BugFix
[ ] Feature
[ ] Enhancement
[ ] Refactor
[ ] UT
[x] Doc
[ ] Tool

Which issues of this PR fixes ：

Fixes #
Problem Summary(Required) ：

Checklist:

[ ] I have added test cases for my bug fix or my new feature
[ ] This pr will affect users' behaviors
[ ] This pr needs user documentation (for new or modified features or behaviors)

[ ] I have added documentation for my new feature or new function

Bugfix cherry-pick branch check:

[ ] I have checked the version labels which the pr will be auto backported to target branch

[ ] 2.5
[ ] 2.4
[ ] 2.3
[ ] 2.2

run starrocks_admit_test

@Mergifyio backport branch-2.5

source: gharchive/pull-request

authors: EsoragotoSpirit wanpengfei-git


text:
[Doc] Update CREATE TABLE AS SELECT.md add PK model desc

Fixes #issue
What type of PR is this:

[ ] BugFix
[ ] Feature
[ ] Enhancement
[ ] Refactor
[ ] UT
[x] Doc
[ ] Tool

Checklist:

[ ] I have added test cases for my bug fix or my new feature
[ ] This pr will affect users' behaviors
[ ] This pr needs user documentation (for new or modified features or behaviors)

[ ] I have added documentation for my new feature or new function

Bugfix cherry-pick branch check:

[x] I have checked the version labels which the pr will be auto-backported to the target branch

[x] 3.1
[x] 3.0
[ ] 2.5
[ ] 2.4

[FE PR Coverage Check]
:heart_eyes: pass : 0 / 0 (0%)

[FE PR Coverage Check]
:heart_eyes: pass : 0 / 0 (0%)

[FE PR Coverage Check]
:heart_eyes: pass : 0 / 0 (0%)

[FE PR Coverage Check]
:heart_eyes: pass : 0 / 0 (0%)

@mergify backport branch-3.1 branch-3.0 branch-2.5


text:
[Refactor] Refactor DatabaseTransactionMgr class

Introduced getTableName() into TransactionStateListener interface. Also refactoring the way we handle and retrieve transaction states in the DatabaseTransactionMgr class by encapsulating logic into smaller helper functions like populateTransactionStateListeners() and ensureTableIdListIsPresent() for improved readability and maintainability. Introduced more distinct versions of TransactionNotFoundException to provide more clear error messages. These changes aim to simplify transaction handling while making the code clearer.
Fixes #issue
What type of PR is this:

[ ] BugFix
[ ] Feature
[ ] Enhancement
[x] Refactor
[ ] UT
[ ] Doc
[ ] Tool

Checklist:

[ ] I have added test cases for my bug fix or my new feature
[ ] This pr will affect users' behaviors
[ ] This pr needs user documentation (for new or modified features or behaviors)

[ ] I have added documentation for my new feature or new function

Bugfix cherry-pick branch check:

[x] I have checked the version labels which the pr will be auto-backported to the target branch

[ ] 3.1
[ ] 3.0
[ ] 2.5
[ ] 2.4

[FE PR Coverage Check]
:disappointed: fail : 43 / 61 (70.49%)
file detail

path
covered_line
new_line
coverage
not_covered_line_detail

:large_blue_circle:
com/starrocks/transaction/LakeTableTxnStateListener.java
0
1
00.00%
[62]

:large_blue_circle:
com/starrocks/transaction/TransactionNotFoundException.java
1
2
50.00%
[23]

:large_blue_circle:
com/starrocks/transaction/DatabaseTransactionMgr.java
41
57
71.93%
[377, 475, 553, 1144, 1157, 1254, 1668, 1669, 1670, 1671, 1672, 1673, 1675, 1676, 1677, 1693]

:large_blue_circle:
com/starrocks/transaction/OlapTableTxnStateListener.java
1
1
100.00%
[]

@Mergifyio backport branch-3.1

authors: sduzh wanpengfei-git


text:
[Doc] Update SHOW LOAD

Signed-off-by: amber-create yangyanping@starrocks.com
Fixes #issue
What type of PR is this:

[ ] BugFix
[ ] Feature
[ ] Enhancement
[ ] Refactor
[ ] UT
[ ] Doc
[ ] Tool

Checklist:

[ ] I have added test cases for my bug fix or my new feature
[ ] This pr will affect users' behaviors
[ ] This pr needs user documentation (for new or modified features or behaviors)

[ ] I have added documentation for my new feature or new function

Bugfix cherry-pick branch check:

[ ] I have checked the version labels which the pr will be auto-backported to the target branch

[ ] 3.1
[ ] 3.0
[ ] 2.5
[ ] 2.4

[FE PR Coverage Check]
:heart_eyes: pass : 0 / 0 (0%)

@mergify backport branch-3.1

authors: amber-create wanpengfei-git


text:
[Enhancement] Automatically create partitions to optimize the use of batch interfaces

Fixes #issue
Opt create 1000 partition from 70s -> 15s in my env.
What type of PR is this:

[ ] BugFix
[ ] Feature
[x] Enhancement
[ ] Refactor
[ ] UT
[ ] Doc
[ ] Tool

Does this PR entail a change in behavior?

[ ] Yes, this PR will result in a change in behavior.
[x] No, this PR will not result in a change in behavior.

If yes, please specify the type of change:

[ ] Interface/UI changes: syntax, type conversion, expression evaluation, display information
[ ] Parameter changes: default values, similar parameters but with different default values
[ ] Policy changes: use new policy to replace old one, functionality automatically enabled
[ ] Feature removed
[ ] Miscellaneous: upgrade & downgrade compatibility, etc.

Checklist:

[ ] I have added test cases for my bug fix or my new feature
[ ] This pr needs user documentation (for new or modified features or behaviors)

[ ] I have added documentation for my new feature or new function

Bugfix cherry-pick branch check:

[x] I have checked the version labels which the pr will be auto-backported to the target branch

[x] 3.2
[x] 3.1
[x] 3.0
[ ] 2.5

[BE Incremental Coverage Report]
:heart_eyes: pass : 0 / 0 (0%)

[FE Incremental Coverage Report]
:disappointed: fail : 38 / 76 (50.00%)
file detail

path
covered_line
new_line
coverage
not_covered_line_detail

:large_blue_circle:
com/starrocks/sql/ast/ListPartitionDesc.java
0
6
00.00%
[77, 78, 79, 81, 82, 84]

:large_blue_circle:
com/starrocks/load/InsertOverwriteJobRunner.java
0
7
00.00%
[244, 254, 255, 256, 257, 258, 259]

:large_blue_circle:
com/starrocks/sql/analyzer/AnalyzerUtils.java
11
22
50.00%
[961, 962, 973, 974, 975, 976, 977, 978, 981, 982, 983]

:large_blue_circle:
com/starrocks/service/FrontendServiceImpl.java
9
17
52.94%
[2228, 2229, 2246, 2247, 2248, 2249, 2250, 2251]

:large_blue_circle:
com/starrocks/server/LocalMetastore.java
18
24
75.00%
[885, 886, 887, 1259, 1269, 1270]

[BE Incremental Coverage Report]
:heart_eyes: pass : 0 / 0 (0%)

[FE Incremental Coverage Report]
:heart_eyes: pass : 71 / 84 (84.52%)
file detail

path
covered_line
new_line
coverage
not_covered_line_detail

:large_blue_circle:
com/starrocks/service/FrontendServiceImpl.java
11
17
64.71%
[2246, 2247, 2248, 2249, 2250, 2251]

:large_blue_circle:
com/starrocks/load/InsertOverwriteJobRunner.java
11
15
73.33%
[258, 259, 260, 269]

:large_blue_circle:
com/starrocks/server/LocalMetastore.java
21
24
87.50%
[1259, 1269, 1270]

:large_blue_circle:
com/starrocks/sql/ast/ListPartitionDesc.java
6
6
100.00%
[]

:large_blue_circle:
com/starrocks/sql/analyzer/AnalyzerUtils.java
22
22
100.00%
[]

@Mergifyio backport branch-3.2

@Mergifyio backport branch-3.1

@Mergifyio backport branch-3.0

authors: Astralidea wanpengfei-git


text:
[Enhancement] LockManager enhances lock status observability

Why I'm doing:
What I'm doing:
Fixes #issue
What type of PR is this:

[ ] BugFix
[ ] Feature
[x] Enhancement
[ ] Refactor
[ ] UT
[ ] Doc
[ ] Tool

Does this PR entail a change in behavior?

[ ] Yes, this PR will result in a change in behavior.
[x] No, this PR will not result in a change in behavior.

If yes, please specify the type of change:

[ ] Interface/UI changes: syntax, type conversion, expression evaluation, display information
[ ] Parameter changes: default values, similar parameters but with different default values
[ ] Policy changes: use new policy to replace old one, functionality automatically enabled
[ ] Feature removed
[ ] Miscellaneous: upgrade & downgrade compatibility, etc.

Checklist:

[ ] I have added test cases for my bug fix or my new feature
[ ] This pr needs user documentation (for new or modified features or behaviors)

[ ] I have added documentation for my new feature or new function

[ ] This is a backport pr

Bugfix cherry-pick branch check:

[x] I have checked the version labels which the pr will be auto-backported to the target branch

[x] 3.3
[ ] 3.2
[ ] 3.1
[ ] 3.0
[ ] 2.5

https://github.com/Mergifyio backport branch-3.3


text:
Add funnel function

What type of PR is this：

[ ] bug
[x] feature
[ ] enhancement
[ ] others

Problem Summary(Required) ：

Add funnel function, detailed description will be added later.

[FE PR Coverage check]
:heart_eyes: pass : 2 / 2 (100.00%)
file detail

path
covered line
new line
coverage

:large_blue_circle:
com/starrocks/catalog/FunctionSet.java
2
2
100.00%

[FE PR Coverage check]
:heart_eyes: pass : 2 / 2 (100.00%)
file detail

path
covered line
new line
coverage

:large_blue_circle:
com/starrocks/catalog/FunctionSet.java
2
2
100.00%

We will improve window_funnel to provide funnel's functionality, So let this PR close.

authors: Pslydhh wanpengfei-git


text:
[BugFix] Fix hang because of empty scan ranges

What type of PR is this：

[x] bug
[ ] feature
[ ] enhancement
[ ] refactor
[ ] others

Which issues of this PR fixes ：

Fixes #https://github.com/StarRocks/StarRocksTest/issues/870
Problem Summary(Required) ：

We don't handle empty scan range properly.

run starrocks_admit_test

@MergifyIO backport branch-2.3

@MergifyIO backport branch-2.4

authors: dirtysalt wanpengfei-git


text:
add better error handling

fixes STCL-2.
fixes this.

hoping this works

repo: StatisticalLabs/bot

license: MIT


text:
font_create_family  crash on linux & font_create add an /assets/  to the path when loading an assets font.

Description
1 - Calling font_create_family ("courier" or "arial") on linux  gives the following crash :

2 - Calling font_create to open an assets font ('fonts/Courier Prime Italic.ttf'), double the directory "assets" in the path : platform_read_file_direct can't find assets/assets/fonts/Courier Prime Italic.ttf
3 - The doc of FromFamily method is not the right one.
Platform / Environment
rust binding. Linux 24.04 gnome wayland
Logs or exception details

Hi ! With today's update :
1 - The crash is still there.
2 - The error message is now Font file failed to load: fonts/Courier Prime Italic.ttf assets/fonts/Courier Prime Italic.ttf
3 - The doc is now ok.

Hi ! With today's update :
1 - The crash is still there.
2 - The problem is solved
3 - The doc is now ok.

repo: StereoKit/StereoKit


text:
🛑 DNS (he.net) is down

In 88d6932, DNS (he.net) ($HE_NS) was down:

HTTP code: 0
Response time: 0 ms

Resolved: DNS (he.net) is back up in 53f69d2.

repo: Sternwarte-St-Ottilien-e-V/status


text:
🛑 DNS (he.net) is down

In 0c1830b, DNS (he.net) ($HE_NS) was down:

HTTP code: 0
Response time: 0 ms

Resolved: DNS (he.net) is back up in af358b4.


text:
Fetching rows that contain specific column data?

Hi, is it possible to query rows that contain specific column data? for example, if i have a "date" column and it can either contain "n/a" or "12/06/2022" can i fetch only those that contain "n/a" directly without having to filter using linq afterwards? Thanks.

@dahanj95 that’s a great question. Unfortunately I have not found a way with the Google Sheets API to filter the data by a specific condition. The only way I have achieved this is looping over the data afterwards like using LINQ.
Here’s a stackoverflow post that someone asks a similar question as well,
https://stackoverflow.com/questions/62789700/google-sheets-api-read-values-by-filter

repo: SteveWinward/GoogleSheetsWrapper


text:
Add support for Little Snitch Rule Group Subscriptions format

See Little Snitch Rule Group Subscriptions format.
See also Little Snitch at obdev.at (MacOS only)

Hey this is cool.  It's been done!  https://github.com/naveednajam/Little-Snitch---Rule-Groups

May I ask if 10 000 entries is the limit ?
CF:

https://github.com/naveednajam/Little-Snitch---Rule-Groups/blob/master/stevenblack_unified_hosts_V1.1.py#L115

Ya Nissar @funilrys under current circumstances, the hosts file must be broken into chunks no larger than 10,000 entries.
Seems like a bogus limitation to me; I'm puzzled by this limitation in Little Snitch.

Ouch ... That's not funny ...

@funilrys it just makes integrating into Little Snitch probably not worth the hassle.

Having 7 files just for the unified hosts file may be too much ... And if we grow up it may become unmanageable ...
But yeah we can think about integrating that if it is used :smile_cat:

Hi guys, I'm totally new to this stuff, how do I use the python script and where should I save it? I ran the script and it downloaded the lsrules but I can't seem to import them.
Thanks in advance!

I think 10K is not the limit anymore no? Could be awesome to be able to subscribe to a HOSTS group! The Peter Lowe's Block List works pretty well, but I imagine the HOSTS one would block much more

@mickaphd is some kind of an issue, but i would suggest that the script is rewriten to use comm for sorting out whitelisted domains as that is super fast compared to sed and awk for bigger whitelists

@spirillen are you out of scope? The script is written in python and I don't see any sed nor awk ...

"As of Little Snitch 4.3 (5264) max domains per rule increased to 200,000"
https://github.com/naveednajam/Little-Snitch---Rule-Groups/commit/6592507dbbfa0fd0e6b88295370938f8cde9e56c

Now it's interesting to code that feature Steve @StevenBlack 😁
Can you tell me how you imagine it Steve?

That's a good question, Nissar @funilrys.
In my implementations, Little Snitch is completely out of control.  Its rules management system isn't up to the task.
For example, many times, I want to review rules added in the past few minutes.  Can I sort rules by date and time added?  No, no I can't. I can only see rules added in the past 24 hours, within controlling applications, in a tree.  I hate this missing sorting functionality.
So in my mind, I would like to delete ALL my Little Snitch rules, then apply the hosts file for "All Applications".
What's your thought?

@StevenBlack I agree with your criticisms of Little Snitch's UI for viewing rules, there could certainly be some improvements there, but the way that LS rules groups are managed now has been greatly improved - especially now that the limit is 200,000 rules. In addition to that there is now support for rules files that simply block a group of host names as any of your hosts files would be used for via the denied-remote-domains key (1). Using rules groups formatted like this leads to much reduced UI lag, in my experience, when compared to using 5-6 files each containing 10,000 rules. Until better support for blocklists was implemented in LS 4.2 I had actually stopped using the rule groups generated by https://github.com/naveednajam/Little-Snitch---Rule-Groups because the UI was basically unusable.

So in my mind, I would like to delete ALL my Little Snitch rules, then apply the hosts file for "All Applications".

To this point, rules that are contained within imported rule groups are automatically given a higher priority than rules a user has added, apply to all users and also all processes if the rule group uses the denied-remote-domains format. If a user already has rules blocking some of the hostnames contained in an imported rule group then LS will flag those as duplicates and allow a user to delete them specifically under Suggestions > Redundant Rules.
Also, if the user has the "Mark new rules as unapproved" preference enabled under Preferences > Advanced, whenever there's an update to an imported rule group LS displays the changes under Unapproved Rules.
I forked @naveednajam's repo and updated the code to use the blocklist format since it's much simpler: https://github.com/scrossan/Little-Snitch---Rule-Groups
(1): https://help.obdev.at/littlesnitch/ref-lsrules-file-format

Thank you for this insight, Steven @scrossan.  I think we'll move in this direction very soon.
I have another thought: domains are, or course, only useful for HTTP requests that route via domains.
I wonder if we should find the ip addresses behind all our listed domains, and add those to the Little Snitch rules, so actors that use direct IP addresses are prevented.

@StevenBlack Fyi, coincidentally i was looking into this as well.
Perhaps this is useful, it should return all Facebook IPs, by ASN:
whois -h whois.radb.net '!gAS32934'  #  | tr ' ' '\n' | awk '!/[[:alpha:]]/'

I was trying to figure out a way to optimise this list, like for example "ipset" optimises it to:
Addresses before CIDR optimization: 106
Addresses after CIDR optimization:  15
...
74.119.76.0/22
31.13.64.0/18
185.60.216.0/22
173.252.64.0/18
66.220.144.0/20
157.240.0.0/16
69.63.176.0/20
204.15.20.0/22
69.171.224.0/19
179.60.192.0/22
129.134.0.0/16
45.64.40.0/22
103.4.96.0/22
31.13.24.0/21
199.201.64.0/22

which would then have to be converted into Little Snitch rules format.

well i guess optimising might not be absolutely necessary... :)

@notDavid you know, I hadn't even thought about IP ranges.
Because, let's be honest, it's the IP address we ultimately care about.
So here's another angle: sites that share IP addresses.  A server can serve many, maybe very many, domains.  Some will be unrelated to the malware, and be hurt by IP address blocking.

Some will be unrelated to the malware, and be hurt by IP address blocking

Not exactly sure what you mean, but ultimately a firewall always blocks ip-addresses. Even if you specify a hostname.
So if something.facebook.com resolves to 1.2.3.4 and someotherwebsite.com also resolves to 1.2.3.4, blocking something.facebook.com will also block someotherwebsite.com.
It makes no difference whether you specify the hostname or the IP in your blocklist, the result is the same.

...ultimately a firewall always blocks ip-addresses. Even if you specify a hostname.

@notDavid how would we know this is true for Little Snitch?
For example, in Little Snitch, if for app Spotify we Deny outgoing connections to domain googletagmanager.com,  I'm not seeing 172.217.11.8 anywhere in the data tied to app Spotify.
How would we know if application Spotify calls 172.217.11.8 directly, that this will be blocked by Little Snitch?
It seems wildly implausible that Little Snitch would resolve IP addresses based on domains, in real time, for everything.
It's more plausible that, given just a domain, Little Snitch intercepts calls on Port 53 (DNS) and mangles either the request or response for whatever configured apps requesting to, say, googletagmanager.com, leaving googletagmanager.com open for apps that don't have this constraint.
I'm just guessing here...

It seems wildly implausible that Little Snitch would resolve IP addresses based on domains, in real time, for everything.

Good question, I only know that i read this is how the OSX packet filter (pfctl) works: all fully qualified domain names will be resolved via DNS when the ruleset is loaded. All resulting IP addresses will be substituted into the rule.
I will have a look later if i can test in Little Snitch / check their docs.

So a quick test confirms you are right; I simply tested:
New Rule -> Any Process -> Deny -> To ->
then i configured one of these and tested them 1 by 1:

To -> Domain = httpbin.org
To -> Hostname = httpbin.org
To -> Ip Addresses = httpbin.org (this will resolve to the ips in the gui)
To -> Ip Addresses = 3.223.234.9, 52.22.188.80

So for each of these rules i tested in Terminal:

curl http://httpbin.org/ | grep -i title
curl http://52.22.188.80/ | grep -i title

Indeed only 3 and 4 will block everything. 1 and 2 will block the domain but not the ip (curl http://52.22.188.80/).
Weird! I didn't expect that...

@notDavid, Dan @dnmTX, Nissar @funilrys, @ScriptTiger, @anudeepND, Tomasz @FadeMind, and all others...
Here's an interesting engineering question.

Say we have a hosts list of length 10^6, or thereabouts.
Say we want to maintain a map of the current ip address associated with each domain, refreshing continuously, but extremely responsively to new domains, those just added to the hosts list.

How would you suggest doing this reliably and respectfully, and in an automated way.
I presume we'd want to do this in a rate-limited way, so this isn't a blind and mindless process.
Would you run the IP matching on our published hosts files, or would you pre-load the IP address matches by iterating the sources in our ./data and ./extensions folders, so amalgamated hosts files and associated IP addresses can be released simultaneously?  I'd love to release all products together.
Would you add this functionality to this repo, or create a separate project that would coordinate and execute IP address verification and make automated PRs to this repo?  In other words, do we bolt-on all that's required for new products, or do we make creating non-hosts products a separate and independent responsibility?
It's a lot to think about.

I think the most effective way to get  associated ip address in a continuous  and efficient manner is to use the ttl value of the domain. This will require to set up a database which allow to query domain /subdomain based on ttl value and then refresh ip address associated with those domain and move the domain to appropriate list if the new ttl value is different then existing value.
If database approach is used then, adding record into the database can be implemented in such way that it resolve the ip address and ttl at the time of inserting new entry.
dig can be used to get the ttl value and associated ip address. to avoid abusing any public dns it will be more efficient to setup a local dns which will also help to cache the result and provide faster response during each update cycle.
dig -q google.com -t A +noall +answer +ttl
; <<>> DiG 9.10.6 <<>> -q google.com -t A +noall +answer +ttl'
;; global options: +cmd
google.com.		300	IN	A	172.217.166.142
dig -q microsoft.com -t A +noall +answer +ttl
; <<>> DiG 9.10.6 <<>> -q microsoft.com -t A +noall +answer +ttl
;; global options: +cmd
microsoft.com.		3600	IN	A	40.113.200.201

Excellent point about ttl, @naveednajam.
And yes, a database, definitely.  Maybe a distributed one, maybe a publicly accessible for read ops, so forks could share the data.  Just thinking out loud, here.

@notDavid

Indeed only 3 and 4 will block everything. 1 and 2 will block the domain but not the ip (curl http://52.22.188.80/).
Weird! I didn't expect that...

This is good thing. As we don't want to block ip address where multiple domains are hosted, using option 1 and will allow to block domains and subdomain without restricting other domain hosted by same ip address.

maybe publicly accessible for read ops, so forks could share the data. Just thinking out loud, here.
yes, more precisely via RESTful API.

@scrossan

I forked @naveednajam's repo and updated the code to use the blocklist format since it's much simpler: https://github.com/scrossan/Little-Snitch---Rule-Groups

would not it be better to usedenied-remote-hosts instead of domain. most of the time ads content is served by a specific host within a domain. Unless we wanted to block the whole domain. it would be nicer to have three entries one with domain where top level domain is blocked and 2nd for hosts and 3rd where we have ip addresses in the list we need to block it using denied-remote-addresses

As far as creating the LS Rule groups, I wrote up a service that compiles all of @StevenBlack sources and converts them into a set of LS Rules files, updated weekly, that can be used inside of LittleSnitch along with auto updating. Site was slapped together to get the rules out (and is in desperate need of a proper design) as I plan on using them in an iOS app for Content Blocking (given away for free).
If interested, I can share the hostname to let people subscribe directly.

I would love that, Richard @rjhancock.
Presently I have Little Snitch disabled because managing its rules is such a mess.
If this were data-driven and automated, wow, that's a game changer.

https://hostblocker.app is where the list is shown. Below is what it looks like in my LittleSnitch.
Every week the backend API downloads the hosts files, parses them, updates, and pushes out new static files to reduce load.

@rjhancock man, that's beauty, right there.  This is how Little Snitch should have always been.
I'm going to dive into this as soon as I can come up for air.

Best part, they survive macOS Catalina updates (which replaces the Hosts files for even patch releases).

Sounds awsome man, gonna try that very soon. What's your app on iOS? I'm using right now Lockdown which is great too but do not block (yet!) all of these

It's called HostBlocker. Uses these same lists to block them in Safari and the corresponding web component. Not released yet (lack of time among other things). Should have a beta out by year end.
The issue with Content Blocking on iOS is you either generate a list with a cap of 50k entries or you create a local DNS server to handle all the resolution and potentially expose it to the company.
There are APIs to do it at a system level but they are limited to managed devices only (which may be an extra feature for that that wish to "manage" their own devices.

An update on LittleSnitch, it's updated every week like clockwork adding/removing domains as the lists change.
And thanks for pointing me towards Lockdown @mickaphd. I copied the repo onto my GitLab instance and started going through their code and trimming the fat (removing the iAP, Excessive logging, VPN, etc). Thus far it's looking like I'll have a working version of mine by end of week using the lists here and opening it up to also have a better ad blocker using CSS rules for Safari when the hosts fail.
Thanks for the great work @StevenBlack as none of what I'm doing would be feasibly possible without it.

I've made a similar solution (unaware of @rjhancock's solution), which is a more direct translation of @StevenBlack host files to Little Snitch.
It may be of interest.

It's great to see and meet like minded people. I moved forward with original idea of translating StevenBlack host files  to little snitch rule Little-Snitch--RuleGroups to next level RuleGroupsV2 when I feel Little Snitch has a lot more potential than simple host files. No doubt @StevenBlack was main source of motivation.

@cLupus and Naveed @naveednajam this is awesome.
Reliable and dynamic Little Snitch rule groups by subscription is the ultimate solution on MacOS, I feel.  This may be the direction I take, next.  I'm going to try this.  Little Snitch is too bothersome and intrusive, otherwise.  But it's SO good at what it does....
Everyone: if you use MacOS and haven't investigated Little snitch, you should.

Hi guys,
Just seeing this a little late; any updates?
I went ahead and subscribed to several lists by HostBlocker (thanks @rjhancock), although I could not find the unified hosts list by @StevenBlack, just several extensions. Am I missing something?
And are these lists updated regularly?
Thanks!
Tommie

It's the individual lists broken up. I'm going to need to update the site a bit more and probably update the file formats as I couldn't get them to work with the latest Little Snitch format.

Thanks for the quick reply, @rjhancock. So I take it the lists have not been updated in a while? Therefore, does it make more sense to use @naveednajam's script to convert @StevenBlack's lists manually? Not as handy as a subscription, however.

Give me a few days as I'll work on it today and give it a lot of under the hood updates (the backend is a few versions out of date). I'll post back when it's done.

@TommieWong I would love, love, LOVE to have a reliable connection between our hosts and Little Snitch.
This would be a perfect security scenario for MacOS. I would be the most avid user, and proponent, of this.
It's precisely because Little Snitch lacks (or lacked) a strong third-party support that I don't use it anymore. Without a solid add-on story, Little Snitch becomes a constant source of interruption as it asks the user if connecting to domain xyz.abc is OK, and even I don't know the answer, in the moment.
At least, that's my recollection of the state of Little Snitch about three years ago, when I decided to uninstall it from all my Macs.
Richard @rjhancock what's the latest on Little Snitch? I'd be grateful for your insight.

I use it on my M1 as I have a PiHole at home now using these lists. It still runs fine and with these subscriptions in place, rarely get a notification on anything.
I get my Hostblocker site updated and I think the pairing is perfect.

@rjhancock same setup here Richard. It's a near-perfect computing environment, the best I've ever had (except for Windows VM support on M1 — that part sucks.)
If I had Little Snitch protecting all the non-hosts areas without too many interruptions, man, I'd be over-the-moon!

Thanks a lot for the answers, @StevenBlack and @rjhancock. Indeed, a reliable link between the hosts blocklist and LS would be awesome. I currently just have Peter Lowe's and it's already helpful. As for the constant interruptions, I gave up on browser allow/deny rules, so it's allow all + uBlock origin. So LS is mostly to completely cut off some apps from the internet.

I'd like to report that the service has been updated, lists updated, and confirmed working in latest version of Little Snitch on my M1. Feel free to pull updates weekly.
I suggest setting to auto approve (if you trust me that is) and to auto update weekly.
It's not the unified list but each source individually so you can customize as you see fit. I'm showing just under 91k total rules.

I see I'm missing a few and have a few outdated links. Updating now and new lists should be generated within the hour.

Showing roughly 110k now.
I use this setup when I'm not at home and I get near 0 interruptions for it (get one about every month or so).
If @StevenBlack can keep me updated on changes to what lists they pull from, I can keep this site up and running with those updates.

Thanks a lot for the quick work, @rjhancock! However, I can no longer see the links on hostblocker.app, so I can only update the lists that I had already subscribed to. Tried from a different browser and same result.
Also, out of curiosity, what are the interruptions you get (or that @StevenBlack was talking about)? On my end, LS mostly completely blocks application from the internet, or is set to allow just connections to update servers. Same for system services. Then, there remains the case of the browser which is set to allow all (and then the filter takes place in the browser itself); is this where our setups differ? Can I ask what your LS settings are?

The interruptions are when LS asks permission for a location for an app. On a clean slate it gets quite annoying all the different sites various pieces of software tries to connect to that it becomes a state of just allow all and go back later to block.
The issue on the site is a CORS issue that isn't appearing in Safari (errors show but the site still loads). Will adjust accordingly.

Fixed. I just have the default settings setup for mine.

Wonderful, thank you! As for LS permissions, it's true that they can be overwhelming at first; I've had it for a number of years, so most apps/services are taking care of by now.

Yup. But when doing a new install (happens from time to time), they can be overwhelming so having a good "default" such as these lists helps reduce that dramatically.

Ok, but that brings me back to my question: which app would potentially call to these sites? Just a browser, no? (99.99% of the time)

Any application on your machine. Could be a system service, daemon that is running, malware, etc. The point of Little Snitch is to act as an outbound firewall to catch programs doing things they aren't suppose to be doing.

Sure, I know. I've just never noticed an app actually calling to something suspicious. So, to me, the browser is the most likely caller. I guess that depends on the apps you use. If in doubt, I just block all connections, period.

PS: really would be useful to have a note on hostblocker.app about when the lists were most recently updated. Over and out.

As in last time we compared them to Steven's lists or the last time we pulled them to update them (which the site should say they are updated weekly)

Added a note back to where the lists came from as well as how often they are processed.

authors: StevenBlack TommieWong cLupus claysimps funilrys mickaphd naveednajam notDavid rjhancock scrossan spirillen

repo: StevenBlack/hosts

license: mit

license_source: bigquery


text:
Add adviad.com domain

Adware domain, loads javascript file, then loads its player along with its logger script. BTW its JS files are encrypted, nearly impossible to read and understand.

0.0.0.0 www.adviad.com
0.0.0.0 ads3.adviad.com
0.0.0.0 ads4.adviad.com
0.0.0.0 sync.adviad.com
0.0.0.0 api.adviad.com
0.0.0.0 cdn.adviad.com
0.0.0.0 dmp.adviad.com
0.0.0.0 app.adviad.com
0.0.0.0 dsp.adviad.com
0.0.0.0 ssp.adviad.com
0.0.0.0 ads.adviad.com
0.0.0.0 adsuz.adviad.com
0.0.0.0 nl.adviad.com
0.0.0.0 report.adviad.com
0.0.0.0 cdnuz.adviad.com
0.0.0.0 panel.adviad.com

0.0.0.0 www.adviad.com
0.0.0.0 ads3.adviad.com
0.0.0.0 ads4.adviad.com
0.0.0.0 sync.adviad.com
0.0.0.0 api.adviad.com
0.0.0.0 cdn.adviad.com
0.0.0.0 dmp.adviad.com
0.0.0.0 app.adviad.com
0.0.0.0 dsp.adviad.com
0.0.0.0 ssp.adviad.com
0.0.0.0 ads.adviad.com
0.0.0.0 adsuz.adviad.com
0.0.0.0 nl.adviad.com
0.0.0.0 report.adviad.com
0.0.0.0 cdnuz.adviad.com
0.0.0.0 panel.adviad.com

@dnmTX Hi, thank you for the addition, I'm just curious how did you find these URLs? I tried to query some of them, seemed non existing:

@dnmTX Hi, thank you for the addition, I'm just curious how did you find these URLs? I tried to query some of them, seemed non existing:

I'm just curious how did you find these URLs?

@nalekberov sorry about that(i just check them all and removed all NX's). I should've check them first.
I thing those came from VirusTotal.

I'm just curious how did you find these URLs?

@nalekberov sorry about that(i just check them all and removed all NX's). I should've check them first.
I thing those came from VirusTotal.

....but if you look closer,for example panel.adviad.com
it has proper A and AAAA records and it's not expired even. On why it showing NXDOMAIN,i have no answer 🤔

....but if you look closer,for example panel.adviad.com
it has proper A and AAAA records and it's not expired even. On why it showing NXDOMAIN,i have no answer 🤔

Hi @nalekberov thank you for this.  This looks good.
However are the domains adviad.com and www.adviad.com serving questionable content?
You see, we aren't in the business of taking down companies, just their vectors for adware and questionable content.  We block google ads, for example, but not google.com.  Same principle.
Can you modify this PR to remove domains adviad.com and www.adviad.com, or make a case why these should be included?  Thanks!

Hi @nalekberov thank you for this.  This looks good.
However are the domains adviad.com and www.adviad.com serving questionable content?
You see, we aren't in the business of taking down companies, just their vectors for adware and questionable content.  We block google ads, for example, but not google.com.  Same principle.
Can you modify this PR to remove domains adviad.com and www.adviad.com, or make a case why these should be included?  Thanks!

Hi @StevenBlack, indeed, I apparently took an 'All-or-nothing' approach here, missed that point. No need to include them.
Thanks for your suggestion! I modified the PR to remove domains adviad.com and www.adviad.com.

Hi @StevenBlack, indeed, I apparently took an 'All-or-nothing' approach here, missed that point. No need to include them.
Thanks for your suggestion! I modified the PR to remove domains adviad.com and www.adviad.com.

Thank you Nurlan @nalekberov.  Absolutely perfect.
Merging!

Thank you Nurlan @nalekberov.  Absolutely perfect.
Merging!

authors: StevenBlack dnmTX nalekberov


text:
Npm module needs to be updated

Looks like you merged the previous pull request, but never updated the NPM module.

I guess this is possibly what just wasted 2 hours... thanks for mentioning it so that I downloaded it locally... now working.

authors: Trudeaucj darrenparkinson

repo: Stevenic/botkit-middleware-luis


text:
stash issue

[24-08-2015 21:13] Error downloading stash for Tempest, exception details: System.NullReferenceException: Object reference not set to an instance of an object.
at POEApi.Model.POEModel.GetStash(String league, String accountName)
[24-08-2015 21:13] System.Exception: Downloading stash for Tempest, details logged to DebugInfo.log, please open a ticket at https://github.com/Stickymaddness/Procurement/issues
at POEApi.Model.POEModel.GetStash(String league, String accountName)
at Procurement.ViewModel.LoginWindowViewModel.LoadStashItems(Character character)
at Procurement.ViewModel.LoginWindowViewModel.d__6.MoveNext()
at System.Collections.Generic.List1..ctor(IEnumerable1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Procurement.ViewModel.LoginWindowViewModel.<>c__DisplayClass2.b__1()
at System.Threading.Tasks.Task.Execute()

fixed itself when i logged into a character in each league.

repo: Stickymaddness/Procurement


text:
Removed redundant variables, and prepared for test.

Please review the PR and tell me if I need to amend something.

Hey man, thanks for the contribution.
I don't think I'll be merging this PR because I'd have preferred to have kept using the service classes through dependency injection as opposed to accessing static methods through the class the way you've done it.
If the factories had have been separate factory classes which can be called individually, I'd have merged those in.
Again, thanks for the contribution! If you switch back to dependency injection and separate the factories I'd be more than happy to merge as there are a few others things you've done which I actually like.

Thanks, I might be doing that soon, I am planning to segregate the factories, may today or so, when I get up and running with tests, I guess it has gone extremely complex with building activities. I am planning to contribute more soon! Cheers! Hope you like it! Please, keep providing feedback.

Hey, can you please tell me what the activity service is doing, I am having hard time to refactor it and write tests for it. Especially, these lines:

Hey, can you please tell me what the activity service is doing, I am having hard time to refactor it and write tests for it. Especially, these lines:

https://github.com/Stokoe0990/wikivel/blob/master/app/Http/Controllers/Web/HomeController.php#L56
You can see in here that a single activity record is passed to the buildActivityData method.
If you didn't remove the comments, you might have had a better idea of what it's doing.
But essentially:
$changedRecord = $recentActivity->subject_type::where('id', $recentActivity->subject_id)->first();
Finds record matching the class and ID.
if ($changedRecord) {
            $changeType = $recentActivity->description;

           // If `$changedRecord` is set here, that means the record still exists (Which means the type of action was NOT `'deleted'`) the changeType can just be used as it is...
        } else {
            // ...otherwise if we can't find that record, it must have been deleted. So we set the `$changeType` here.

            // The `$changedRecord` lines will json_decode that `Activity` record's `properties` attribute.
            // Which is a stored version of the deleted record in this part of the `if...else` block.
            $changedRecord = (object) json_decode($recentActivity->properties)->attributes;
            $changeType = 'deleted';
        }

Find the user who changed the record.
$changedBy = User::where('id', $recentActivity->causer_id)->first();

Thanks, I am refactoring this now, might submit another pr, with amended code! Have a great time, I am closing this PR.


text:
Blanks in folder name

Some user have blanks in there store_path. I did a short test with linux an windows.
dataserv-client version 2.1.11
dataserv-client.exe --store_path=D:\storj test\ --max_size=1024000000 farm
That is wrong. I would expect.
dataserv-client.exe --store_path="D:\storj test" --max_size=1024000000 farm
The same solution works on linux as well without the drive letter ofc.

Node's child_process.spawn() will automatically escape arguments passed in, so this should be resolved by https://github.com/Storj/driveshare-gui/pull/65/files#diff-f8c0e7dbf199c360d2ba5f14a7e62a31R35

Yes the bug is fixed with your branch. I will keep that bug open until your branch is merged.

Okay very good. This issue is referenced there so it should auto close on merge. Thanks for going through this stuff with me!

fixed with driveshare-gui develop (0.4.0)

authors: gordonwritescode littleskunk

repo: Storj/driveshare-gui


text:
Improve Standalone Mode

Standalone mode is our default config, but it has never been production-safe: the API has been exposed on the main port, allowing for minimal security.
The work is intended to support more flexible production configs based on Standalone mode:

[x] Allow API server to run on a separate port
[x] Fix stream listener handoff in standalone mode
[ ] Allow Standalone mode to launch slave workers (deferred to future issue)

Deferring the slave worker bit. That's going to be a reasonably significant change, so I've opened it as #54.

repo: StreamMachine/StreamMachine


text:
🛑 Nextcloud Papa is down

In ffe8ef0, Nextcloud Papa ($NEXTCLOUD_2) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Nextcloud Papa is back up in 085d08f.

repo: StudFu-WordToMD/status


text:
🛑 Nextcloud is down

In b21658d, Nextcloud ($NEXTCLOUD) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Nextcloud is back up in cbb3ca8.


text:
🛑 Newton is down

In 8b9e1d0, Newton (https://buehler.rocks/) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Newton is back up in 0bafb43 after 5 minutes.

repo: Stunkymonkey/upptime-checks


text:
我有一台vless的vps，vps上再装udpspeeder能否和它共存

本地端是树莓派4B的旁路由

Try it is faster than ask it.

repo: SuLingGG/OpenWrt-Rpi


text:
Make a simple shooting game using Web Dev Skills

I will be making a simple 2d simple shooting game using
1.HTML
2.CSS
3JavaScript
@Subhradeep10  Would like if you would assign me this project

@AryamanAdivyaSingh47 Go ahead, assigned to you

@AryamanAdivyaSingh47 Any updates!?

hey is the issue still open? i would love to contribute in this :)

@Ghat0tkach Go ahead, Assigned to you

Yeah, Actually the project will be going slow for a week or so ch I have
tests going on in college. You know.
On Wed, 12 Oct 2022, 08:21 Subhradeep Samanta, @.***>
wrote:

@AryamanAdivyaSingh47 https://github.com/AryamanAdivyaSingh47 Any
updates!?
—
Reply to this email directly, view it on GitHub
https://github.com/Subhradeep10/Amazing_Web_Projects/issues/59#issuecomment-1275513433,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/APYNUFRCPAW5KOBXJGAJEHDWCYRSHANCNFSM6AAAAAARA2SGCQ
.
You are receiving this because you were mentioned.Message ID:
@.***>


text:
SublimeLinter-html-tidy make the paths configuration not work

AS I assigned here https://github.com/SublimeLinter/SublimeLinter-html-tidy/issues/33

Please do not create duplicate issues. If, through discussion on the linked issue, it is discovered that a problem exists in SL3 core, we can revisit this.

I submit a pull request and it is still no response, why ?
https://github.com/SublimeLinter/SublimeLinter-html-tidy/pull/35

Sorry it's taking some time. Please be patient as we get to your issue.
On Tue, Jun 23, 2015 at 10:51 PM, hu2008yinxiang notifications@github.com
wrote:

I submit a pull request and it is still no response, why ?
https://github.com/SublimeLinter/SublimeLinter-html-tidy/pull/35
Reply to this email directly or view it on GitHub:
https://github.com/SublimeLinter/SublimeLinter3/issues/286#issuecomment-114708146

authors: grotewold hu2008yinxiang jawshooah


text:
Allow PATH option in user settings.

I know that linter executables should be in PATH in order for the linter to be enabled. My request is to remove that restriction. I have implemented a path option in the user settings of my linter, which almost works. The problem is that SublimeLinter3 does not seem to read that file when it initially tries to enable linters. It works if I go into linter.py and make a change, then SublimeLinter3 reloads the linter, at which point it reads the user settings and the executable is found and properly executed.
So it appears the only thing missing is that SublimeLinter3 should load the user settings before it tries to find the executables when it enables linters.

I can kinda see how this could get a bit more complicated than it looks on the surface. Do you have a specific use case in mind for this?

Yes, the use case is referenced by the two links above in code and documentation respectively. The advantage is that the linter executable (which in my case is a compiler) does not have to be in the system wide PATH which often is already long enough as it is. Secondly, different projects (or even working copies) may want to use different versions of the compiler. It is not a good practise to put comilers in the system PATH, especially when more than one are installed. Therefore it is an advantage to be able to customise the path to the linter executable in the configuration.
What complications do you see in f72603e0486ef031f67e7c49d7dbb14d39ad5810, which implements this?

Hi, I think I implemented something similar without needing a patch upstream. For the flake8 linter I enabled a setting executable
https://github.com/SublimeLinter/SublimeLinter-flake8/blob/adb4890d55acd0c5028ec0685a111b8bd93ae3d7/linter.py#L53-L62
which gets processed in build_cmd like so
https://github.com/SublimeLinter/SublimeLinter-flake8/blob/adb4890d55acd0c5028ec0685a111b8bd93ae3d7/linter.py#L91-L100
If this is irrelevant, sorry for the noise.

Thanks @kaste for thinking with me. But it doesn't help, sadly. You implement the executable setting in much the same way as I do. The reason you seem not to need an upstream patch is that you do define cmd before can_lint is called, which which succeeds in finding. That is, can_lint uses the hard coded cmd value, whereas linting happens using build_cmd which uses executable as given in settings.
I could cheat in the same way by hard coding my cmd as notepad.exe just to let can_lint pass, but that would be a very ugly hack.
PR #587 makes can_lint read the settings first and use the same executable as is used for the actual linting, to determine whether linting will work or not.
I have tried re-implementing can_lint to insert that call myself, but I can't seem to call the base implementation from it as it hasn't finished constructing yet. I am a Python noob though, so I might be doing something wrong.

When you look at NodeLinter they actually implement can_lint very optimistic, bc they need to find the correct executable later. And they basically override context_sensitive_executable_path which gets called during build_cmd. AFAIK context_sensitive_executable_path must return (False, <path>) for success and (False, '') to disable the linter at this late point.
(Aside: it confuses me that you define executable on cls; I do it as a setting; bc you actually want late resolving)
My attempt would be:

don't use cls.executable
define cls.cmd = ('epcomp.exe', '@')
implement context_sensitive_executable_path so that it returns the correct path to cmd as late as possible

Thank you! I got it working now. What is the purpose of '@'? I have left it out. I cannot seem to disable the linter when a non-existent path is configured, neither with False, '' nor with True, None. But I'm fine with that, the OS supplies a suitable error message.
https://github.com/veelo/SublimeLinter-contrib-epcomp/blob/master/linter.py

Yes you're correct. You cannot literally disable the linter at that point anymore, but it will/should stop the linting attempt when you return True, None and print an error. Something like cannot locate...
The @ is just a mistake, I meant *, which would fill in the linter settings as args automatically. So if you do cmd = ('epcomp.exe', '-y', '*') you should get the -y you later fill in manually. All the other options https://github.com/veelo/SublimeLinter-contrib-epcomp/blob/2cbc3baaf99e33ee96696b16cd041e6f5c9a7a83/linter.py#L100-L102 could be actually settings like I've shown here https://github.com/SublimeLinter/SublimeLinter-flake8/blob/adb4890d55acd0c5028ec0685a111b8bd93ae3d7/linter.py#L53-L62 and these will be transformed to your args. This is explained here http://sublimelinter.readthedocs.io/en/latest/linter_attributes.html#defaults
The result would be that you don't have to override build_cmd at all.

Thanks a lot for all your help! I'll incorporate the points above in a later release.

authors: braver kaste veelo


text:
Not working with the release of 3.0

Hi Robin,
I love this project and solve a problem we had. However, with the update of 3.0. This doesn't seem to work anymore. I just see the loading screen when trying with server mode enable.  Any guidance with this?

Resolved with https://github.com/Suchiman/BlazorDualMode/commit/fad4a6c934a1e69703e1d81ad254465176f227f1

repo: Suchiman/BlazorDualMode


text:
How to tell the compiler that a method is a logger method?

I have been trying out the SerilogAnalyser. Unlike the examples in the Readme, I have Custom Logger Interface which has all the log methods.
Since, we are moving to structured logging, we would like to employ some kind of analyzer to verify the code at the compile time to see if the log entries are done correctly.
I used the MessageTemplateFormatMethod attribute approach on my interface methods and it did the job.
I was wondering if we could make the Attribute name itself configurable so that my core code, where the logging interface is defined does not have a dependency on any specific logging framework.

This PR gives you this ability - https://github.com/Suchiman/SerilogAnalyzer/pull/53

@brianfeucht  How do we tell the analyser which attribute in what namespace to look for with this implementation?

authors: JinsPeter brianfeucht

repo: Suchiman/SerilogAnalyzer


text:
Is there a way to resize images downloaded through RemoteImageGetter ?

I want to force the size of the images downloaded since some of them are downloaded and resized to very small size.
Can i do something with RemoteImageGetter like i would do in ImageGetter by overriding a method like getDrawable ?

Can i do something with RemoteImageGetter like i would do in ImageGetter by overriding a method like getDrawable ?

Sure, you could resize the image here, before using it.
Will not consider this for the library.

authors: alemedero dschuermann

repo: SufficientlySecure/html-textview


text:
When loading an answer set that had a signature stored in it, user is getting error "None object has no attribute seek"

Error is popping up when trying to display a template that has skip undefined turned off just before the signature screen should get triggered.
We do explicitly exclude any file like objects from the stored answer set on both loading and saving, but something may not be working correctly there.

Looks like the specific error might have been due to a "stale" answer set but we should consider adding better error handling when loading answers. Perhaps this is an upstream fix--if the file doesn't exist .signature shouldn't be defined, it shouldn't result in a None value

repo: SuffolkLITLab/docassemble-AssemblyLine


text:
Aero Acrobat

Aero Acrobat is an exhilarating arcade-style game that challenges players to navigate a courageous boy through a breathtaking ascent into the sky. With the help of the spacebar and four arrow keys, players must guide the boy upwards, maneuvering through a maze of obstacles and platforms.
Functionalities:
Aero Acrobat uses the request Animation Frame function built into
modern browsers in order to maintain a consistent refresh rate that makes
for a more enjoyable experience.  The game is also updated with specific
tick intervals to maintain more consistent position updating of the avatar.
As the game updated roughly 60 times per second, tick rates were used
to determine the rate at which platforms were removed.  tickCount was incremented
with each call of tick by GameView and platforms were removed when it
reached a certain threshold.  This simplified the removal of platforms at
regular intervals without having to deal with the millisecond count and
finding appropriate values of x for which (time % x) evaluated to every ~1-3 seconds.
Assign this to me under GSSoc'24

Closing this as exists #2105 g

authors: Aditijainnn Sulagna-Dutta-Roy

repo: Sulagna-Dutta-Roy/GGExtensions


text:
🛑 Zinc 20 is down

In ba34096, Zinc 20 (https://zinc20.docking.org) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Zinc 20 is back up in e425ebf.

repo: Sulstice/Uptime-Cheminformatics


text:
🛑 Binding Database is down

In 4081304, Binding Database (http://www.bindingdb.org/bind/index.jsp) was down:

HTTP code: 503
Response time: 195 ms

Resolved: Binding Database is back up in f0f5f56.


text:
🛑 Chem Exper is down

In 7da6494, Chem Exper (http://www.chemexper.com/) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Chem Exper is back up in 31f5ee9.


text:
🛑 Comparative Toxicogenomics Database is down

In 6188ac1, Comparative Toxicogenomics Database (http://ctdbase.org/) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Comparative Toxicogenomics Database is back up in 7f552bb.


text:
🛑 Chem Exper is down

In 50fff01, Chem Exper (http://www.chemexper.com/) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Chem Exper is back up in 832c564.


text:
🛑 Pesticide Info is down

In bf9627a, Pesticide Info (https://www.pesticideinfo.org/) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Pesticide Info is back up in 9ba19b9.


text:
🛑 Zinc 20 is down

In 15dd86e, Zinc 20 (https://zinc20.docking.org) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Zinc 20 is back up in c924717.


text:
🛑 Zinc 15 is down

In bb08d71, Zinc 15 (https://zinc15.docking.org) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Zinc 15 is back up in b4e7f50.


text:
🛑 Chemical Resolver is down

In 412b317, Chemical Resolver (https://cactus.nci.nih.gov/chemical/structure) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Chemical Resolver is back up in 99441cc.


text:
🛑 Zinc 15 is down

In f2c3777, Zinc 15 (https://zinc15.docking.org) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Zinc 15 is back up in e987b9a.


text:
🛑 Zinc 20 is down

In 7f6ba03, Zinc 20 (https://zinc20.docking.org) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Zinc 20 is back up in 91d5a88.


text:
🛑 Chem Exper is down

In a3bff03, Chem Exper (http://www.chemexper.com/) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Chem Exper is back up in 8ef58a4.


text:
🛑 Chem Exper is down

In 94ef669, Chem Exper (http://www.chemexper.com/) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Chem Exper is back up in d47bcd0 after 576 days, 9 hours, 21 minutes.


text:
🛑 Zinc 20 is down

In 167318f, Zinc 20 (https://zinc20.docking.org) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Zinc 20 is back up in a1fc845.


text:
🛑 Chem Exper is down

In 0be5154, Chem Exper (http://www.chemexper.com/) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Chem Exper is back up in d8e8594 after 7 minutes.


text:
🛑 Zinc 15 is down

In 833359c, Zinc 15 (https://zinc15.docking.org) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Zinc 15 is back up in 6380360.


text:
🛑 Chem Exper is down

In 7b1debc, Chem Exper (http://www.chemexper.com/) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Chem Exper is back up in c2ac739 after 37 minutes.


text:
🛑 Binding Database is down

In 5f11f7c, Binding Database (http://www.bindingdb.org/bind/index.jsp) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Binding Database is back up in 1e06db0 after 16 minutes.


text:
🛑 Pesticide Info is down

In b4cd281, Pesticide Info (https://www.pesticideinfo.org/) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Pesticide Info is back up in c5ca2a6 after 8 minutes.


text:
🛑 Chem Exper is down

In 2562959, Chem Exper (http://www.chemexper.com/) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Chem Exper is back up in 3542d7f after 16 minutes.


text:
🛑 Chem Exper is down

In 3262fe4, Chem Exper (http://www.chemexper.com/) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Chem Exper is back up in 08a8e5a after 11 minutes.


text:
🛑 Chem Exper is down

In 63f961d, Chem Exper (http://www.chemexper.com/) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Chem Exper is back up in 7dbe61b after 13 minutes.


text:
🛑 Binding Database is down

In 7110245, Binding Database (http://www.bindingdb.org/bind/index.jsp) was down:

HTTP code: 503
Response time: 798 ms

Resolved: Binding Database is back up in 63e624e after 15 minutes.


text:
🛑 ITK Analysis of Large Histology Datasets is down

In 9a526be, ITK Analysis of Large Histology Datasets (http://www.na-mic.org/Wiki/index.php/ITK_Analysis_of_Large_Histology_Datasets) was down:

HTTP code: 0
Response time: 0 ms

Resolved: ITK Analysis of Large Histology Datasets is back up in 2118033 after 9 minutes.

repo: Sulstice/Uptime-Medical-Informatics


text:
🛑 Zinc 20 is down

In efc0de7, Zinc 20 (https://zinc20.docking.org) was down:

HTTP code: 0
Response time: 0 ms

Resolved: Zinc 20 is back up in c9f7d8b.

repo: Sulstice/uptime-zinc-db


text:
Dnm

Purpose of this pull request
This pull request...
Select the type of change

[ ] Minor Changes - Typos, formatting, slight revisions
[ ] Update Content - Revisions, updating sections
[ ] New Content - New features, sections, pages, tutorials
[ ] Site and Tools - .clabot, version updates, maintenance, dependencies, new packages for the site (Docusaurus, Gatsby, React, etc.)

Ticket (if applicable)

this was taken care of in #3867

repo: SumoLogic/sumologic-documentation


text:
Update Settings “general”

Automatically generated by Netlify CMS

👷 Deploy Preview for resplendent-croquembouche-407cac processing.

Name
Link

🔨 Latest commit
eed6565adec890cb53e9f22585b80bc880be6c4d

🔍 Latest deploy log
https://app.netlify.com/sites/resplendent-croquembouche-407cac/deploys/65c62781f5b8a200073e2439

repo: Sumogasbord/bluise


text:
funcy.autocurry doesn't work with functions with key-words only

Hi! I'm happy to use the library but looks like I found a bug:
>>>@funcy.autocurry
...def a(b, c): return b + c

>>>a(c=1)(2)
3

>>>@funcy.autocurry
...def aa(b, *, c): return b + c

>>>aa(c=1)
Traceback (most recent call last):
   ...
TypeError: aa() missing 1 required keyword-only argument: 'c'

funcy version: 1.17

Can you write a test?
пн, 7 мар. 2022 г., 02:11 Adrian Dankiv @.***>:

Hi! I'm happy to use the library but looks like I found a bug:
@.***
...def a(b, c): return b + c

a(c=1)(2)
3

@.***
...def aa(b, *, c): return b + c

aa(c=1)
Traceback (most recent call last):
...
TypeError: aa() missing 1 required keyword-only argument: 'c'

—
Reply to this email directly, view it on GitHub
https://github.com/Suor/funcy/issues/115, or unsubscribe
https://github.com/notifications/unsubscribe-auth/AACFLRZGRWPUF6MIQ5SW7NTU6T7OLANCNFSM5QBP25FA
.
Triage notifications on the go with GitHub Mobile for iOS
https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675
or Android
https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.
You are receiving this because you are subscribed to this thread.Message
ID: @.***>

There are several points in funcy where it fails with kwonly args. Looks like fixing it is complicated by Python 2 support. I will consider dropping it and then fixing this stuff.

So, dropped Python 2 recently. Improved positional only and kw only args support in @decorator.

Fixed in https://github.com/Suor/funcy/commit/5dc4547e05b00a85f44635f585cc69135a30babc.

repo: Suor/funcy


text:
[!!!][BUGFIX] Set permissions correctly

The change will allow graceful fallback to the default bucket
permissions for new objects to avoid users not being able to
operate on file ACLs via other tools (for example gsutil or
the cloud console).
It also removes the semantics of private and publicRead
CloudStorage API predefined ACLs in favour of default bucket
permissions and properly created additional ACLs on
visibility change.
Fixes: #3

Thanks.  We'll take a look at this shortly.

I have ameded the changeset to your suggestions. Please let me know if I got everything right.

All the changes look good, can we just use an if-else here please, so it reads a bit better.
Something like
if ($originalVisibility === AdapterInterface::VISIBILITY_PUBLIC) {
    $this->publishObject($newpath);
} else {
    $this->unPublishObject($newpath);
}

:+1: after that

Ah I missed / misinterpreted that one. Done. :)

Awesome, thanks. :+1:.
There are just some minor linting issues, but I'll take care of those.

Thanks for taking care! :)
Suggestion: Make Code Style issues fail the build, as a contributor I'd be glad about it.

My pleasure. :)
I agree. Scrutinizer is supposed to lint it after a travis build, but it doesn't seem to be complaining, but I'll look into it tomorrow, before we do a release.

authors: cedricziel matthewgoslett zoidbergwill

repo: Superbalist/flysystem-google-storage


text:
Support for parsing inflections

Definitions on Wiktionary can come with inflections, as in this screenshot:

Raw entry from WitkionaryParser:
fly (imperative fly, present tense flyr, simple past fløy, past participle flydd or fløyet)

to fly

What I'd like to see parsed:
Inflection: [imperative] fly
Inflection: [present tense] flyr
Inflection: [simple past] fløy
Inflection: [past participle] flydd
Inflection: [past participle] fløyet

Word definition:
to fly

My use case is creating a dictionary with inflection support (for e-readers like Kindle).
I've worked around this limitation in my scripts but it'd be nice if I didn't have to and it was supported.
EDIT: This needs so many workarounds and has so many edge cases I wouldn't be surprised this never gets implemented as out of scope >.>

I agree that this would be a very useful feature, but given that the inflection systems of languages are so different, probably this is best dealt with at the application rather than module level. Norwegian might have the listed inflection classes (imperative, present tense, simple past) but neither these classes nor their names can be guaranteed for every language -- perhaps not even across different contributors to the same language ('simple past' = 'preterite' for some people, etc.)

After dealing with this for a while I'm inclined to agree. There's just too many edge cases I'm aware of and that's just Norwegian.
Feel free to close this as out of scope.

On the other hand some languages -- like Latin -- have fully worked out inflectional paradigms for each entry. This could be very useful to include in the parsed dict, but again there is not much consistency even for lemmas of the same language. Maybe an option to try to include the 'inflection' section where applicable.
As an example, see the 'inflection' section for this Latin entry:
https://en.m.wiktionary.org/wiki/pango
Do many other languages include this info?
William Michael Short
Lecturer in Classics
Department of Classics & Ancient History
University of Exeter

From: Martin notifications@github.com
Sent: Monday, August 6, 2018 3:06:41 PM
To: Suyash458/WiktionaryParser
Cc: wmshort; Comment
Subject: Re: [Suyash458/WiktionaryParser] Support for parsing inflections (#30)
After dealing with this for a while I'm inclined to agree. There's just too many edge cases I'm aware of and that's just Norwegian.
Feel free to close this as out of scope.
—
You are receiving this because you commented.
Reply to this email directly, view it on GitHubhttps://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FSuyash458%2FWiktionaryParser%2Fissues%2F30%23issuecomment-410868255&data=02|01||598251a60ce643eb8ff508d5fbe8e3bf|84df9e7fe9f640afb435aaaaaaaaaaaa|1|0|636691900019575935&sdata=V6RiMk572gRVygYVTeN9NdUBwg6vkbe%2BfYaxqX7AeiA%3D&reserved=0, or mute the threadhttps://nam04.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAizEooCzdwEhRkZ7MeLHOcLMvBvRw-JJks5uOL3xgaJpZM4VEpY3&data=02|01||598251a60ce643eb8ff508d5fbe8e3bf|84df9e7fe9f640afb435aaaaaaaaaaaa|1|0|636691900019575935&sdata=aH2Haa8mVKLt%2BE%2BOO7nLp9umZtZzB5pkrrA2lUqnUcU%3D&reserved=0.


text:
(Manifest) by The Weakerthans unsupported.

Check if issue with swaglyrics or whether song lyrics unavailable on Genius.

stripper -> The-Weakerthans-

done

repo: SwagLyrics/SwagLyrics-For-Spotify


text:
SwiftUI Layout System | Alexander Grebenyuk

推荐收录
链接
https://kean.github.io/post/swiftui-layout-system

SwiftUI Layout System | Alexander Grebenyuk
@四娘：今年新出的 SwiftUI 在易用性上做到了极致，其中起到支撑作用的就是布局引擎，作者在这篇文章里带我们剖析了 SwiftUI 的布局机理和 Stack 的实现，与 AutoLayout 进行比较，解释了 SwiftUI 为什么不需要处理约束无法解决的情况，并且总能给出一个 valid 的布局。

repo: SwiftOldDriver/iOS-Weekly


text:
iOS build failing on package index but not local

Please describe the bug
On my package, APNSwift builds are failing for iOS. However I can locally successfully, build my project.
Explain the steps needed to reproduce the bug

Build and run APNSwift Locally inside an iOS Project
See build works.

What was the expected behaviour?
Build is built correctly on Package Index Server
Additional context
here's an example project - Fern.zip

Hi Kyle, thanks for reporting this!
We're guessing the wrong scheme, which unfortunately can happen with iOS builds. I've opened a PR which should fix the issue, given our build system the hint it needs.

Thanks @finestructure I see your commit but no PR!
I'll update spi later today if I don't see a pr from ya. Thanks a bunch!

@finestructure this doesn't seem to be resolved, or am I mistaken?

Looks like this is now resolved!

authors: finestructure kylebrowning


text:
Version 5.2.0 is Created, not expected 5.3.0

If I use SPM in Xcode, and specify 5.0.0 up to next major, I get 5.2.0
If in my local package I specify:
      .package(url: "https://github.com/SwifterSwift/SwifterSwift", from: "5.3.0")

I get:
Dependencies could not be resolved because no versions of 'swifterswift' match the requirement 5.3.0..<6.0.0 and root depends on 'swifterswift' 5.3.0..<6.0.0.

The main page seems to indicate that there is a 5.3.0 version available - in fact the instructions explicitly mention it.

Perhaps you're confusing the version of the SwifterSwifter package and the version of Swift. We require Swift 5.3 to be used in order for the package to be available, but the latest released version of this project is 5.2.0.

You can use this:
.package(url: "https://github.com/SwifterSwift/SwifterSwift", branch: "master")
or
.package(url: "https://github.com/SwifterSwift/SwifterSwift", commit: "COMMIT_ID")

Thanks for the clarification!

authors: Mozahler cdoky guykogus

repo: SwifterSwift/SwifterSwift


text:
Baseurl

This enabled me to put the system.config.js file into the src folder and fixed an issue where the promises were not being returned correctly.

Hmm... I'm noticing that one of my commits isn't really helping anything. 5220af3
What I'm seeing is that running minify after using this code is still broken. There is some promise that isn't finishing before the end again for some reason.

This commit actually breaks the build: https://github.com/lookfirst/systemjs-route-bundler/commit/5220af3551449b7d2fd985c413eba279304a6a82
It should work without it. See current master.

Ok... it should be ready to go again. I was up late and wasn't thinking straight.

don't merge this yet

ok, please merge this now. i've successfully got my seed project working with everything under dist now, so this is definitely working for me and shouldn't impact your code at all.

:+1:

authors: lookfirst marjan-georgiev

repo: Swimlane/systemjs-route-bundler