Skip to content

[BUG] JSQLParser 5.4-SNAPSHOT : TRINO : WITH FUNCTION udf - unsupported #2306

@davyboyhayes

Description

@davyboyhayes

Failing SQL Feature:

  • Trino SQL allows you to specify a User Defined Function in the WITH block ahead of the SELECT/UPDATE/etc... statement, however this is currently unsupported in JSQLParser

SQL Example:

  • Simplified Query Example, focusing on the failing feature
WITH 
  FUNCTION hello(name varchar)
    RETURNS varchar
    RETURN format('Hello %s!', 'name'),
  FUNCTION bye(name varchar)
    RETURNS varchar
    RETURN format('Bye %s!', 'name')
SELECT hello('Finn') || ' and ' || bye('Joe');

Software Information:

  • JSqlParser version 5.4-SNAPSHOT
  • Trino

Tips:

There are examples of this SQL in https://trino.io/docs/current/sql/select.html#with-function-clause and https://trino.io/docs/current/udf/introduction.html

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions