oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
#owner: kaizhan.dkz
5
#owner group: sql1
6
#tags: update
7
#description:
8

9
--disable_warnings
10
drop table if exists t1;
11
--enable_warnings
12
create table t1(pk int primary key, c1 int);
13
insert into t1 values(1,2), (2, 3),(3,4),(4,5);
14
select * from t1;
15
update t1 set c1=pk ;
16
select * from t1;
17
update t1 set c1=pk where pk=1 ;
18
select * from t1;
19
update t1 set c1=pk where pk in (1,2,3,4) ;
20
select * from t1;
21
update t1 set c1=pk-0 ;
22
select * from t1;
23