[
https://issues.apache.org/jira/browse/IGNITE-7496?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16340299#comment-16340299
]
Denis Magda commented on IGNITE-7496:
-------------------------------------
Reviewed {{CASEWHEN, CAST, CONVERT, TABLE}} functions, thanks.
[~pgarg] , we finished validating Ignite's compliance with SQL 99 *Core*
specification:
[https://ggsystems.atlassian.net/wiki/spaces/GG/pages/45093646/ANSI+SQL+99]
Please bring the table from "Ignite compliance to SQL:1999 (Core)" section here:
[https://dash.readme.io/project/apacheignite-sql/v2.3/docs/sql-conformance]
Apparently, there is no reason to copy "Standard", "Scope", "Support" columns
from the original wiki page.
If the table doesn't include functions mentioned by Sergey in "And for my mind,
next functions aren't applicable for Ignite" paragraph then we need to add them
as unsupported.
As for the optional part of the specification, we can say that the validation
is in progress.
> Update SQL Conformance Doc
> --------------------------
>
> Key: IGNITE-7496
> URL: https://issues.apache.org/jira/browse/IGNITE-7496
> Project: Ignite
> Issue Type: Bug
> Components: documentation
> Reporter: Sergey Puchnin
> Assignee: Denis Magda
> Priority: Minor
> Fix For: 2.4
>
>
> In a discussion on dev list
> http://apache-ignite-developers.2346864.n4.nabble.com/SparkDataFrame-Query-Optimization-Prototype-tt26249.html
> was noticed there are some gaps in SQL documentation.
> It's necessary to review it.
> I've added next system functions:
> CASEWHEN Function, CAST, CONVERT, TABLE
> And for my mind, next functions aren't applicable for Ignite:
> ARRAY_GET, ARRAY_LENGTH, ARRAY_CONTAINS, CSVREAD, CSVWRITE, DATABASE,
> DATABASE_PATH, DISK_SPACE_USED, FILE_READ, FILE_WRITE, LINK_SCHEMA,
> MEMORY_FREE, MEMORY_USED, LOCK_MODE, LOCK_TIMEOUT, READONLY, CURRVAL,
> AUTOCOMMIT, CANCEL_SESSION, IDENTITY, NEXTVAL, ROWNUM, SCHEMA,
> SCOPE_IDENTITY, SESSION_ID, SET, TRANSACTION_ID, TRUNCATE_VALUE, USER,
> H2VERSION
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
