[jira] [Created] (IGNITE-21518) Sql. Improve test coverage for DDL

["Iurii Gerzhedovich (Jira)" <ji...@apache.org>]

Iurii Gerzhedovich created IGNITE-21518:
-------------------------------------------

             Summary: Sql. Improve test coverage for DDL
                 Key: IGNITE-21518
                 URL: https://issues.apache.org/jira/browse/IGNITE-21518
             Project: Ignite
          Issue Type: Improvement
          Components: sql
            Reporter: Iurii Gerzhedovich


During implementation of DDL were added set of tests. However added set of tests is insufficient.

Let's add the following test scenarios:
h4. Unit Testing:
 * Tests for SQL parser required additional test to for each DDL command, every option, every data type. Partial already covered, but not for all data types
 * Tests for components that handle DDL commands: test case each DDL command, every option, every data type. Partialy already covered, but not for all data types.

h4.  Functional and E2E tests:
TABLE:
* Effects of DDL operations should be observable via all access API. Partialy already covered, but not for all  combinations of data type and API access type.
* check that it is possible to perform operations against a newly created table via all available APIs.
* check that primary key columns are not modifiable (no SQL tests).

DEFAULTS:
* check that a column is set to a value equal to DEFAULT, if the DEFAULT keyword is used in insert operation instead of a value (not all types are covered right now).
* check that it is not allowed to set a value of another type as DEFAULT value (some types are not covered).
* check that a value specified as DEFAULT lies in the domain of values for that data type.
* check that DEFAULT does not support expressions - only literals and function names.
* check that null constraint makes columns nullable.
* check that DROP DEFAULT is supported.

INDEX:
* check that if an index type is not specified (via USING clause), a tree (sorted) index is created. 
* Sorted/Tree index should support NULLS FIRST, NULLS LAST options for both ASC and DESC orderings.
* check that after an index is dropped plans that previously used an index no longer use such index.

TRANSACTIONS:
* execution of a DDL operation via JDBC Connection with auto-commit flag set to false return an error.




--
This message was sent by Atlassian Jira
(v8.20.10#820010)