我改了几个Mapper，使用pg，首页不报错了

[douglaskiller]

"http://mybatis.org/dtd/mybatis-3-mapper.dtd" >

<select id="selectMessagePage" resultType="top.continew.admin.system.model.resp.message.MessageResp">
    SELECT
        t1.id,
        t1.title,
        t1.type,
        t1.path,
        t1.scope,
        t1.users,
        t1.create_time,
        t2.read_time IS NOT NULL AS isRead,
        t2.read_time AS readTime
    FROM sys_message AS t1
        LEFT JOIN sys_message_log AS t2 ON t2.message_id = t1.id
    <where>
        <if test="query.userId != null">
            (t1.scope = 1 OR (t1.scope = 2 AND (t1.users->>0)::text = CAST(#{query.userId} AS TEXT)))
        </if>
        <if test="query.title != null and query.title != ''">
            AND t1.title LIKE CONCAT('%', #{query.title}, '%')
        </if>
        <if test="query.type != null and query.type != ''">
            AND t1.type = #{query.type}
        </if>
        <if test="query.isRead != null">
            AND t2.read_time IS <if test="query.isRead">NOT</if> NULL
        </if>
    </where>
    ORDER BY t1.create_time DESC
</select>

<select id="selectMessageById" resultType="top.continew.admin.system.model.resp.message.MessageDetailResp">
    SELECT
        t1.id,
        t1.title,
        t1.content,
        t1.type,
        t1.path,
        t1.scope,
        t1.users,
        t1.create_time,
        t2.read_time IS NOT NULL AS isRead,
        t2.read_time AS readTime
    FROM sys_message AS t1
        LEFT JOIN sys_message_log AS t2 ON t2.message_id = t1.id
    WHERE t1.id = #{id}
</select>

<select id="selectUnreadListByUserId" resultType="top.continew.admin.system.model.entity.MessageDO">
    SELECT
        t1.*
    FROM sys_message AS t1
        LEFT JOIN sys_message_log AS t2 ON t2.message_id = t1.id
    WHERE (t1.scope = 1 OR (t1.scope = 2 AND t1.users::jsonb @> CONCAT('"', #{userId}, '"')::jsonb))
    AND t2.read_time IS NULL
</select>

<select id="selectUnreadCountByUserIdAndType" resultType="java.lang.Long">
    SELECT
        COUNT(1)
    FROM sys_message AS t1
        LEFT JOIN sys_message_log AS t2 ON t2.message_id = t1.id
    WHERE (t1.scope = 1 OR (t1.scope = 2 AND t1.users::jsonb @> CONCAT('"', #{userId}, '"')::jsonb))
    AND t2.read_time IS NULL
      <if test="type != null">
        AND t1.type = #{type}
      </if>
</select>

<resultMap id="notice" type="top.continew.admin.system.model.resp.notice.NoticeResp">
    <id property="id" column="id" />
    <result property="noticeMethods" column="notice_methods" typeHandler="com.baomidou.mybatisplus.extension.handlers.JacksonTypeHandler" />
</resultMap>

<select id="selectNoticePage" resultMap="notice">
    SELECT
        t1.id,
        t1.title,
        t1.type,
        t1.notice_scope,
        t1.notice_methods,
        t1.is_timing,
        t1.publish_time,
        t1.is_top,
        t1.status,
        t1.create_user,
        t2.read_time IS NOT NULL AS isRead
    FROM sys_notice AS t1
    LEFT JOIN sys_notice_log AS t2 ON t2.notice_id = t1.id
    <where>
        <if test="query.userId != null">
            (t1.notice_scope = 1 OR (t1.notice_scope = 2 AND t1.notice_users::jsonb @> CONCAT('"', #{query.userId}, '"')::jsonb))
        </if>
        <if test="query.title != null and query.title != ''">
            AND t1.title LIKE '%' || #{query.title} || '%'
        </if>
        <if test="query.type != null and query.type != ''">
            AND t1.type = #{query.type}
        </if>
    </where>
    <if test="query.userId != null">
        ORDER BY t1.is_top DESC, t1.publish_time DESC
    </if>
    <if test="query.userId == null">
        ORDER BY t1.create_time DESC
    </if>
</select>

<select id="selectUnreadIdsByUserId" resultType="java.lang.Long">
    SELECT
        t1.id
    FROM sys_notice AS t1
    LEFT JOIN sys_notice_log AS t2 ON t2.notice_id = t1.id
    WHERE (t1.notice_scope = 1 OR (t1.notice_scope = 2 AND t1.notice_users::jsonb @> CONCAT('"', #{userId}, '"')::jsonb))
    <if test="noticeMethod != null">
        AND t1.notice_methods::jsonb @> CAST(#{noticeMethod} AS TEXT)::jsonb
    </if>
    AND t2.read_time IS NULL
</select>

<select id="selectDashboardList"
        resultType="top.continew.admin.system.model.resp.dashboard.DashboardNoticeResp">
    SELECT
    id, title, type, is_top
    FROM sys_notice
    WHERE status = 3
    <if test="userId != null">
        AND (notice_scope = 1 OR (notice_scope = 2 AND notice_users::jsonb @> CONCAT('"', #{userId}, '"')::jsonb))
    </if>
    ORDER BY is_top DESC, publish_time DESC
    LIMIT 5
</select>

[Charles7c]

OK，我在常见问题里添加下这个 discussion 链接。