MyBatisCodeHelper-Pro
MyBatisCodeHelper-Pro copied to clipboard
插件column属性纠错有问题
我的SQL语句是这个样子的,其中包含了mark列,但是插件会提示没有mark列
WITH temp AS (
SELECT tci.category_id,
IFNULL(interested, 0) AS interested,
row_number() over ( PARTITION BY interested ORDER BY index_b DESC ) AS rn
FROM tbl_category_info tci
LEFT OUTER JOIN tbl_user_category_item tuc ON tci.category_id = tuc.category_id
AND user_id = #{userID}
)
SELECT tbi.book_id,
book_code,
book_name,
big_cover_url,
small_cover_url,
tbi.rand,
notes,
default_audio_name AS audio_name,
tbi.author_id,
tai.`name` AS author_name,
tai.short_name AS author_short_name,
tbi.added_time_millis AS q,
interested,
rn,
(CASE
WHEN interested
AND rn = 1 THEN
'I'
WHEN interested
AND rn = 2 THEN
'II'
WHEN interested
AND rn > 2 THEN
'III'
WHEN NOT interested THEN
'IV'
END) AS `mark`
FROM tbl_book_info tbi
INNER JOIN tbl_author_info tai ON tbi.author_id = tai.author_id
INNER JOIN tbl_book_category_item tbci ON tbi.book_id = tbci.book_id
INNER JOIN temp tuci ON tuci.category_id = tbci.category_id
INNER JOIN tbl_category_info tci ON tuci.category_id = tci.category_id

ok 我看看 用的postgresql吧
这个是用的MySQL
嗯 with语句会有这个问题,我想想
#767
已支持