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_abort_on_error
10
--disable_warnings
11
sleep 2;
12
drop database if exists db1;
13
create database if not exists db1;
14
use db1;
15
--disable_warnings
16
drop table if exists test;
17
--enable_warnings
18
create table test(c1 int primary key, c2 int, c3 int);
19
insert into test values(1,1,1);
20
insert into test values(2,2,2);
21

22
set @@global.ob_enable_plan_cache= 0;
23
connect (conn,$OBMYSQL_MS0,$OBMYSQL_USR,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
24
use db1;
25
update test set c2=c1+c2, c3=c2+c1;
26
let $value = query_get_value(select c2 from test where c1 = 1, c2, 1);
27
if ($value == 2)
28
{
29
  --echo succeed
30
}
31
let $value = query_get_value(select c3 from test where c1 = 1, c3, 1);
32
if ($value == 3)
33
{
34
  --echo succeed
35
}
36
select * from test;
37
#set @@global.sql_mode = "STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION, STANDARD_ASSIGNMENT";
38
#
39
#connect (conn2,$OBMYSQL_MS0,root@sys,,*NO-ONE*,$OBMYSQL_PORT);
40
#use db1;
41
#update test set c2=c1+c2, c3=c2+c1;
42
#let $value = query_get_value(select c2 from test where c1 = 1, c2, 1);
43
#if ($value == 3)
44
#{
45
#  --echo succeed
46
#}
47
#let $value = query_get_value(select c3 from test where c1 = 1, c3, 1);
48
#if ($value == 3)
49
#{
50
#  --echo succeed
51
#}
52
#select * from test;
53
#set @@global.sql_mode = "STRICT_TRANS_TABLES";
54
set @@global.ob_enable_plan_cache= 1;
55
drop table test;
56
drop database db1;
57

58