2022-11-14 mysql列存储引擎-subquery中出现聚合函数导致宕机-问题记录及分析

摘要:

mysql列存储引擎-subquery-select导致宕机-问题记录

关联issue: https://github.com/stoneatom/stonedb/issues/906

DDL:

user1:

 
CREATE TABLE t_test1(
  id INT NOT NULL AUTO_INCREMENT,
  first_name VARCHAR(10) NOT NULL,
  last_name VARCHAR(10) NOT NULL,
  sex VARCHAR(5) NOT NULL,
  score INT NOT NULL,
  copy_id INT NOT NULL,
  PRIMARY KEY (`id`)
) engine=tianmu;

DELIMITER //
    create PROCEDURE add_user1(in num INT)
    BEGIN
        DECLARE rowid INT DEFAULT 0;
        DECLARE firstname CHAR(1);
        DECLARE name1 CHAR(1);
        DECLARE name2 CHAR(1);
        DECLARE lastname VARCHAR(3) DEFAULT '';
        DECLARE sex CHAR(1);
        DECLARE score CHAR(2);
        WHILE rowid < nu