This is an automated email from the ASF dual-hosted git repository. mblow pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/asterixdb.git
commit 69174eb312f9f2566207a6c088f9542b6cebf96a Author: Dmitry Lychagin <[email protected]> AuthorDate: Wed Jan 27 11:15:33 2021 -0800 [NO ISSUE][DOC] Cleanup SQL compatibility list - user model changes: no - storage format changes: no - interface changes: no Details: - Remove RIGHT OUTER JOIN and COALESCE function from the list of SQL incompatibilities because they have been implemented Change-Id: I0f8df90b8eaf588b8e0d6bd620e650b7da72b94f Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/9764 Integration-Tests: Jenkins <[email protected]> Tested-by: Jenkins <[email protected]> Reviewed-by: Dmitry Lychagin <[email protected]> Reviewed-by: Ali Alsuliman <[email protected]> --- asterixdb/asterix-doc/src/main/markdown/sqlpp/6_sql_diff.md | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-) diff --git a/asterixdb/asterix-doc/src/main/markdown/sqlpp/6_sql_diff.md b/asterixdb/asterix-doc/src/main/markdown/sqlpp/6_sql_diff.md index 7956f07..d5bc3cf 100644 --- a/asterixdb/asterix-doc/src/main/markdown/sqlpp/6_sql_diff.md +++ b/asterixdb/asterix-doc/src/main/markdown/sqlpp/6_sql_diff.md @@ -42,14 +42,12 @@ The following matrix is a quick "SQL-92 compatibility cheat sheet" for SQL++. The following SQL-92 features are not implemented yet. However, SQL++ does not conflict with these features: * CROSS JOIN, NATURAL JOIN, UNION JOIN - * RIGHT and FULL OUTER JOIN + * FULL OUTER JOIN * INTERSECT, EXCEPT, UNION with set semantics * CAST expression - * COALESCE expression * ALL and SOME predicates for linking to subqueries * UNIQUE predicate (tests a collection for duplicates) * MATCH predicate (tests for referential integrity) * Row and Table constructors * Preserved order for expressions in a SELECT list -
