[jira] [Commented] (IGNITE-14553) Calcite engine. Duplicated result on insert

["Aleksey Plekhanov (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IGNITE-14553?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17325087#comment-17325087 ] 

Aleksey Plekhanov commented on IGNITE-14553:
--------------------------------------------

Without MVCC already inserted by the current query data can be processed by this query again. 

Here one more reproducer to show this issue:

 
{code:java}
public void testInsertAsSelect() throws Exception {
    QueryEngine engine = Commons.lookupComponent(grid(1).context(), QueryEngine.class);
    engine.query(null, "PUBLIC", "CREATE TABLE test (epoch_cur int, epoch_copied int)");
    engine.query(null, "PUBLIC", "INSERT INTO test VALUES (0, 0)").get(0).getAll();
    for (int i = 1; i < 16; i++) {
        engine.query(null, "PUBLIC", "INSERT INTO test SELECT ?, epoch_cur FROM test", i).get(0).getAll();
        List<List<?>> rows = engine.query(null, "PUBLIC", "SELECT * FROM test WHERE epoch_copied = ?", i).get(0).getAll();
        assertEquals("Unexpected rows for epoch " + i, rows.size(), 0);
    }
}
{code}
 

 

> Calcite engine. Duplicated result on insert
> -------------------------------------------
>
>                 Key: IGNITE-14553
>                 URL: https://issues.apache.org/jira/browse/IGNITE-14553
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>            Reporter: Konstantin Orlov
>            Priority: Blocker
>
> Please see the test {{modules/calcite/src/test/sql/types/string/test_scan_big_varchar.test_ignore}}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)