Skip to content

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

@wcxcw

Description

@wcxcw

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

Metadata

Metadata

Assignees

No one assigned

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions