starrocks icon indicating copy to clipboard operation
starrocks copied to clipboard

[Bug] insert into select null not supported in 2.3.0 ?

Open trueeyu opened this issue 3 years ago • 0 comments

Steps to reproduce the behavior (Required)

mysql> show create table t2;
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                                                                                                                                                                                                                               |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| t2    | CREATE TABLE `t2` (
  `c1` int(11) NULL COMMENT "",
  `c2` int(11) REPLACE_IF_NOT_NULL NULL COMMENT "",
  `c3` ARRAY<int(11)> REPLACE_IF_NOT_NULL NULL COMMENT ""
) ENGINE=OLAP 
AGGREGATE KEY(`c1`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`c1`) BUCKETS 1 
PROPERTIES (
"replication_num" = "1",
"in_memory" = "false",
"storage_format" = "DEFAULT",
"enable_persistent_index" = "false"
); |
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> insert into t2 select c1+2, c2, null from t2; ERROR 1064 (HY000): Vectorized engine does not support the operator, node_type: 5

Expected behavior (Required)

Real behavior (Required)

StarRocks version (Required)

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

trueeyu avatar Aug 11 '22 07:08 trueeyu