[jira] [Created] (IGNITE-7236) SQL: create tests for optimized INSERT and MERGE operations

[Anton Vinogradov (Jira)]

Vladimir Ozerov created IGNITE-7236:
---------------------------------------

             Summary: SQL: create tests for optimized INSERT and MERGE operations
                 Key: IGNITE-7236
                 URL: https://issues.apache.org/jira/browse/IGNITE-7236
             Project: Ignite
          Issue Type: Task
          Components: sql
            Reporter: Vladimir Ozerov
            Assignee: Alexander Paschenko
             Fix For: 2.4


Important optimization IGNITE-4490 was added to the product. However, it lacks excessive tests coverage. We need to test the following scenarios:
1) Various data types (especially dates)
2) Single updates vs batched updates
3) Constants and nulls (e.g. {{INSERT INTO ... VALUES (a, b)}})
4) Parameters (e.g. {{INSERT INTO ... VALUES (?, ?)}})
5) Multiple SQL statements at once (e.g. {{INSERT INTO ...; INSERT INTO ...}})
6) Insert multiple lines at once ({{INSERT INTO ... VALUES (a1, b1), (a2, b2)}})
7) Insert multiple lines with parameters
8) Invalid parameters count in different query types - need to make sure that we throw correct errors.

All tests except of p.8 should check both correctness and the fact that query was executed without H2 involvement (e.g. using some code hack).



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)