??? <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打印出来执行有值,但只有这几个字段返回为空。改成静态语句则正常。
?