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)