ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vladimir Ozerov (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-7236) SQL: create tests for optimized INSERT and MERGE operations
Date Tue, 19 Dec 2017 08:20:00 GMT
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

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

View raw message