[Enhancement]: 确认及更新MO的各类基础限制

[dengn]

Is there an existing issue about this enhancement?

• I have checked the existing issues.

Describe the enhancement.

https://docs.matrixorigin.cn/dev/MatrixOne/Develop/schema-design/overview/#_3

[lacrimosaprinz]

与潇哥确认了一下，待悲观事务稳定后再测试

[dengn]

这部分内容不明确，但是实际测试发现肯定不是现在写的这个照着mysql做的值，暂时先去掉。

mysql> create database aaaaaaaaaaaabbbbbbbbbbbbbbcccccccccccccdddddddddddddddddddddddeeeeeeeeeeeeeeefffffffffffffffffffffggggggggggggg;
Query OK, 1 row affected (0.20 sec)

mysql> show databases;
+-----------------------------------------------------------------------------------------------------------------+
| Database                                                                                                        |
+-----------------------------------------------------------------------------------------------------------------+
| mo_catalog                                                                                                      |
| aaaaaaaaaaaabbbbbbbbbbbbbbcccccccccccccdddddddddddddddddddddddeeeeeeeeeeeeeeefffffffffffffffffffffggggggggggggg |
| system                                                                                                          |
| system_metrics                                                                                                  |
| information_schema                                                                                              |
| mysql                                                                                                           |
+-----------------------------------------------------------------------------------------------------------------+
6 rows in set (0.52 sec)

mysql> use aaaaaaaaaaaabbbbbbbbbbbbbbcccccccccccccdddddddddddddddddddddddeeeeeeeeeeeeeeefffffffffffffffffffffggggggggggggg;
Database changed
mysql> create table aaaaaaaaaaaabbbbbbbbbbbbbbcccccccccccccdddddddddddddddddddddddeeeeeeeeeeeeeeefffffffffffffffffffffggggggggggggg (a int);
Query OK, 0 rows affected (0.09 sec)

mysql> show tables;
+---------------------------------------------------------------------------------------------------------------------------+
| Tables_in_aaaaaaaaaaaabbbbbbbbbbbbbbcccccccccccccdddddddddddddddddddddddeeeeeeeeeeeeeeefffffffffffffffffffffggggggggggggg |
+---------------------------------------------------------------------------------------------------------------------------+
| aaaaaaaaaaaabbbbbbbbbbbbbbcccccccccccccdddddddddddddddddddddddeeeeeeeeeeeeeeefffffffffffffffffffffggggggggggggg           |
+---------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.20 sec)

mysql> create table t1(aaaaaaaaaaaabbbbbbbbbbbbbbcccccccccccccdddddddddddddddddddddddeeeeeeeeeeeeeeefffffffffffffffffffffggggggggggggg int, aaaaaaaaaaaabbbbbbbbbbbbbbcccccccccccccdddddddddddddddddddddddeeeeeeeeeeeeeeefffffffffffffffffffffgggggggggggggaaaaaaaaaaaabbbbbbbbbbbbbbcccccccccccccdddddddddddddddddddddddeeeeeeeeeeeeeeefffffffffffffffffffffggggggggggggg datetime);
Query OK, 0 rows affected (0.21 sec)

mysql> show tables;
+---------------------------------------------------------------------------------------------------------------------------+
| Tables_in_aaaaaaaaaaaabbbbbbbbbbbbbbcccccccccccccdddddddddddddddddddddddeeeeeeeeeeeeeeefffffffffffffffffffffggggggggggggg |
+---------------------------------------------------------------------------------------------------------------------------+
| aaaaaaaaaaaabbbbbbbbbbbbbbcccccccccccccdddddddddddddddddddddddeeeeeeeeeeeeeeefffffffffffffffffffffggggggggggggg           |
| t1                                                                                                                        |
+---------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.08 sec)

mysql> show create table t1;
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                                                                                                                                                                                                                                                                                                                                     |
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| t1    | CREATE TABLE `t1` (
`aaaaaaaaaaaabbbbbbbbbbbbbbcccccccccccccdddddddddddddddddddddddeeeeeeeeeeeeeeefffffffffffffffffffffggggggggggggg` INT DEFAULT NULL,
`aaaaaaaaaaaabbbbbbbbbbbbbbcccccccccccccdddddddddddddddddddddddeeeeeeeeeeeeeeefffffffffffffffffffffgggggggggggggaaaaaaaaaaaabbbbbbbbbbbbbbcccccccccccccdddddddddddddddddddddddeeeeeeeeeeeeeeefffffffffffffffffffffggggggggggggg` DATETIME DEFAULT NULL
) |
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.11 sec)

[lacrimosaprinz]

matrixorigin/matrixorigin.io#563
#798
matrixorigin/moc-docs#36