mapper文件中使用注解开发SQL,无法识别<script>等标签

问题遇到的现象和发生背景
问题相关代码,请勿粘贴截图
@Select("<script>"
            + "SELECT "
                + "id,"
                + "property_name,"
                + "property_desc,"
                + "input_type,"
                + "input_values,"
                + "gmt_create,"
                + "gmt_modified "
            + "FROM commodity_property a, "
            + "("
            + "SELECT id FROM commodity_property "
            + "<if test='propertyName != null'> "
                + "WHERE property_name like '#{propertyName}%' "
            + "</if>"
            + "LIMIT #{offset}, #{size}) b "
            + "WHERE a.id = b.id"
            + "</script>")
    @Results({
        @Result(column = "id", property = "id", id = true),
        @Result(column = "property_name", property = "propertyName"),
        @Result(column = "property_desc", property = "propertyDesc"),
        @Result(column = "input_type", property = "inputType"),
        @Result(column = "input_values", property = "inputValues"),
        @Result(column = "gmt_create", property = "gmtCreate"),
        @Result(column = "gmt_modified", property = "gmtModified")
    })
    List<PropertyDO> listPropertiesByPage(PropertyQuery propertyQuery);
运行结果及报错内容

img

我的解答思路和尝试过的方法
我想要达到的结果

这个文件中没记错的话,不支持script标签吧

img

应该是支持的,你可以搜一下。如果需要做参数的if判断需要用到的时候需要用