【 使用环境 】 测试环境
【 OB or 其他组件 】OB
【 使用版本 】4.2.1.3
【问题描述】
使用navicat的mysql模式连接oceanbase,无法修改视图,如下:
在修改定义者时会报错,也无法直接导出视图,如下:
导出时提示没有权限,但是要修改定义者却报第一个截图的错.
【 使用环境 】 测试环境
【 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表不存在,是因为表不存在的原因吗
看看是不是语句问题呢,调整下试试看。