注册

迁移存储过程出错

Solreal 2023/06/26 918 1

有大佬知道哪里出错了吗

image.png

BEGIN

	CREATE TEMPORARY TABLE IF NOT EXISTS  jszxseal
       (   apv_code   VARCHAR(255) ,
           apv_title  VARCHAR(255) ,
					 create_name  varchar(255) ,
					 create_depart  varchar(255) ,
					 update_time   date  DEFAULT NULL,
           apv_user_name  VARCHAR(255) ,
           title        VARCHAR(255) 
       );
BEGIN
 
      insert into jszxseal(apv_code,apv_title,create_name,create_depart,update_time,apv_user_name,title) 
SELECT a.apvCode AS apv_code,a.apvTitle AS apv_title,a.createName AS create_name,a.createDpart AS create_depart,a.updateTime AS update_time,a.apvUserName AS apv_user_name,b.title AS title
 FROM (SELECT a.id AS id,a.apv_code AS apvCode,a.apv_title AS apvTitle,a.create_name AS createName,a.create_dpart AS createDpart,a.update_time AS updateTime,b.apv_user_name AS apvUserName FROM (SELECT id,apv_code,apv_title,create_name,create_dpart,DATE_FORMAT(update_time,'%Y-%m-%d') AS update_time FROM oa_apv_main WHERE apv_code LIKE 'GCYY%' AND apv_status=3 ) a 
	     LEFT JOIN (SELECT GROUP_CONCAT(apv_user_name  ORDER BY step_num ASC SEPARATOR '->') AS apv_user_name,apv_code FROM oa_apv_step where apv_code LIKE 'GCYY%' GROUP BY apv_code) b
	      ON a.apv_code=b.apv_code  ORDER BY apvCode ASC) a LEFT JOIN (SELECT a.apv_main_id AS mainId , b.title AS title  FROM (SELECT * FROM oa_apv_form_seal WHERE seal_name IN ('1465164880667316225','1465165166689488897','1465165488786870273','1465165849870307329','1465166105517330433','1465166318520864769','1465166545080389634','1465166861439963137','1465167073688522753','1465852427647156225','1498938936889450497') ) a LEFT JOIN (SELECT * FROM oa_apv_flow_clause WHERE dep_id LIKE '402880e447e9a9570147e9b677320003' AND title LIKE '%章%' ) b ON b.id=a.seal_name) b ON a.id=b.mainId;
    SELECT * FROM jszxseal;
   end;
	truncate TABLE jszxseal;
END

回答 0
暂无回答
扫一扫
联系客服