[Bug]: Incorrect result for `select version()`

DanielZhangQD commented 9 months ago

Is there an existing issue for the same bug?

[X] I have checked the existing issues.

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93): 1.0-dev nightly-70b86219
- Hardware parameters:
- OS type:
- Others:

Actual Behavior

Connect to MO：

Do not use any database, the version is correct
Use the default databases, e.g. system, the version is correct

Create a new database, and use it, the version is incorrect


MySQL [(none)]> select version();
+-------------------------+
| version()               |
+-------------------------+
| 8.0.30-MatrixOne-v1.0.0 |
+-------------------------+
1 row in set (0.00 sec)

MySQL [(none)]> use system; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A

Database changed MySQL [system]> select version(); +-------------------------+ | version() | +-------------------------+ | 8.0.30-MatrixOne-v1.0.0 | +-------------------------+ 1 row in set (0.01 sec)

MySQL [system]> use mo_catalog; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A

Database changed MySQL [mo_catalog]> select version(); +-------------------------+ | version() | +-------------------------+ | 8.0.30-MatrixOne-v1.0.0 | +-------------------------+ 1 row in set (0.00 sec)

MySQL [mo_catalog]> use mysql Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A

Database changed MySQL [mysql]> select version(); +-------------------------+ | version() | +-------------------------+ | 8.0.30-MatrixOne-v1.0.0 | +-------------------------+ 1 row in set (0.00 sec)

MySQL [mysql]> create database test; Query OK, 1 row affected (0.01 sec)

MySQL [mysql]> use test; Database changed MySQL [test]> select version(); +-----------+ | version() | +-----------+ | 0.7 | +-----------+ 1 row in set (0.00 sec)


### Expected Behavior

Return the correct version in all cases

### Steps to Reproduce

```Markdown
See detail in `Actual Behavior`

Additional information

No response

YANGGMM commented 9 months ago

fixed

DanielZhangQD commented 9 months ago

Verified and passed with commit 10125790e

DanielZhangQD commented 9 months ago

升级到这个 Fix 前创建的 DB 依然有这个问题

YANGGMM commented 9 months ago

可以用 alter database dbname set mysql_compatibility_mode = '8.0.30-MatrixOne-v1.0.0'; 来升级 @DanielZhangQD

DanielZhangQD commented 8 months ago

新建 Database，use 后版本为 1.0.0

MySQL [test]> select version();
+-------------------------+
| version()               |
+-------------------------+
| 8.0.30-MatrixOne-v1.0.0 |
+-------------------------+
1 row in set (0.00 sec)

DanielZhangQD commented 8 months ago

另外需要提供如何修改之前已经创建的 DB version 的 SQL

sukki37 commented 2 months ago

still repro with v1.2.1