create schema db_replace;
set current_schema to 'db_replace';
create table t1 (a int);
create table t2 (a int);
insert into t1 values(1);
insert into t2 values(2);
create table parts (id int) partition by range(id)
( partition p1 values less than(10),
partition p2 values less than(20),
partition p3 values less than(30),
partition p4 values less than(40),
partition p5 values less than(50));
Replace t1 table t2;
Replace into t1 table t2;
Replace LOW_PRIORITY into t1 table t2;
Replace DELAYED into t1 table t2;
Replace DELAYED t1 table t2;
Replace t1 table t2;
Replace t1 values (3);
Replace t1 (a) values (3),(4);
Replace t1 (a) select a from t2;
replace t1 set a = 7;
replace into parts partition(p1) table t2;
replace DELAYED into parts partition(p1) values(4);
replace DELAYED into parts partition(p1) values(4);
replace DELAYED into parts partition(p1) select a from t2 where a >=2 ;
set dolphin.lower_case_table_names = 0;
create table T1 (A int);
create table T2 (A int);
insert into T1 values(1);
insert into T2 values(2);
create table Parts (id int) partition by range(id)
( partition p1 values less than(10),
partition p2 values less than(20),
partition p3 values less than(30),
partition p4 values less than(40),
partition p5 values less than(50));
Replace T1 table T2;
Replace into T1 table T2;
Replace LOW_PRIORITY into T1 table T2;
Replace DELAYED into T1 table T2;
Replace DELAYED T1 table T2;
Replace T1 table T2;
Replace T1 values (3);
Replace T1 (A) values (3),(4);
Replace T1 (A) select A from T2;
replace T1 set A = 7;
replace into Parts partition(p1) table T2;
replace DELAYED into Parts partition(p1) values(4);
replace DELAYED into Parts partition(p1) values(4);
replace DELAYED into Parts partition(p1) select A from T2 where A >=2 ;
drop table if exists r_replace;
NOTICE:  table "r_replace" does not exist, skipping
CREATE TABLE t_replace (
id int ,
t_id int ,
name varchar(200),
sex varchar(2),
PRIMARY KEY(id,t_id));
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "t_replace_pkey" for table "t_replace"
INSERT INTO t_replace VALUES(1,1,'zhangsan','m');
INSERT INTO t_replace VALUES(2,2,'lisi','m');
INSERT INTO t_replace VALUES(3,3,'wangwu','m');
REPLACE t_replace VALUES(1,1,(select name from t_replace where id =1),'f');
ERROR:  REPLACE not support target relation in subselect.
LINE 1: REPLACE t_replace VALUES(1,1,(select name from t_replace whe...
                                     ^
REPLACE INTO t_replace SET id=3,t_id=3,name=(select name from t_replace where id=3);
ERROR:  REPLACE not support target relation in subselect.
LINE 1: REPLACE INTO t_replace SET id=3,t_id=3,name=(select name fro...
                                                    ^
set dolphin.sql_mode ='';
set sql_ignore_strategy='overwrite_null';
create table tb_616(id int,col1 timestamp not null )
partition by range(col1)
interval('1 year')
(
partition p1 values less than('2022-12-12'),
partition p2 values less than(maxvalue));
insert into tb_616 values (1, null),(2,null);
WARNING:  null value in column "col1" violates not-null constraint
DETAIL:  Failing row contains (1, null).
WARNING:  null value in column "col1" violates not-null constraint
DETAIL:  Failing row contains (2, null).
replace into tb_616 values (1, null),(2,null);
WARNING:  null value in column "col1" violates not-null constraint
DETAIL:  Failing row contains (1, null).
WARNING:  null value in column "col1" violates not-null constraint
DETAIL:  Failing row contains (2, null).
drop table tb_616;
drop schema db_replace cascade;
NOTICE:  drop cascades to 7 other objects
DETAIL:  drop cascades to table t1
drop cascades to table t2
drop cascades to table parts
drop cascades to table "T1"
drop cascades to table "T2"
drop cascades to table "Parts"
drop cascades to table t_replace
reset current_schema;