[
https://issues.apache.org/jira/browse/IGNITE-21518?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Iurii Gerzhedovich updated IGNITE-21518:
----------------------------------------
Epic Link: IGNITE-20729
> 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
> Priority: Major
> Labels: ignite-3
>
> 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)
