MyBatisCodeHelper-Pro icon indicating copy to clipboard operation
MyBatisCodeHelper-Pro copied to clipboard

插件column属性纠错有问题

Open CodeLunatic opened this issue 4 years ago • 4 comments

我的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

image

CodeLunatic avatar Oct 19 '21 04:10 CodeLunatic

ok 我看看 用的postgresql吧

gejun123456 avatar Oct 28 '21 04:10 gejun123456

这个是用的MySQL

CodeLunatic avatar Nov 10 '21 01:11 CodeLunatic

嗯 with语句会有这个问题,我想想

gejun123456 avatar Feb 17 '22 15:02 gejun123456

#767

gejun123456 avatar Jul 19 '22 04:07 gejun123456

已支持

gejun123456 avatar Aug 24 '22 01:08 gejun123456