[DEATURE] JSQLParser 4.6 : Doris : aes_decrypt(from_base64(entity), KEY chain.entity) , KEY chain.entity unsupported #2264

Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram

Failing SQL Feature:

• aes_decrypt(from_base64(entity), KEY chain.entity) , KEY chain.entity is a variable
• The syntax KEY xxx is not supported.

SQL Example:

• aes_decrypt(from_base64(entity), KEY chain.entity) , KEY chain.entity is a variable

    SELECT t1.entity, SUM(t2.balance) AS total_balance
    FROM (
        SELECT DISTINCT address, aes_decrypt(from_base64(entity), KEY chain.entity) AS entity
        FROM bch_entity
    ) t1
    JOIN bch_address_token_statis t2
    ON t1.address = t2.address
    GROUP BY t1.entity

Software Information:

• JSqlParser 4.6
• Doris