[IGNITE-21956] SQL Features tests. Phase 2

• Type: Epic
• Status: Resolved
• Priority: Major
• Resolution: Done
• Component/s: sql
• Labels: ignite-3
• Epic Name: Sql. Extend test coverage for SQL-standard features. Phase 2
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Unassigned
• Reporter: Iurii Gerzhedovich
• Created: 03/Apr/24 13:45
• Updated: 26/Jun/24 13:10
• Resolved: 26/Jun/24 13:10

Description

We have a set of SQL features that have poor test coverage.
Let’s improve that.
List of features to improve test coverage:

Feature type	Feature id	Feature Name	sub feature id	sub feature name
Mandatory	E021	Character string types	10	Implicit casting among the character string types
Mandatory	E021	Character string types	11	POSITION function
Mandatory	E021	Character string types	12	Character comparison
Mandatory	E031	Identifiers	1	Delimited identifiers
Mandatory	E061	Basic predicates and search conditions	7	Quantified comparison predicate
Mandatory	E071	Basic query expressions	2	UNION ALL table operator
Mandatory	E091	Set functions	1	AVG
Mandatory	E091	Set functions	6	ALL quantifier
Mandatory	E141	Basic integrity constraints	7	Column defaults
Mandatory	F031	Basic schema manipulation	4	ALTER TABLE statement: ADD COLUMN clause
Mandatory	F051	Basic date and time	6	CURRENT_DATE
Mandatory	F051	Basic date and time	7	LOCALTIME
Mandatory	F051	Basic date and time	8	LOCALTIMESTAMP
Mandatory	F201	CAST function
Mandatory	F221	Explicit defaults
Optional	F302	INTERSECT table operator	1	INTERSECT DISTINCT table operator
Optional	F661	Simple tables
Optional	F781	Self-referencing operations
Optional	F861	Top-level <result offset clause> in <query expression>
Optional	F862	<result offset clause> in subqueries
Optional	T021	BINARY and VARBINARY data types
Optional	T031	BOOLEAN data type
Optional	T621	Enhanced numeric functions
Optional	T624	Common logarithm functions

Issue Links

• is related to: IGNITE-21915 Sql. Add test coverage for SQL-standard features. Phase 1