Iurii Gerzhedovich created IGNITE-21915:
-------------------------------------------
Summary: Sql. Add test coverage for SQL-standard features. Phase 1
Key: IGNITE-21915
URL: https://issues.apache.org/jira/browse/IGNITE-21915
Project: Ignite
Issue Type: Epic
Components: sql
Reporter: Iurii Gerzhedovich
We have a set of SQL features that are not covered by tests at all.
Let’s improve that.
List of features that need to be covered:
|Feature type|Feature id|Feature Name|sub feature id|sub feature name|
|Mandatory|E021|Character string types|1|CHARACTER data type|
|Mandatory|E031|Identifiers|3|Trailing underscore|
|Mandatory|E051|Basic query specification|4|GROUP BY can contain columns not in
<select list>|
|Mandatory|E051|Basic query specification|9|Rename columns in the FROM clause|
|Mandatory|E071|Basic query expressions|1|UNION DISTINCT table operator|
|Mandatory|E141|Basic integrity constraints|1|NOT NULL constraints|
|Mandatory|E153|Updatable queries with subqueries| | |
|Mandatory|E161|SQL comments using leading double minus| | |
|Mandatory|F041|Basic joined table|5|Outer joins can be nested|
|Mandatory|F041|Basic joined table|7|The inner table in a left or right outer
join can also be used in an inner join|
|Optional|F302|INTERSECT table operator|2|INTERSECT ALL table operator|
|Optional|F304|EXCEPT ALL table operator| | |
|Optional|F391|Long identifiers| | |
|Optional|F393|Unicode escapes in literals| | |
|Optional|F561|Full value expressions| | |
|Optional|F851|<order by clause> in subqueries| | |
|Optional|F855|Nested <order by clause> in <query expression>| | |
|Optional|F863|Nested <result offset clause> in <query expression>| | |
|Optional|T121|WITH (excluding RECURSIVE) in query expression| | |
|Optional|T122|WITH (excluding RECURSIVE) in subquery| | |
|Optional|T351|Bracketed SQL comments (/*...*/ comments)| | |
|Optional|T434|GROUP BY DISTINCT| | |
|Optional|T501|Enhanced EXISTS predicate| | |
|Optional|T551|Optional key words for default syntax| | |
|Mandatory|T631|IN predicate with one list element| | |
|Optional|T828|JSON_QUERY| | |
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
