[IGNITE-18799] Sql. Custom types. Implement a basic set of test cases for a custom data type.

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.0
• Fix Version/s: 3.0
• Component/s: sql
• Labels: calcite2-required ignite-3
• Epic Link: SQL. Custom types support 3.0
• Ignite Flags: Docs Required, Release Notes Required
• Assignee: Maksim Zhuravkov
• Reporter: Maksim Zhuravkov
• Created: 14/Feb/23 11:20
• Updated: 04/Sep/24 16:22
• Resolved: 25/Apr/23 08:47

Description

To simplify the process of adding a new custom data type it would be a good idea to have a basic set of test cases that automates (at least partially) the process of writing tests for a new custom data type.

Ddl

• CREATE TABLE (as non-primary key column)
• CREATE TABLE (as a primary key, if supported)

Dml

• INSERT
• UPDATE

Queries

• SELECT
• (WHERE clause)
• ?

Expressions

• Binary comparison operators
• IN expression
• CASE expression
• CASTS (if supported)
• BETWEEN expression
• COALESCE
• ?

Aggregate functions

• Min/Max
• Some, Every
• Other functions (if supported)

Other

• Dynamic Parameters
• ?

If a custom data type supports implicit casts from some type the above checks for <custom_type> v <another type> must be also provided.

Issue Links

• links to: GitHub Pull Request #1849