oceanbase无法使用navicate修改视图

【 使用环境 】 测试环境
【 OB or 其他组件 】OB
【 使用版本 】4.2.1.3
【问题描述】
使用navicat的mysql模式连接oceanbase,无法修改视图,如下:


在修改定义者时会报错,也无法直接导出视图,如下:

导出时提示没有权限,但是要修改定义者却报第一个截图的错.

黑屏修改试过吗?黑屏修改是否报错了

这也是报这个语法错误

把操作语句发出来吧

alter DEFINER=apaas_business_crrc_dc@% SQL SECURITY DEFINER VIEW apaas_business_crrc_dc.v_bid_submit_list as select a.ID_ AS id_,a.BILL_STATE_ AS a_bill_state_,a.BILL_NO_ AS a_bill_no_,b.BILL_NO_ AS b_bill_no_,b.PROJECT_NAME_ AS project_name_,a.VENDOR_CODE_ AS vendor_code_,a.VENDOR_NAME_ AS vendor_name_,b.BID_TYPE_CODE_ AS bid_type_code_,b.PURCHASE_ORG_NAME_ AS purchase_group_name_,b.MATERIAL_GROUP_NAME_ AS material_group_name_,b.BILL_STATE_ AS b_bill_state_,b.BID_START_DATE_ AS bid_start_date_,a.END_DATE_ AS end_date_,a.PLAN_OPEN_DATE_ AS plan_open_date_,a.CREATE_BY_ AS create_by_,a.CREATE_TIME_ AS create_time_ from (apaas_business_crrc_dc.t_bd_bid_submit a left join apaas_business_crrc_dc.t_bd_bid b on (b.ID_ = a.BID_ID_));

alter DEFINER=apaas_business_crrc_dc SQL SECURITY DEFINER VIEW apaas_business_crrc_dc.v_bid_submit_list as select a.ID_ AS id_,a.BILL_STATE_ AS a_bill_state_,a.BILL_NO_ AS a_bill_no_,b.BILL_NO_ AS b_bill_no_,b.PROJECT_NAME_ AS project_name_,a.VENDOR_CODE_ AS vendor_code_,a.VENDOR_NAME_ AS vendor_name_,b.BID_TYPE_CODE_ AS bid_type_code_,b.PURCHASE_ORG_NAME_ AS purchase_group_name_,b.MATERIAL_GROUP_NAME_ AS material_group_name_,b.BILL_STATE_ AS b_bill_state_,b.BID_START_DATE_ AS bid_start_date_,a.END_DATE_ AS end_date_,a.PLAN_OPEN_DATE_ AS plan_open_date_,a.CREATE_BY_ AS create_by_,a.CREATE_TIME_ AS create_time_ from (apaas_business_crrc_dc.t_bd_bid_submit a left join apaas_business_crrc_dc.t_bd_bid b on (b.ID_ = a.BID_ID_)); 看下是什么情况。

这个会提示t_bd_bid表不存在,是因为表不存在的原因吗

看看是不是语句问题呢,调整下试试看。