StarRocks / starrocks

StarRocks, a Linux Foundation project, is a next-generation sub-second MPP OLAP database for full analytics scenarios, including multi-dimensional analytics, real-time analytics, and ad-hoc queries.
https://starrocks.io
Apache License 2.0
8.36k stars 1.69k forks source link

Error when execute update sql on primary key table #40871

Closed qian0817 closed 3 months ago

qian0817 commented 5 months ago

Steps to reproduce the behavior (Required)

CREATE TABLE `t1` (
    `a` int NOT NULL,
    `b` int NULL,
    `c` bigint NULL
) ENGINE=OLAP
  PRIMARY KEY(`a`)
  DISTRIBUTED BY HASH(`a`);
UPDATE t1 SET b=1, c=1 WHERE a=1;

Expected behavior (Required)

The update sql can be executed correctly.

Real behavior (Required)

ERROR 1064 (HY000): type of exprs is not match slot's, expr_type=7, slot_type=5, slot_name=b backend [id=11003] [host=xxx]

StarRocks version (Required)

3.2.2-269e832

yusufozturk commented 3 months ago

Any update on this issue? We are waiting for this PR.

luohaha commented 3 months ago

@yusufozturk @qian0817 https://github.com/StarRocks/starrocks/pull/41969 fix this.