[GitHub] [incubator-doris] EmmyMiao87 opened a new issue #2504: The BE accidental core during query

[GitBox]

EmmyMiao87 opened a new issue #2504: The BE accidental core during query
URL: https://github.com/apache/incubator-doris/issues/2504
 
 
   **Describe the bug**
   The BE accidental core during query
   
   **To Reproduce**
   CREATE TABLE `left_table` (
     `k1` tinyint(4) NOT NULL COMMENT "",
     `k2` tinyint(4) NOT NULL COMMENT ""
   ) ENGINE=OLAP
   AGGREGATE KEY(`k1`, `k2`)
   COMMENT "OLAP"
   DISTRIBUTED BY HASH(`k1`) BUCKETS 5
   PROPERTIES (
   "storage_type" = "COLUMN"
   );
   CREATE TABLE `test` (
     `k1` tinyint(4) NOT NULL COMMENT "",
     `k2` smallint(6) NOT NULL COMMENT "",
     `k3` int(11) NOT NULL COMMENT "",
     `k4` bigint(20) NOT NULL COMMENT "",
     `k5` decimal(9, 3) NOT NULL COMMENT "",
     `k6` char(5) NOT NULL COMMENT "",
     `k10` date NOT NULL COMMENT "",
     `k11` datetime NOT NULL COMMENT "",
     `k7` varchar(20) NOT NULL COMMENT "",
     `k8` double MAX NOT NULL COMMENT "",
     `k9` float SUM NOT NULL COMMENT ""
   ) ENGINE=OLAP
   AGGREGATE KEY(`k1`, `k2`, `k3`, `k4`, `k5`, `k6`, `k10`, `k11`, `k7`)
   COMMENT "OLAP"
   DISTRIBUTED BY HASH(`k1`) BUCKETS 5
   PROPERTIES (
   "storage_type" = "COLUMN"
   );
   mysql> select * From test;
   
+------+------+------+------+------+------+------------+---------------------+------+------+------+
   | k1   | k2   | k3   | k4   | k5   | k6   | k10        | k11                 
| k7   | k8   | k9   |
   
+------+------+------+------+------+------+------------+---------------------+------+------+------+
   |    1 |    2 |    3 |    4 |    5 | 6    | 2019-10-10 | 2019-10-10 00:00:00 
| 7    |    8 |  117 |
   
+------+------+------+------+------+------+------------+---------------------+------+------+------+
   mysql> select * From left_table;
   +------+------+
   | k1   | k2   |
   +------+------+
   |    1 |    3 |
   |    1 |   13 |
   +------+------+
   select * from left_table where k1=(select k1 from test);
   query hang and be core
   
   **Expected behavior**
   mysql> select * from left_table where k1=(select k1 from test);
   +------+------+
   | k1   | k2   |
   +------+------+
   |    1 |    3 |
   |    1 |   13 |
   +------+------+
   2 rows in set (0.02 sec)
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org