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)
