[IGNITE-21915] Sql. Add test coverage for SQL-standard features. Phase 1

• Type: Epic
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: sql
• Labels: ignite-3
• Epic Name: SQL Features tests. Phase 1
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Iurii Gerzhedovich
• Created: 02/Apr/24 15:48
• Updated: 14/May/24 08:06

Description

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

 

Issue Links

• relates to: IGNITE-21956 SQL Features tests. Phase 2