[IGNITE-7236] SQL: create tests for optimized INSERT and MERGE operations

• Type: Task
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Component/s: sql
• Assignee: Unassigned
• Reporter: Vladimir Ozerov
• Created: 19/Dec/17 08:19
• Updated: 14/Feb/19 15:26
• Resolved: 14/Feb/19 15:26

Description

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).

Issue Links

• is related to: IGNITE-4490 Optimize DML for fast INSERT and MERGE