[IGNITE-4334] DML: INSERT INTO SELECT FROM statement fails if copy from partitioned to replicated cache

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 1.8
• Fix Version/s: 1.8
• Component/s: general
• Assignee: Alexander Paschenko
• Reporter: Sergey Kozlov
• Created: 29/Nov/16 19:39
• Updated: 30/Nov/16 09:54
• Resolved: 30/Nov/16 09:25

Description

INSERT INTO SELECT FROM statement fails if executed on a replicated cache and used partitioned cache as data source:

test.java

    public static void main(String[] args) throws Exception {
        Ignition.setClientMode(true);

        final Long PRELOAD_NUM = 1_000L;

        List<String> cacheNames = Arrays.asList(
                "tx-part-full-sync",
                "tx-repl-full-sync",
        );

        String srcCache = null;
        try (Ignite ig = Ignition.start("examples/config/ext-sql.xml")) {

            for (String cacheName : cacheNames) {

                //ig.cache(cacheName).query(new SqlFieldsQuery("delete from AllTypes"));

                if (srcCache == null) {
                    // data preloading here
                   // .........
                    srcCache = cacheName;
                }
                else {
                    ig.cache(cacheName).query(new SqlFieldsQuery("insert into AllTypes (_key, _val) select _key, _val from \"" + srcCache + "\".AllTypes"));
                }
                System.out.println("The cache size " + cacheName + ": " + ig.cache(cacheName).sizeLong());
            }

        }

Exception in thread "main" javax.cache.CacheException: Queries running on replicated cache should not contain JOINs with partitioned tables [rCache=tx-repl-full-sync, pCache=tx-part-full-sync]
	at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.stableDataNodes(GridReduceQueryExecutor.java:432)
	at org.apache.ignite.internal.processors.query.h2.twostep.GridReduceQueryExecutor.query(GridReduceQueryExecutor.java:529)
	at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing$5.iterator(IgniteH2Indexing.java:1119)
	at org.apache.ignite.internal.processors.cache.QueryCursorImpl.iterator(QueryCursorImpl.java:98)
	at org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.doInsert(DmlStatementsProcessor.java:700)
	at org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.executeUpdateStatement(DmlStatementsProcessor.java:282)
	at org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.updateSqlFields(DmlStatementsProcessor.java:155)
	at org.apache.ignite.internal.processors.query.h2.DmlStatementsProcessor.updateSqlFieldsTwoStep(DmlStatementsProcessor.java:185)
	at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryTwoStep(IgniteH2Indexing.java:1266)
	at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:812)
	at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:810)
	at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36)
	at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:1777)
	at org.apache.ignite.internal.processors.query.GridQueryProcessor.queryTwoStep(GridQueryProcessor.java:810)
	at org.apache.ignite.internal.processors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:749)
	at org.apache.ignite.examples.datagrid.ExtSqlExample.main(ExtSqlExample.java:221)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at com.intellij.rt.execution.application.AppMain.main(AppMain.java:147)