xml查询数据部分数据丢失

Question

java用xml写的sql,select后面的查询字段中，最后三个查询不出来，如果把最后三个放在前面，又可以查询出来了，但是还是最后三个字段查询不出来。

 SELECT
        period.period_code AS PeriodCode,
        period.period_go_time AS periodGoTime,
        (
        CASE
        period.period_status
        WHEN 1 THEN
        '销售'
        WHEN 2 THEN
        '暂停'
        WHEN 3 THEN
        '售罄'
        WHEN 4 THEN
        '截团'
        WHEN 5 THEN
        '出团'
        WHEN 6 THEN
        '回团'
        WHEN 7 THEN
        '取消'
        WHEN 8 THEN
        '恢复' ELSE '未知状态'
        END
        )  periodStatusName,
        (
        CASE
        line.line_type
        WHEN 1 THEN
        '散拼'
        WHEN 2 THEN
        '考察'
        WHEN 3 THEN
        '旅居'
        WHEN 4 THEN
        '度假'
        WHEN 5 THEN
        '私人定制'
        WHEN 6 THEN
        '周边游'
        WHEN 7 THEN
        '一日游'
        WHEN 8 THEN
        '邮轮'
        WHEN 9 THEN
        '大型活动' ELSE '未知类型'
        END
        )  lineTypeName,
        (
        SELECT
        GROUP_CONCAT( plac.personnel_name SEPARATOR ',' )
        FROM
        li_personnel_placement AS plac
        WHERE
        plac.personnel_type = 3
        AND period.id = plac.period_id
        <if test="request.guideName !=null and request.guideName != ''">
            AND plac.personnel_name like concat('%',#{request.guideName},'%')
        </if>
        )  guideName,
        (
        SELECT
        GROUP_CONCAT( plac.personnel_name SEPARATOR ',' )
        FROM
        li_personnel_placement AS plac
        WHERE
        plac.personnel_type = 2
        AND period.id = plac.period_id
        <!--领队-->
        <if test="request.leaderName !=null and request.leaderName != ''">
            AND plac.personnel_name like concat('%',#{request.leaderName},'%')
        </if>
        )  leader_name,
        (
        SELECT
        GROUP_CONCAT( placs.personnel_name SEPARATOR ',' )
        FROM
        li_personnel_placement AS placs
        WHERE
        placs.personnel_type = 1
        AND period.id = placs.period_id
        <!--保健医-->
        <if test="request.doctorName !=null and request.doctorName != ''">
            AND placs.personnel_name like concat('%',#{request.doctorName},'%')
        </if>
        )  doctorName,
        period.period_stock  periodStock,
        period.period_sell_stock  periodSellStock,
        period.period_surplus_stock  periodSurplusStock,
        period.period_code  periodCode,
        period.period_go_time  periodGoTime,
        period.period_back_time  periodBackTime,
        period.product_name  productName,
        period.tour_product_research_name  tourProductResearchName,
        period.period_minimum_clustering  periodMinimumClustering,
        line.line_name  lineName,
        product.supplier_company_name  supplierName
 
        FROM
        li_regimental_period AS period
        LEFT JOIN li_line_info line ON period.period_info_id = line.id
        LEFT JOIN li_tour_product_info product ON period.period_product_id = product.id
        WHERE
        1 = 1
        <!--团号-->
        <if test="request.periodCode !=null and request.periodCode != ''">
            AND period.period_code like concat('%',#{request.periodCode},'%')
        </if>
        <!--产品名称-->
        <if test="request.tourProductName !=null and request.tourProductName != ''">
            AND period.product_name like concat('%',#{request.tourProductName},'%')
        </if>
        <!--是否成团 ：是-->
        <if test="request.isRegimental !=null and request.isRegimental == 1">
            AND period.period_sell_stock &gt;= period.period_minimum_clustering
        </if>
        <!--是否成团：否-->
        <if test="request.isRegimental !=null and request.isRegimental == 0">
            AND period.period_sell_stock &lt;= period.period_minimum_clustering
        </if>
        <!--线路类型-->
        <if test="request.lineType !=null">
            AND period.line_type == #{request.LineType}
        </if>
        <!--出团日期A-->
        <if test="request.periodGoTimeA != null and request.periodGoTimeA !='' ">
            and period.period_go_time &gt;= #{request.periodGoTimeA}
        </if>
        <!--出团日期B-->
        <if test="request.periodGoTimeB != null and request.periodGoTimeB !='' ">
            and period.period_go_time &lt;= #{request.periodGoTimeB}
        </if>
        <!--回团日期A-->
        <if test="request.periodBackTimeA != null and request.periodBackTimeA !='' ">
            and period.period_back_time &gt;= #{request.periodBackTimeA}
        </if>
        <!--回团日期B-->
        <if test="request.periodBackTimeB != null and request.periodBackTimeB !='' ">
            and period.period_back_time &lt;= #{request.periodBackTimeB}
        </if>
    </select>

比如现在在最后的是：periodMinimumClustering、lineName、supplierName，那么这三个就查不出来，不是没数据就是如果把他们三个放到前面就能查出来，这个sql在数据库跑过，完全可以查询出来，在java跑的时候生成的sql，在数据库跑了一遍也可以查询出来
以下是Java跑完代码生成的sql：
SELECT period.period_code AS PeriodCode, period.period_go_time AS periodGoTime, ( CASE period.period_status WHEN 1 THEN '销售' WHEN 2 THEN '暂停' WHEN 3 THEN '售罄' WHEN 4 THEN '截团' WHEN 5 THEN '出团' WHEN 6 THEN '回团' WHEN 7 THEN '取消' WHEN 8 THEN '恢复' ELSE '未知状态' END ) periodStatusName, ( CASE line.line_type WHEN 1 THEN '散拼' WHEN 2 THEN '考察' WHEN 3 THEN '旅居' WHEN 4 THEN '度假' WHEN 5 THEN '私人定制' WHEN 6 THEN '周边游' WHEN 7 THEN '一日游' WHEN 8 THEN '邮轮' WHEN 9 THEN '大型活动' ELSE '未知类型' END ) lineTypeName, ( SELECT GROUP_CONCAT( plac.personnel_name SEPARATOR ',' ) FROM li_personnel_placement AS plac WHERE plac.personnel_type = 3 AND period.id = plac.period_id ) guideName, ( SELECT GROUP_CONCAT( plac.personnel_name SEPARATOR ',' ) FROM li_personnel_placement AS plac WHERE plac.personnel_type = 2 AND period.id = plac.period_id ) leader_name, ( SELECT GROUP_CONCAT( placs.personnel_name SEPARATOR ',' ) FROM li_personnel_placement AS placs WHERE placs.personnel_type = 1 AND period.id = placs.period_id ) doctorName, period.period_stock periodStock, period.period_sell_stock periodSellStock, period.period_surplus_stock periodSurplusStock, period.period_code periodCode, period.period_go_time periodGoTime, period.period_back_time periodBackTime, period.product_name productName, period.tour_product_research_name tourProductResearchName, period.period_minimum_clustering periodMinimumClustering, line.line_name lineName, product.supplier_company_name supplierName FROM li_regimental_period AS period LEFT JOIN li_line_info line ON period.period_info_id = line.id LEFT JOIN li_tour_product_info product ON period.period_product_id = product.id WHERE 1 = 1 AND period.period_code like concat('%','Group-231100303','%') LIMIT 10

Answer 1

sql没问题，那么有没有可能是你的resultMap集合的问题？