使用sql创建好的视图,在桌面版odc中右键点击查看视图数据,提示如下,请问怎么解决?
请求失败
ErrorCode = 1449, SQLState = HY000, Details = User not exist
使用sql创建好的视图,在桌面版odc中右键点击查看视图数据,提示如下,请问怎么解决?
请求失败
ErrorCode = 1449, SQLState = HY000, Details = User not exist
麻烦提供下创建视图的语句 OB的版本信息
CREATE VIEW ums_audio_video_view AS select a.id AS id,a.user_id AS user_id,a.old_id AS old_id,a.user_no AS user_no,a.court_no AS court_no,a.c_file_name AS c_file_name,a.c_file_path AS c_file_path,a.c_description AS c_description,a.sort_no AS sort_no,a.court_code AS court_code,code_text(a.court_no,1) AS court_no_text from ums_audio_video a;
这是从mysql的视图导出来的sql,直接拿来执行的,ob装的5.7.25-OceanBase_CE-v4.3.0.1 odc用的4.2.4_bp2-win64
收到,正在和相关同学确认。
是code_text这个函数的DEFINER设置错了造成的,重新创建这个函数后问题解决了