`

ibatis动态sql的一个bug??

阅读更多

    <select id="getMatchList" parameterClass="page" resultClass="match">
        select
          m.id,
          a.title 'asset.title',
          m.video_uuid videoUuid,
          m.meta_uuid metaUuid,
          m.view_count viewCount,
          m.status,
<!--               ci.claim_status as claimStatus,
              ci.claim_date as claimDate,        -->  
         <isEqual property="criteria.claimable" compareValue="false">

              ci.claim_status  claimStatus,
              ci.claim_date  claimDate,
   
         </isEqual> 
          m.clip_size clipSize,
          m.clip_url clipUrl,
          m.clip_title clipTitle,
          m.season_number seasonNumber,
          m.episode_number episodeNumber,
          m.download_url downloadUrl,
          m.clip_offset clipOffset,
          m.meta_offset metaOffset,

..................

.........

 

字段写在动态语句中,发现sql打印出来执行有值,但只有这几个字段返回为空。改成静态语句则正常。

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics