【 使用环境 】测试环境
【 OB or 其他组件 】oms
【 使用版本 】 oms_4.1.0
【问题描述】官网文档说可以使用mysql库作为属性库。 但在oms初始化时，报很多sql错误
#mysql alter语句不支持before指定字段位置。 只支持first、after
mysql -h’192.168.49.197’ -P3370 -u ‘root’ --password=‘root123456’ -f -D ‘oms_ce_rm’ < /root/omsflow/meta_init/drc_rm_schema.sql
ERROR 1064 (42000) at line 1897: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BEFORE grade_id’ at line 1
ERROR 1064 (42000) at line 1898: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'BEFORE grade_id’ at line 1
#默认mysql表引擎为innodb sql文件中定义编码为utf8mb4. 修改innodb_large_prefix也未能解决
mysql -h’192.168.49.197’ -P3370 -u ‘root’ --password=‘root123456’ -f -D ‘oms_ce_cm’ < /root/omsflow/meta_init/drc_cm_schema.sql
ERROR 1071 (42000) at line 1635: Specified key was too long; max key length is 3072 bytes
#1733行oms_project_module_graph建表时已经有project_type字段，1906又给此表添加project_type字段
mysql -h’192.168.49.196’ -P2881 -u ‘root@sys’ --password=‘root’ -f -D ‘oms_ce_rm’ < /root/omsflow/meta_init/drc_rm_schema.sql
ERROR 1060 (42S21) at line 1906: Duplicate column name ‘project_type’
【复现路径】问题出现前后相关操作
【问题现象及影响】
【附件】