为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。
【DM版本】:dm8
【操作系统】：win10
【CPU】:4
【问题描述】*：UNION all 后字段类型变了
CREATE or REPLACE VIEW ECIS_DEV.v_hosp_dept AS
SELECT
b.ID AS hospital_id,
b.ORG_NAME AS hospital_name,
b.DELETE_FLAG AS hospital_delete_flag,
b.SORT_NO AS hospital_sort_no,
b.ORG_CODE AS org_code,
b.HOSP_CODE AS hosp_code,
NULL AS hospital_area_id,
NULL AS hospital_area_name,
'0' AS hospital_area_delete_flag,
0 AS hospital_area_sort_no,
a.ID AS ID,
a.ORG_ID AS ORG_ID,
a.PARENT_ID AS PARENT_ID,
a.DEPT_CODE AS DEPT_CODE,
a.DEPT_NAME AS DEPT_NAME,
a.BUSINESS_TYPE AS BUSINESS_TYPE,
a.DEPT_HEAD AS DEPT_HEAD,
a.DEPT_HEAD_PHONE AS DEPT_HEAD_PHONE,
a.STANDARD_DEPT_ID AS STANDARD_DEPT_ID,
a.ADDR_DETAIL AS ADDR_DETAIL,
a.SUMMARY AS SUMMARY,
a.IMAGE_URL AS IMAGE_URL,
a.DELETE_FLAG AS DELETE_FLAG,
a.CREATE_BY AS CREATE_BY,
a.CREATE_TIME AS CREATE_TIME,
a.UPDATE_BY AS UPDATE_BY,
a.UPDATE_TIME AS UPDATE_TIME,
a.BOOKING_REGISTER AS BOOKING_REGISTER,
a.HIS_ID AS HIS_ID,
a.HIS_NAME AS HIS_NAME,
a.EMR_ID AS EMR_ID,
a.EMR_NAME AS EMR_NAME,
a.LIS_ID AS LIS_ID,
a.LIS_NAME AS LIS_NAME,
a.RIS_ID AS RIS_ID,
a.RIS_NAME AS RIS_NAME,
a.SORT_NO AS SORT_NO,
a.PY_CODE AS PY_CODE,
a.MIP_DEPT_ID AS MIP_DEPT_ID,
a.OPEN_SERVICE AS OPEN_SERVICE
FROM ecis_dev.bsf_department a
INNER JOIN ecis_dev.bsf_organization b
on a.ORG_ID = b.ID
AND b.MANAGE_TYPE IN(1,2)

   UNION all
   
   SELECT
                                               c.ID                AS hospital_id,
                                               c.ORG_NAME          AS hospital_name,
                                               c.DELETE_FLAG       AS hospital_delete_flag,
                                               c.SORT_NO           AS hospital_sort_no,
                                               b.ID                AS hospital_area_id,
                                               b.ORG_NAME          AS hospital_area_name,
                                               b.DELETE_FLAG       AS hospital_area_delete_flag,
                                               b.SORT_NO           AS hospital_area_sort_no,
                                               b.ORG_CODE          AS org_code,
                                               b.HOSP_CODE         AS hosp_code,
                                               a.ID                AS ID,
                                               a.ORG_ID            AS ORG_ID,
                                               a.PARENT_ID         AS PARENT_ID,
                                               a.DEPT_CODE         AS DEPT_CODE,
                                               a.DEPT_NAME         AS DEPT_NAME,
                                               a.BUSINESS_TYPE     AS BUSINESS_TYPE,
                                               a.DEPT_HEAD         AS DEPT_HEAD,
                                               a.DEPT_HEAD_PHONE   AS DEPT_HEAD_PHONE,
                                               a.STANDARD_DEPT_ID  AS STANDARD_DEPT_ID,
                                               a.ADDR_DETAIL       AS ADDR_DETAIL,
                                               a.SUMMARY           AS SUMMARY,
                                               a.IMAGE_URL         AS IMAGE_URL,
                                               a.DELETE_FLAG       AS DELETE_FLAG,
                                               a.CREATE_BY         AS CREATE_BY,
                                               a.CREATE_TIME       AS CREATE_TIME,
                                               a.UPDATE_BY         AS UPDATE_BY,
                                               a.UPDATE_TIME       AS UPDATE_TIME,
                                               a.BOOKING_REGISTER  AS BOOKING_REGISTER,
                                               a.HIS_ID            AS HIS_ID,
                                               a.HIS_NAME          AS HIS_NAME,
                                               a.EMR_ID            AS EMR_ID,
                                               a.EMR_NAME          AS EMR_NAME,
                                               a.LIS_ID            AS LIS_ID,
                                               a.LIS_NAME          AS LIS_NAME,
                                               a.RIS_ID            AS RIS_ID,
                                               a.RIS_NAME          AS RIS_NAME,
                                               a.SORT_NO           AS SORT_NO,
                                               a.PY_CODE           AS PY_CODE,
                                               a.MIP_DEPT_ID       AS MIP_DEPT_ID,
                                               a.OPEN_SERVICE      AS OPEN_SERVICE
                                             FROM ecis_dev.bsf_department a
                                                 INNER JOIN ecis_dev.bsf_organization b
                                                 on a.ORG_ID = b.ID and b.MANAGE_TYPE = '3'
                                                INNER JOIN ecis_dev.bsf_organization c
                           
                                                 on b.PARENT_ID = c.ID

上面sql 执行后视图创建成功 org_code 变成了bigint类 按到是varchar类型