[MCOL-4261] Add support for REPLACE INTO SELECT FROM Created: 2020-08-20  Updated: 2023-12-15

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: None
Fix Version/s: Icebox

Type: New Feature Priority: Major
Reporter: susil.behera Assignee: Max Mether
Resolution: Unresolved Votes: 0
Labels: None
Environment:

Server version: 10.5.6
MCS version: 1.5.4-1



 Description   

We should add support for REPLACE INTO SELECT FROM.

CREATE TABLE t1(
name VARCHAR(50),
population INT
) ENGINE=Columnstore;
INSERT INTO t1(name,population)
VALUES('New York', 8008278),
('Los Angeles', 3694825),
('San Diego', 1223405);

CREATE TABLE t2(
name VARCHAR(50),
population INT
) ENGINE=Columnstore;
INSERT INTO t2(name,population)
VALUES('San Fransisco', 4694825);

REPLACE INTO
t1(name,population)
SELECT
name,
population
FROM
t2;
ERROR 1178 (42000): The storage engine for the table doesn't support REPLACE statement is not supported in Columnstore.


Generated at Thu Feb 08 02:49:01 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.