ignite-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Denis Magda (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (IGNITE-7496) Update SQL Conformance Doc
Date Thu, 25 Jan 2018 23:39:00 GMT

    [ 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)

Mime
View raw message