oceanbase

1
--disable_query_log
2
set @@session.explicit_defaults_for_timestamp=off;
3
--enable_query_log
4
#owner: link.zt
5
#owner group: sql1
6

7
--disable_warnings
8
drop table if exists t1,t2,t3,t4;
9
--enable_warnings
10

11
connect (conn1,$OBMYSQL_MS0,$OBMYSQL_USR,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
12
--error 1064
13
set password for  = password('pass11');
14
--error 1064
15
set password '' for  = password('pass11');
16

17
--real_sleep 5
18

19
connect (conn2,$OBMYSQL_MS0,$OBMYSQL_USR,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
20
--error 1133
21
set password for  '' = password('pass11');
22
--error 1396
23
create user '' identified by 'pass11';
24
--real_sleep 5
25

26
connect (conn3,$OBMYSQL_MS0,$OBMYSQL_USR,$OBMYSQL_PWD,test,$OBMYSQL_PORT);
27