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)
