kevin

bug: slow-SQL-Q16-when subquery use not like and not in sql on 10GB data spend too much time

3

### Describe the problem 1. use tpch data 2. execute sql ` select p_brand, p_type, p_size, count(distinct ps_suppkey) as supplier_cnt from partsupp, part where p_partkey = ps_partkey and p_brand 'Brand#45'...

bug: stonedb5.6 build failed on centos7.9 wich rocksdb6.12.6

3

### Describe the problem http://192.168.30.238:8080/job/stonedb5.6-zsl-centos7.9-with-rocksdb6.12.6/ http://192.168.30.238:8080/job/stonedb5.6-zsl-centos7.9-with-rocksdb6.12.6/1/execution/node/46/log/ [ 86%] Built target stonedb [100%] Built target sql [100%] Linking CXX executable mysqld [100%] Linking CXX executable pfs_connect_attr-t /opt/rh/devtoolset-7/root/usr/libexec/gcc/x86_64-redhat-linux/7/ld: /usr/local/stonedb-gcc-rocksdb/lib/librocksdb.a(backupable_db.o): undefined reference to...

执行完Q18的语句，内存使用了135GB，分析究竟为何使用这么多 SQL语句： select c_name, c_custkey, o_orderkey, o_orderdate, o_totalprice, sum(l_quantity) from customer, orders, lineitem where o_orderkey in ( select l_orderkey from lineitem group by l_orderkey having sum(l_quantity) > 300 ) and...

### Describe the problem 1. use tpch data 2. exec sql ` select sum(l_extendedprice) / 7.0 as avg_yearly from lineitem, part where p_partkey = l_partkey and p_brand = 'Brand#23' and...

### Describe the problem 1. use tpch data 2. exec sql ` -- using default substitutions select c_name, c_custkey, o_orderkey, o_orderdate, o_totalprice, sum(l_quantity) from customer, orders, lineitem where o_orderkey in...

### Describe the problem 1. use tpch data 2. exec sql ` select s_acctbal, s_name, n_name, p_partkey, p_mfgr, s_address, s_phone, s_comment from part, supplier, partsupp, nation, region where p_partkey =...

### Describe the problem 1. when force use parallel hash join and the table is very large beyond the memory 2. the stonedb on paralller hash join will OOM and...

### Describe the problem ` /stonedb57/install/bin/mysql -D tpch -e " explain select o_orderpriority, count(*) as order_count from orders where o_orderdate >= date '1993-07-01' and o_orderdate < date '1993-07-01' + interval...

bug: stonedb5.7 on centos7.9 run mtr tests fail

2

### Describe the problem http://192.168.30.238:8080/job/stonedb5.7-zsl-centos7.9/10/execution/node/71/log/ https://gitee.com/adofsuaron/stonedb-dev/blob/stonedb-5.7/.jenkins/jenkinsfile-stonedb5.7-centos7.9 ` cd /stonedb57/install/mysql-test sudo ./mysql-test-run.pl --suite=stonedb --nowarnings --force ` ` + JENKINS_NODE_COOKIE=dontKillMe + export JENKINS_NODE_COOKIE=dontKillMe + JENKINS_NODE_COOKIE=dontKillMe + cd /stonedb57/install/mysql-test + sudo ./mysql-test-run.pl --suite=stonedb...

fix(tianmu): Fix errors in the Q4 (exists subquery) and Q16 query result (#330, #331)

2

Q4 uses the EXISTS subquery and previously optimized the EXISTS scenario using a parallel Hash Join, but an exception was found in the result set. Roll back the EXISTS process...