test用户再test库具有全部权限。
创建outline后执行sql并没有ERROR 5268 (HY000): SQL reach max concurrent num 0报错出现。
执行sql如下：
[root@ob-server3 ~]# mysql -h192.168.26.11 -P 2883 -utest@obcp_t2#obcluster_dn -p -A -c
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MySQL connection id is 2988928
Server version: 5.6.25 OceanBase 3.1.2 (r20211209200749-9f130e90892a9fa3c468a2668a794b9e12c1fdae) (Built Dec 9 2021 20:40:13)

Copyright © 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MySQL [(none)]> use test;
Database changed
MySQL [test]>  create table t1(a int primary key, b int, c int);
Query OK, 0 rows affected (0.21 sec)

MySQL [test]>  create outline ol_1 on select/*+ max_concurrent(0)*/ * from
    -> t1 where b =1 and c = 1;
Query OK, 0 rows affected (0.06 sec)

MySQL [test]> select * from t1 where b =1 and c = 1;
Empty set (0.04 sec)

复制