mysql5.7不能使用 with

zhanghua

2023-03-10 9bfd0f697d407902d9d80d95e5c23943a556b79f

mysql5.7不能使用 with

 ycl-common/src/main/java/com/ycl/service/oss/impl/OssServiceImpl.java

@@ -89,9 +89,11 @@
            // 这里设置图片有效时间 我设置了30年
            Date expiration = new Date(System.currentTimeMillis() + 946080000 * 1000);
            String url = ossClient.generatePresignedUrl(bucketName, fileName, expiration).toString();
            // System.out.println("oss成功：" + url);
            return url;
        } catch (Exception e) {
            e.printStackTrace();
            System.out.println("oss异常：" + e.getMessage());
            // e.printStackTrace();
            return null;
        }
    }

 ycl-platform/src/main/java/com/ycl/service/video/impl/VideoAlarmReportServiceImpl.java

@@ -145,7 +145,6 @@
//                按照Base64编码解析数据
                byte[] data = DatatypeConverter.parseBase64Binary(alarmParam.getPicData());
                InputStream inputStream = new ByteArrayInputStream(data);

                try {
//                    如果List<AlarmDataParam>合理
                    if (alarmParam.getAlarmData()!=null && alarmParam.getAlarmData().size()!=0) {

 ycl-platform/src/main/resources/mapper/caseHandler/DisposeRecordMapper.xml

@@ -24,7 +24,7 @@
    </sql>

    <select id="selectMyBackList" resultType="com.ycl.vo.MyBacklogVO">
        with tmp as(
        select distinct * from (
        SELECT
        t3.event_source,
        t3.category,
@@ -63,7 +63,7 @@
                and t3.`code` LIKE CONCAT('%',#{code},'%')
            </if>
        </where>
        )
        select distinct * from tmp order by create_time
        ) as t
         order by create_time
    </select>
</mapper>