[jira] [Updated] (IGNITE-29023) SQL Calcite: Enable CROSS APPLY and OUTER APPLY

["Kirill Tkalenko (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IGNITE-29023?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kirill Tkalenko updated IGNITE-29023:
-------------------------------------
    Description: 
Сalcite engine rejects {{CROSS APPLY}} and {{{}OUTER APPLY{}}}:
{noformat}
APPLY operator is not allowed under the current SQL conformance level{noformat}
Example:
{noformat}
SELECT * FROM Person p CROSS APPLY (SELECT p.id) v;{noformat}
Calcite supports these operators, but *{{IgniteSqlConformance}}* does not enable them.

  was:
Сalcite engine rejects {{CROSS APPLY}} and {{{}OUTER APPLY{}}}:

{{}}
{noformat}
APPLY operator is not allowed under the current SQL conformance level{noformat}
{{}}

Example:

{{}}
{noformat}
SELECT * FROM Person p CROSS APPLY (SELECT p.id) v;{noformat}
{{}}

Calcite supports these operators, but *{{IgniteSqlConformance}}* does not enable them.


> SQL Calcite: Enable CROSS APPLY and OUTER APPLY
> -----------------------------------------------
>
>                 Key: IGNITE-29023
>                 URL: https://issues.apache.org/jira/browse/IGNITE-29023
>             Project: Ignite
>          Issue Type: Improvement
>            Reporter: Kirill Tkalenko
>            Assignee: Kirill Tkalenko
>            Priority: Major
>              Labels: ignite-2
>
> Сalcite engine rejects {{CROSS APPLY}} and {{{}OUTER APPLY{}}}:
> {noformat}
> APPLY operator is not allowed under the current SQL conformance level{noformat}
> Example:
> {noformat}
> SELECT * FROM Person p CROSS APPLY (SELECT p.id) v;{noformat}
> Calcite supports these operators, but *{{IgniteSqlConformance}}* does not enable them.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)