Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

不同客户端连接 ob server 显示版本有差异 #26

Open
d2022d opened this issue May 17, 2022 · 0 comments
Open

不同客户端连接 ob server 显示版本有差异 #26

d2022d opened this issue May 17, 2022 · 0 comments

Comments

@d2022d
Copy link

d2022d commented May 17, 2022

【产品名称】

3.1.3-OceanBase CE

【产品版本】

[admin@localhost ~]$ obclient --version

obclient Ver 15.1 Distrib 10.4.18-MariaDB, for Linux (x86_64) using readline 5.1

OceanBase 3.1.3
【问题描述】

[admin@localhost ~]$ obclient -h127.0.0.1 -uroot@my_tenant -P2881 -p'root123' -c -A test

Welcome to the OceanBase. Commands end with ; or \g.

Your MySQL connection id is 3221490143

Server version: 5.7.25 OceanBase 3.1.3 (r10100032022041510-a09d3134c10665f03fd56d7f8bdd413b2b771977) (Built Apr 15 2022 02:16:22)




Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.




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




MySQL [test]> \q

Bye

[admin@localhost ~]$ obclient -h127.0.0.1 -uroot@my_tenant -P2883 -p'root123' -c -A test

Welcome to the OceanBase. Commands end with ; or \g.

Your MySQL connection id is 25

Server version: 5.6.25 OceanBase 3.1.3 (r10100032022041510-a09d3134c10665f03fd56d7f8bdd413b2b771977) (Built Apr 15 2022 02:16:22)




Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.




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




使用obclient和mysql连接不同端口,而显示的server version不同,是什么原因导致?

连接2881端口显示Server version: 5.7.25 OceanBase 3.1.3 (r10100032022041510-a09d3134c10665f03fd56d7f8bdd413b2b771977) (Built Apr 15 2022 02:16:22)

MySQL [information_schema]> select version();

+--------------------+

| version()     |

+--------------------+

| 3.1.3-OceanBase CE |

+--------------------+

1 row in set (0.001 sec)




MySQL [information_schema]> show variables like '%version%';

+-------------------------+------------------------------------------------------------------------------------------------------------+

| Variable_name      | Value                                                   |

+-------------------------+------------------------------------------------------------------------------------------------------------+

| ob_last_schema_version | 0                                                     |

| protocol_version    | 10                                                     |

| tls_version       |                                                      |

| version         | 3.1.3-OceanBase CE                                             |

| version_comment     | OceanBase 3.1.3 (r10100032022041510-a09d3134c10665f03fd56d7f8bdd413b2b771977) (Built Apr 15 2022 02:16:22) |

| version_compile_machine |                                                      |

| version_compile_os   |                                                      |

+-------------------------+------------------------------------------------------------------------------------------------------------+

连接2883端口显示Server version: 5.6.25 OceanBase 3.1.3 (r10100032022041510-a09d3134c10665f03fd56d7f8bdd413b2b771977) (Built Apr 15 2022 02:16:22)

MySQL [test]> select version();

+--------------------+

| version()     |

+--------------------+

| 3.1.3-OceanBase CE |

+--------------------+

1 row in set (0.003 sec)




MySQL [test]> show variables like '%version%';

+-------------------------+------------------------------------------------------------------------------------------------------------+

| Variable_name      | Value                                                   |

+-------------------------+------------------------------------------------------------------------------------------------------------+

| ob_last_schema_version | 0                                                     |

| protocol_version    | 10                                                     |

| tls_version       |                                                      |

| version         | 3.1.3-OceanBase CE                                             |

| version_comment     | OceanBase 3.1.3 (r10100032022041510-a09d3134c10665f03fd56d7f8bdd413b2b771977) (Built Apr 15 2022 02:16:22) |

| version_compile_machine |                                                      |

| version_compile_os   |                                                      |

+-------------------------+------------------------------------------------------------------------------------------------------------+

7 rows in set (0.005 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant